Hexy Templates

Mariadb

MariaDB server is a community developed fork of MySQL server.

Not yet tested database Based on TrueNAS app v1.1.13 (Mariadb 13.0.2)
Project website TrueNAS app source Script on GitHub Report a problem
  1. 1
    Copy the script below
  2. 2
    In HexOS, open Apps, find Mariadb and choose Custom Install
  3. 3
    Paste, then press Install — full guide with screenshots
mariadb.json
Download 
1{
12  "version": 5,
23  "script": {
4    "version": "0.1.0",
5    "changeLog": "Auto-generated draft from TrueNAS mariadb 1.1.13"
6  },
37  "installation_questions": [
8    {
9      "question": "User",
10      "type": "text",
11      "key": "user",
12      "required": true
13    },
14    {
15      "question": "Password",
16      "type": "password",
17      "key": "password",
18      "required": true
19    },
20    {
21      "question": "Database",
22      "type": "text",
23      "key": "database",
24      "required": true
25    }
26  ],
27  "requirements": {
428    "locations": ["ApplicationsPerformance"],
529    "specifications": ["2CORE"],
630    "permissions": ["READ_WRITE_LOCATIONS"],
731    "ports": [3306]
32  },
833  "ensure_directories_exists": [
34    {"path": "$LOCATION(ApplicationsPerformance)"},
35    {"path": "$LOCATION(ApplicationsPerformance)/mariadb"},
36    {
37      "path": "$LOCATION(ApplicationsPerformance)/mariadb/data",
38      "snapshot": {"id": "data"}
39    }
40  ],
41  "app_values": {
42    "mariadb": {
943      "user": "$QUESTION(user)",
1044      "password": "$QUESTION(password)",
1145      "database": "$QUESTION(database)",
1246      "root_password": "$RANDOM_STRING(16)"
47    },
48    "storage": {
1349      "data": "$HOST_PATH($LOCATION(ApplicationsPerformance)/mariadb/data)"
50    },
51    "network": {
1452      "tcp_port": {"bind_mode": "published", "port_number": 3306}
53    },
1554    "resources": {"limits": {"cpus": 2, "memory": "$MEMORY(10%, 4096)"}}
55  }
56}

What this script does

Hover or tap a box to see the lines it explains.

  1. Script format

    Tells HexOS this is a version 5 install script, so it knows how to read the rest.

    Line 2

  2. Script revision

    This copy of the script is revision 0.1.0. Latest change: “Auto-generated draft from TrueNAS mariadb 1.1.13”.

    Lines 3–6

  3. Questions you'll be asked

    Before installing, HexOS will ask you for: User, Password and Database. Your answers are slotted into the settings further down wherever you see $QUESTION(...).

    Lines 7–26

  4. Storage locations it needs

    The app uses these HexOS storage locations: App storage (fast). If one isn't set up yet, HexOS will ask you to pick a place for it.

    Line 28

  5. Minimum hardware

    Recommended minimum: 2 CPU cores.

    Line 29

  6. Permission to use your folders

    Allows the app to read and write files inside the storage locations listed above — and nowhere else.

    Line 30

  7. Network ports

    The app needs port 3306 to be free on your server. A port is like an apartment number for your server's address.

    Line 31

  8. Folders created on install

    Creates the folders the app needs before it starts: App storage (fast) › mariadb and App storage (fast) › mariadb › data. Folders marked “snapshot” are included in HexOS snapshots, so you can roll them back.

    Lines 33–40

  9. Your answer: user

    Filled in with what you typed for “user” when you installed.

    Line 43

  10. Your answer: password

    Filled in with what you typed for “password” when you installed.

    Line 44

  11. Your answer: database

    Filled in with what you typed for “database” when you installed.

    Line 45

  12. Auto-generated root password

    HexOS makes up a long random root password during install. It's only used inside Mariadb, so you never need to know it.

    Line 46

  13. Where the app's main data is saved

    Where the app's main data is saved on your server: App storage (fast) › mariadb › data.

    Line 49

  14. Tcp port: 3306

    Publishes the app's tcp port as 3306.

    Line 52

  15. Resource limits

    Caps how much of your server the app can use: 2 CPU cores and 10% of your server's memory, but never more than 4 GB. This keeps one busy app from slowing everything else down.

    Line 54