MySQL Private: What is it?

By default, your databases coexist with the databases of other clients on the same shared SQL server. The server capacities (processor, memory, disk...) are common to all databases.

The MySQL Private service allows you to have your own MySQL server, so the server resources are no longer shared: they are dedicated to your databases and allow, among other things, to use "events" and "triggers" or to manage several users with different levels of access to the databases.

The management of SQL databases and users is done entirely from the panel, so you continue to enjoy all the comfort of web hosting while benefiting from the performance and flexibility of a dedicated SQL server.

Benefits

The MySQL Private option is perfect for hosting large databases. You are only limited by the total size of your server's disk space.

Dedicated CPU

By default on a web hosting, the CPU power is distributed among the requests of the different hosted clients. With the MySQL Private option, you have your own CPU. This way, your requests do not wait for possible cycles and are processed instantly by your server.

Dedicated MySQL cache

MySQL has a query cache. This is a fundamental element that allows you to considerably speed up the processing of repetitive requests (used to load your home page for example). A shared cache is less available for each client and therefore less efficient. With the MySQL Private option, you have your own dedicated cache that can be adjusted from the panel, so all your queries can benefit from it, all the time.

SSD storage

Your MySQL Private Server is equipped with ultra-fast SSDs. The performance of these next-generation drives is unmatched by standard mechanical platter drives. Since MySQL is likely to be very demanding on the disks, you'll get amazing performance, especially when writing your data (INSERT, UPDATE...)

Managed by us

Who says dedicated server says server administration. We take care of all the administration at 100%. You don't have to worry about operation, monitoring, backups, updates, and security of the server.

... Driven by you!

You manage your databases from your Customer Area, in a few clicks, in the same way as your standard databases.

Access to PhpMyAdmin is available for the management of your databases.

Ordering the MySQL Private option

You can order this option from your customer area. To do this, simply go to the section MarketPlace->MySQL Private from your Customer Area.

Several features to choose from:

• MySQL 1Core: CPU: 1 Core - RAM: 1 GB - Space: 6 GB
• MySQL 2Cores: CPU: 2 Cores - RAM: 2 GB - Space: 25 GB
• MySQL 4Cores: CPU: 4 Cores - RAM: 4 GB - Space: 40 GB

Once the quote is created, all you have to do is to pay it which will activate the option.

Finally, it is possible to order several MySQL Privés.

Activation of the MySQL Private option

Activating this option results in the automatic creation of your MySQL server.

Activating the service has no impact on the standard MySQL databases that come with your web hosting: they continue to work as before, and you can perfectly continue to use them alongside your private MySQL server if you see the need.

WARNING If you already have functional applications on your hosting and active databases, you must migrate them (see next paragraph). Activating this option does not trigger the automatic migration of your databases.

Migration of your databases

If you already have standard databases actively used by your applications, then it is necessary to migrate them to your MySQL Private server. Of course, you can do this migration using the Export/Import functions of PhpMyAdmin. But to make it easier for you, you have the possibility to copy and/or move your databases from your shared hosting to your dedicated SQL from the panel.

The migration of a database usually takes a few minutes. When it is completed, you will receive a confirmation e-mail. At the same time, we invite you to prepare the new PHP configuration files of your applications to indicate your new MySQL identifiers. Then upload them when the migration is completed.

WARNING : The migration tool does not modify the configuration files of your applications! As mentioned above, you must manually modify these files. Otherwise, even though your database has been migrated to your MySQL Private server, your applications will continue to send their queries to your standard databases!