Stackhero for MariaDB

This add-on is operated by Stackhero

MariaDB on dedicated instances, up-to-date versions and super attractive prices.

Stackhero for MariaDB

Last updated January 13, 2022

The Stackhero for MariaDB add-on is currently in beta.

Stackhero for MariaDB provides a managed MariaDB instance running on a fully dedicated instance.

The Stackhero for MariaDB add-on provides the following features:

  • A private instance (dedicated VM)
  • A dedicated public IP (v4)
  • TLS encryption (aka SSL)
  • A full access to PhpMyAdmin
  • An automatic backup every 24 hours
  • One click to update to new MariaDB versions

Provisioning the Add-on

Stackhero for MariaDB can be attached to a Heroku application via the CLI:

A list of all plans available can be found here.

$ heroku addons:create ah-mariadb-stackhero --app <your app name>
-----> Adding ah-mariadb-stackhero to sharp-mountain-4005... done

After provisioning Stackhero for MariaDB, the STACKHERO_MARIADB_HOST and STACKHERO_MARIADB_ROOT_PASSWORD config variables are available in your app’s configuration. They contain the URLs to your MariaDB instance as its root password.

See the content of those variables via the heroku config:get command:

$ heroku config:get STACKHERO_MARIADB_HOST

Local Setup

Use the Heroku Local command-line tool to configure, run, and manage process types specified in your app’s Procfile. Heroku Local reads configuration variables from an .env file. Use heroku config to view your app’s config variables. Use the following command for each value that you want to add to your .env file:

heroku config:get <STACKHERO_MARIADB_VARIABLE> -s  >> .env

For example:

$ heroku config:get STACKHERO_MARIADB_HOST -s  >> .env

Don’t commit credentials and other sensitive configuration values to source-control. In Git, exclude the .env file with: echo .env >> .gitignore.

For more information, see Heroku Local.

Connecting to MariaDB

Connect to MariaDB using a client library that can connect to a MariaDB or MySQL server.

Use the following environment variables to connect using a dedicated user:

  • STACKHERO_MARIADB_HOST
  • STACKHERO_MARIADB_USER
  • STACKHERO_MARIADB_PASSWORD

If you connect with the “root” user, use the following environment variables:

  • STACKHERO_MARIADB_HOST
  • STACKHERO_MARIADB_ROOT_PASSWORD

We recommend connecting with a dedicated user. Don’t use the “root” user.

Connecting to the Stackhero Dashboard

You can see your instance usage, restart your instance, and apply updates from the Stackhero dashboard. You can also access the PhpMyAdmin console web UI.

Access the dashboard via the CLI:

$ heroku addons:open ah-mariadb-stackhero
Opening ah-mariadb-stackhero for sharp-mountain-4005

You can also visit the Heroku Dashboard, select your application, and then select Stackhero for MariaDB from the Add-ons menu.

Connecting to PhpMyAdmin

PhpMyAdmin provides a graphical web UI for MariaDB.

To connect to PhpMyAdmin:

  1. Open the Stackhero for MariaDB console, and then select your MariaDB service.
  2. Select Configure, and then copy the PhpMyAdmin user and password.
  3. Return to the Configure screen, and then select PhpMyAdmin.
  4. Login with the PhpMyAdmin user and password credentials.

Creating a MariaDB User

We recommend creating a user for your app. Do not use the default ‘root’ user. To create a user with PhpMyAdmin:

  1. In PhpMyAdmin, select User accounts on top.

  2. Select Add user account.

  3. Fill the user creation form:

    • Specify an account name (usually your application name).
    • Choose Generate password to generate a secure password, and then copy it to your clipboard.
    • Check the Create database with same name and grant all privileges

  4. Select Go to create the user and the database. The database name is the same as the user. The database will contain the user as a user account.

Adding a New User to the Environment Variables

Define environment variables containing your username and password:

$ heroku config:set STACKHERO_MARIADB_USER=<yourUserName>
$ heroku config:set STACKHERO_MARIADB_PASSWORD=<yourUserPassword>

Don’t use “root” credentials in your apps. Create a dedicated user instead.

To access them locally, save them to your .env file:

$ heroku config:get STACKHERO_MARIADB_USER -s  >> .env
$ heroku config:get STACKHERO_MARIADB_PASSWORD -s  >> .env

Don’t commit credentials and other sensitive configuration values to source-control. In Git, exclude the .env file with: echo .env >> .gitignore.

Upgrading Your Plan

You can’t downgrade an existing add-on.

Use the heroku addons:upgrade command to migrate to a new plan.

$ heroku addons:upgrade ah-mariadb-stackhero:newplan
-----> Upgrading ah-mariadb-stackhero:newplan to sharp-mountain-4005... done
       Your plan has been updated to: ah-mariadb-stackhero:newplan

Manage migration timing to ensure your application is available during the migration process.

Removing the Add-on

You can remove Stackhero for MariaDB via the CLI:

This destroys all associated data and can’t be undone!

$ heroku addons:destroy ah-mariadb-stackhero
-----> Removing ah-mariadb-stackhero from sharp-mountain-4005... done

Support

Stackhero for MariaDB support and runtime issues should be submitted via one of the Heroku Support channels. We recommend adding support@stackhero.io in copy for urgent issues.

Additional Resources

Feedback

Log in to submit feedback.