cPanel & WHM Version 82 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
 

Multiple remote MySQL database servers

Nathan Lierbo shared this idea 6 years ago
Open Discussion

Forking item from another thread:

Having multiple remote MySQL database servers.


You can review the original thread and comments at: http://forums.cpanel.net/f145/multiple-remote-mysql-database-servers-259571.html

Comments (7)

photo
2

Not only would it be nice to have multiple servers and to specify which users can create databases on which servers but this would also allow us to supply multiple mysql versions having for instance, mysql 5.5, mariadb and mysql 5.6 on three different servers and shaed between multiple cPanel servers allowing users to select which one they want to create a database on.

photo
1

Plesk already has this.

The other thing about this is having different service levels, a standard dbase for normal customers and an SSD dbase for others.

photo
1

Highly appreciated...

What do you think cPanel? When can we get it?

Please, listen to this and related topics.

photo
2

Hello,


We've been looking into database cluster systems recently, and some systems like MariaDB enterprise cluster or MySql galera require innodb tables.


We would like to offer users the choice of using the extra fast innodb only cluster or the standard mysiam compatible local database.


We would also like to be able to have a mysql 5.5 server and a percona 5.6 server and allow users to choose which one they want to create their database on and maybe even have the possibilty of copying their database from one to another, obviously they would have to change their database config file after the change.


This would also allow us to set up multiple VPS's on a single server and install multiple versions of mysql, even beta versions like mysql 5.7 for users who want to test the latest version with their applications before it comes out…


Thanks :)

photo
1

Would love support for this, that would allow us to setup dual master-master mysql configurations!

photo
3

This is how we we like this feature to be implemented :


In WHM, ability to add multiple mysql servers and give them a name.

Allow to keep localhost database as well as distant database servers.

In packages allow to sepecify how many databases each user can add on each database serve when set to 0 don't show the user that database server.


In cPanel, give users a dropdown list of severs when creating a new database


Give interface for admins and users to move a database from one server to another with warning about needing to update mysql hostname in connect scripts.


We want this for multiple reasons :


1) Provide different mysql engines (MySQL, Mariadb, Percona, developement branches etc.)

2) Provide private MySQL VPS instances to users (Cloudlinux is working on a docker based solution for this).

3) Spread users over multiple small mysql servers so allow to have smaller caches and smaller query cache, to have better performance and reduce the risk span of slow database queries caused by a single user.

4) Provide differerent mysql limits with different plans

5) Allow cPanel and exim's databases to be local (no network errors) and users mysql databases to be distant.

6) Allow to migrate from local to distant mysql server one user at a time causing minimal downtime.


We already have multiple PHP versions comming soon in cPanel, and already have this with phpselector.. We would basicaly like to have the same for mysql.


This would help towards creating a cluster with one or multiple servers per service instead of having all services on the same server.


This feature would obviousaly also imply that multiple cPanel servers could use the same database servers (thus working both ways) as well as a single cPanel server using multiple database servers.

photo
2

With kuberdock arriving soon, this would be extremly helpfull. A user could add a private database server in cloudlinux's Kuberdock plugin which could then add itself to the mysql wizzard allowing the user to use the wizzard to add a database to either localhost or one of his private mysql instances.