Multiple Remote MySQL

[Silent Ninja]

Hello, I was checking the Remote MySQL setting on cPanel that allows automagical clusterization for the mysql, but I would like to know if there's any posibility to...


a) Use the same MySQL server to multiple cPanel servers (especially if the servers have repited users in between themselves)... for example:

SERVER 1: users paul, john, foo
SERVER 2: users mike, john, carl

SERVER MYSQL: paul, foo, mike, carl, john & john ?

The user john is repeted, how is it that cPanel handle files from both servers? Will they work both separarely or this option just works for 1 clustered mysql and 1 web server ?


b) Will in the future cPanel be able to clusterizate multiple mysql servers for the same server? Something like:

SERVER PHP
SERVER MYSQL4
SERVER MYSQL5

And the user (or administraror prefferely) will then be able to choose what accounts will be using the MYSQL4 and which others MYSQL5. It would also work as a load balancing by having 2 mysql servers and choosing some accounts on the first one and some others on the second.

 

[cPanelDavidG]

Hello, I was checking the Remote MySQL setting on cPanel that allows automagical clusterization for the mysql, but I would like to know if there's any posibility to...


a) Use the same MySQL server to multiple cPanel servers (especially if the servers have repited users in between themselves)... for example:

SERVER 1: users paul, john, foo
SERVER 2: users mike, john, carl

SERVER MYSQL: paul, foo, mike, carl, john & john ?

The user john is repeted, how is it that cPanel handle files from both servers? Will they work both separarely or this option just works for 1 clustered mysql and 1 web server ?

You can use 1 remote MySQL server with multiple cPanel/WHM servers. However, reconciling duplicate usernames is not functionality that is natively available at this time. This is something you need to handle if you are going to implement such a setup.

If this is strictly a shared hosting setup (no resellers etc.), you could build an application that uses the XML-API on multiple cPanel/WHM servers to see if that username is already in use on any cPanel/WHM server. If so, during the sign-up process, the user is prompted for another username.

b) Will in the future cPanel be able to clusterizate multiple mysql servers for the same server? Something like:

SERVER PHP
SERVER MYSQL4
SERVER MYSQL5

And the user (or administraror prefferely) will then be able to choose what accounts will be using the MYSQL4 and which others MYSQL5. It would also work as a load balancing by having 2 mysql servers and choosing some accounts on the first one and some others on the second.

I'm not going to venture to speculate here. However, we do have presentation slides that explain how our remote MySQL capabilities work and possibilities for perhaps expanding on such capabilities. You can view these slides at:

http://www.cpanel.net/conference/08/files/RemoteMYSQLServer.pdf

 

[Silent Ninja]

I've seen the PDF file, but it doesn't tell me if there will be any chance that on the future I will be able to do what I wanted.

My ideal of the server would be this:

PHP SERVER
MYSQL4 SERVER
MYSQL4 SERVER
MYSQL5 SERVER

Both M4 servers can be selected on the PHP server (there's no load balancing here, you just choose one or the other). M5 can be selected if the user needs to have that access.

It's kinda easy to setup a MySQL server and install phpMyAdmin, but I would need to manually create eacha account of the user on the corresponding server and give them a separate access to it. I want my clients to create the databases via cPanel and use the internal phpMyAdmin depending on which server I've choosen for that user to use.

This is impossible now since the cPanel Remote MySQL setup only works or it's only meant to work with one MySQL server (1 local or 1 remote only).

 

[jabotto]

You can use 1 remote MySQL server with multiple cPanel/WHM servers. However, reconciling duplicate usernames is not functionality that is natively available at this time. This is something you need to handle if you are going to implement such a setup.

If this is strictly a shared hosting setup (no resellers etc.), you could build an application that uses the XML-API on multiple cPanel/WHM servers to see if that username is already in use on any cPanel/WHM server. If so, during the sign-up process, the user is prompted for another username.

Hi,

cPanel guys should implement a new space name for users “outside” a single Apache/Mysql structure but, on the other hand, I know is a deeply change… meanwhile, I’ve wrote a couple of scripts that plays within "creation account" process and checks for user existence (to avoid duplicates) on other servers (you can configure the server look up list).

First, checks locally and then performs a servers search until found some user or not. The main process is called by an AJAX code inserted, as mentioned, on the main "creation account" template. Once a user name is "a valid one", the process dispatchs the cPanel's creation procedure. I've tested on many platforms and browsers and works fine.

No matter if is a strictly a shared hosting setup (no resellers etc.), always works.

For those interested on, you can contact me... do not fear, it's free and, of course, a GPL code.

 

[Silent Ninja]

It would be good to have the chance to use multiple servers (like windows does), because I'm now mounting a clusterized solution with an apache server, mysql remote, remote mail and ftp. But cPanel doesn't support remote mails (without messing with links and nfs), and it cannot compile (neither does rpm files) to do a remotely apache configuration.

It would be good to implement some more clustering on cPanel, and stop thinking that you'll allways use only one server for everything.

 

[jabotto]

It would be good to implement some more clustering on cPanel, and stop thinking that you'll allways use only one server for everything.

Absolutely!!!

We needs move to a cluster solution for Apache and Mysql (at least!) due to an increment on dynamic sites over the past years. The relation static/dynamic changed.

On our case, next step will be the email outside but… what is the cPanel vision regarding such a clusterization? As you mentioned, today is almost impracticable (not impossible)...