Introducing ODS – High performances SQL database infrastructure for any workloads

Post image

We are excited to announce that Online DBaaS, our fully managed SQL database solution, is ready to host all your databases under the ODS brand!

ODS gives you a direct database access without worrying about infrastructure provisioning, monitoring, backups, or common databases management operations. You can scale up and down the memory required for your databases and can initiate consistent snapshots at any time.

ODS comes with MySQL, MariaDB and PostgreSQL and is accessible from anywhere:

  • Via the Online RPN technology which provides a publicly isolated interface and allows you to inter-connect ODS with your Dedibox BareMetal servers and web hosting solutions

  • Over internet so you can inter-connect and access ODS from any infrastructure.

Everything you know about MySQL databases still applies with ODS: configurations, codes, queries work as excepted. To deploy and maintain your databases much faster, ODS comes with a large set of included features via the API or from the Online control panel:

  • Import & export so you can transport your data within an ODS database in seconds. Users, roles, passwords, data and indexes information are kept untouched so you do not waste any time.

  • Easy migration to handle your peak traffic load and easily scale up or down your memory resources on demand.

  • Database auto backup: ODS offers automated backups that runs every days with a default retention time of 45 days.

  • Firewall to allow only specific IPs to connect to your ODS instance.

  • Edit the database server settings to fit your requirements.

  • And much more.

ODS is the ideal solution for everyone looking for a fully managed and affordable database infrastructure. Storage and RAM are bundled into one unique and simple pricing with no hidden costs. Each ODS bundle is billed on a monthly basis, without commitment so you are totally free.

ODS is backed by the IBM Power8 architecture which delivers incredibly fast performances. IBM Power8 + ODS is the perfect combo to unleash your databases performances and enjoy fastest speeds and best reliability for your applications.

I you have any feedback or ideas, let us know what you'd like to see in ODS.

Showcase

ODS is really easy to use, in this section, I'll showcase the most important steps to get started with ODS. Keep in mind that you can also do everything shown in the following example using the APIs.

Order your ODS instance, and select the MariaDB version and a name for your environment.

You can create as many databases as you need per ODS instance.

Let's configure an environment with named ODS01 and configured with MariaDB 10 by clicking the "Configure" button.
You can check on the status of your newly created ODS instance at any time from the control panel:

When the status state is green, available your environment is ready to use. The first thing to do from this step is to create a new user for the database. I create a new user by clicking the "Manage" button and go to the "Users" tab.

Click the "Create User" button to add a new user.

The user created, I can create a new database and assign the role "Administrator" to the user I previously created. That way, I'll able to connect the database and import my data to the newly created database.

Go to the Databases tab and click the "Create Database" button:

Then, add new permission for the user db01user by clicking "Actions" wheel and the "New permission" link

The final step is to import your existing database and connect your application to your database. ODS natively provides a reliable and secure network access to your databases. You connect your databases via the Online RPN technology which provides a publicly isolated interface to inter-connect with your existing servers or web hosting solutions.

To dump your existing database, in a terminal execute the following command:

$ mysqldump --databases mydb01 -h www.xxx.yyy.zzz -u db01user -p > dump.sql

The command above dump your database schema and data in a file named dump.sql. To import your data in the freshly created ODS database run the following command:

mysql -p -u db01user mydb01 -P port_number_here_5278 < dump.sql  

And that’s all. I created and setup an ODS instance. As you see, I didn't have to install and configure anything, it just works.

You can easily snapshot a production database and then bring it back at any time by click the "New Backup" link.

You can retrieve and restore your backups at any time from the "Backups" tab.

We believe that ODS is a really nice complement to Web hosting and BareMetal servers and hope that you'll love it!

Run your databases on ODS now!

If you have any feedback, pricing or technical question, tweet us at @online_en or open a support ticket, we're always happy to help.

Author image

Edouard Bonlieu

Strategy and marketing at Online.net & Scaleway