Multiple remote MySQL database servers
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
I like this idea 
cPanel, WebHost Manager and WHM are registered trademarks of cPanel, L.L.C. for providing its computer software that facilitates the management and configuration of Internet web servers.
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.
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.
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.
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.
Highly appreciated...
What do you think cPanel? When can we get it?
Please, listen to this and related topics.
Highly appreciated...
What do you think cPanel? When can we get it?
Please, listen to this and related topics.
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 :)
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 :)
Would love support for this, that would allow us to setup dual master-master mysql configurations!
Would love support for this, that would allow us to setup dual master-master mysql configurations!
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.
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.
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.
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.
Four years have gone by and many things have changed, including the implementation of MySQL profiles. But still, we can't use more than one profile. Does this feature request still make sense? I believe it does. Is there any thing planned regarding this?
Four years have gone by and many things have changed, including the implementation of MySQL profiles. But still, we can't use more than one profile. Does this feature request still make sense? I believe it does. Is there any thing planned regarding this?
Replies have been locked on this page!