ODS (ONLINE DATABASE SERVICE)

ODS 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 choose an instance depending on the amount of RAM it has.

Each GB of RAM is delivered with 2 CPU cores, based on the Power8 architecture, one of the most powerful processors, being able to handle up to 1 million requests per second!

Configuring the Instance

First, go in your console, and click on Storage. You'll have a sub-menu appearing with a ODS 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.

You can choose between:

  • MySQL 5.5
  • MySQL 5.6
  • MySQL 5.7
  • MariaDB (with TokuDB) 10.0 & 10.1
  • PostGreSQL 9.4
  • PostGreSQL 9.5
  • PostGreSQL 9.6

Using the Instance

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

You'll have :

  • The name you choose
  • The database type
  • The database 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 which type to choose, MySQL is the most common database and we recommend to use it. Gere's a quick list of the different versions:

  • 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.

Automated backups

By default and included with your ODS service, a backup is made every hour if no manual backup has been made.

The backups are being kept during 45 days (non changeable).

It is not possible to divide the manually initiated backups and those made automatically.

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 ODS.
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.

If you want to access your databases with PHPMyAdmin, you have to whitelist this IP: 62.210.185.39/32

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!

Scalability

Your ODS can increase its performances if your requirements growth.

An UPGRADE function exists, allowing you to pass to a more powerful offer.

This allows you to adapt the performance of your ODS to your needs.

To do the upgrade, click on the related button in your account:

A window will appear, allowing to choose the desired performance:

Choose and order!

You will be billed for the initially ordered performance until the end of the current month.
Starting with next month you will be billed for your new offer.

The downgrade of an offer is currently not possible.

Now enjoy your super-fast database!

Connection to MongoDB database from command-line interface

You can connect to MongoDB database by execute this command:

mongo -u $USER -p $PASSWORD - -authenticationDatabase admin $DATABASE