DBaaS (DataBase as a Service)

DBaaS is a new Online.net service, that offers you Databases as a Service. You can start as many instances as you need.

Each instance is provided with dedicated resources you can use. You can choose an instance depending on the amount of RAM it has.

For each GB of RAM included in your instance, you will get 2 dedicated cores of CPU for running it.

Our offer is based on Power 8, one of the biggest CPU available for this kind of load. It can handle up to 1 Million requests per second!

Configuring the Instance

First, go in your console, and click on Storage. You'll have a submenu appearing with a DBaaS tab.

You should see all of your instances. If not already configured, you can do it directly.

The configuration needs a name, and the SQL software & version you want.

At the moment only MySQL 5.5, 5.6, 5.7 are available. MariaDB and PostGreSQL are on the roadmap.

Using the Instance

Once properly configured, the instance will show up with different information.

You'll have :

  • The name you choose
  • The SQL Type
  • The SQL Version
  • The memory allowed
  • The public IP
  • The private IP (for the RPN Network)
  • The port

The port is NOT the default port of the SQL Server

The SQL version highly depend on your needs.
If you plan to use it with an already existent application (e.g.: WordPress, Joomla, etc.), just check on their website which version is recommended.

If you really don't know, here's a quick list of the differences:

  • MySQL 5.5 : Old, but it's a safe choice
  • MySQL 5.6 : Current version, not risky but soon to be deprecated
  • MySQL 5.7 : The latest version, it should offer the best performances

You can click on manage to create your different databases, users, and backups!

Managing your databases

The first thing you should do is create a database.
You can create as many databases as you want in your instance.
You are only limited by the resources allocated for them.

Click on CREATE DATABASE and choose a name for it.
Wait a few minutes, and it'll be available in your instance.

Managing your users

As well as the databases, you can simply manage your users from your console.

Click on the Users tab, and click on the button to create a new user.

Choose a name and a password for it.

Once done, you can check your different users available:

Managing your backups

As well as the other tab, just click on the Backup one a choose to create a new backup.

It'll ask for the concerned database:

After a while (depending on your database's size), the backup will be done and available in the console as a .gz file for you to download:

From the database

You can also access your backups from the Databases tab, by clicking on the Backups sub-tab:

The backup is done with MySQLDUMP in a single transaction for the data to remain coherent.

Managing your permissions

Here's the most interesting part: The permissions

As with a real SQL Server, you can have different users with different permissions on each of your database.

You can manage it at multiples places, but for the sake of simplicity, we'll do it through the Users tab.

Start with clicking on Manage next to your user.
Now you will be in the configuration section of the permissions of your user.
Click on ADD PERMISSION. You'll be provided with a form asking you:

  • The database
  • The granted permission

The users are the ones you previously created.
The available permissions are:

  • Administrator (all the rights)
  • Read & write
  • Read only

Here's an example with an admin user and a limited user:

From the database

It is also possible to access the user's administration from the Databases tab. Click on it and Manage the concerned Database.
You'll be inside an Access sub-tab, where you can start playing with it.

If you decide to set the permissions of your database in this way, you will be asked:

  • The user
  • The granted permission

Managing the advanced options

Click on it and Manage the concerned Database.
You'll be inside an Advanced options sub-tab, where you can start playing with it.

It allows you to configure advanced parameters of your database servers to customise and tweak it towards your specific needs.

Be careful when you change these parameters as it may have an impact on the performance of your DBaaS.
For most usage cases the default values are the best.

Managing the firewall

Click on it and Manage the concerned Database.
You'll be inside an Firewall sub-tab, where you can start configuring it.

Once the firewall is enabled only IP addresses listed in the text box are able to connect to your database to protect it from unauthorized access.
You can configure the firewall rules for both, your public interface and the RPN interface.

Using your databases

Now that you have your databases created, your users available, and the correct permissions granted, it's time to use your database.
If you are a regular user, you'll just need to provide the available connection information in your CMS or application.

However, if you are a power user, be advised that you can play with your database through command line!
Install the mysql-client package for your favorite OS, and just use it, as with a regular SQL Server!

Here's an example of connection command line:

mysql -u AdminUser -p********* --port=xxxxx -h PublicIP

Of course, replace the AdminUser, password, port and PublicIP with the information available in your panel!

Now enjoy your super-fast database!