Confusion - Additional MySQL Access Hosts

[jimpoo]

Hi There,
In my case, I have three servers:

W1 - cPanel/WHM is installed,
D1 - a dedicated mysql server
D2 - a dedicated mysql server

Let's say I will host 400 websites on W1, I wanted website#1 to #200 to use D1, and website#201 to #400 to use D2 as their mysql server.

Something confuse me:
1. It seems like there are 3 places where I can configure the remote mysql servers. They are:

In WHM: Main >> SQL Services >> Additional MySQL Access Hosts
In WHM: Main >> SQL Services >> Setup Remote MySQL server
In cPanel: Databases >> Remote MySQL

Then, what are the differences among these functions?

2. For my case, how do I configure cPanel and/or WHM?

Thank you for advance.

 

[thewebhosting]

Let me try to explain!

Additional MySQL Access hosts: Sometime you may be in a need to use the same MySQL database for two different websites hosted on different servers. In that time you need to use the IP address of other web server (for which you wish to use the same database) in this option to allow connection.

Note: Users must login to their cPanel and enter the mysql manager before these additional hosts will become active.

Remote MySQL: It allows you to use a MySQL server on a different machine to hold your databases.

I think you will have to choose second option to set up additional MySQL server.

Thanks!

 

[cPanelDavidG]

Remote MySQL: It allows you to use a MySQL server on a different machine to hold your databases.

This is what WHM: Main >> SQL Services >> Setup Remote MySQL server does. This will mean you're hosting ALL databases on a single remote server.

Multiple remote MySQL servers (in the sense of Account A uses Database Server 2, Account B uses Database Server 1 etc.) are not natively supported at this time.


cPanel: Databases >> Remote MySQL is for your individual hosting customers who want to access their databases remotely (e.g. read the databases from their PC or another server).

 

[Spiral]

Hi There,
In my case, I have three servers:

W1 - cPanel/WHM is installed,
D1 - a dedicated mysql server
D2 - a dedicated mysql server

Let's say I will host 400 websites on W1, I wanted website#1 to #200 to use D1, and website#201 to #400 to use D2 as their mysql server.

Before getting into the configuring of these, let me ask you a couple of questions ...

Why do you have separate database servers instead of using the database server built into your Cpanel / WHM server?

Why are two machines dedicated to MySQL only?

Are the machines in the same physical location (same data center)?

More specifically, what is your reasoning for setting up things this way and is there some particular special purpose behind it?

Under normal circumstances, putting web hosting accounts and database servers on separate machines would cause substantial performance loss on the machine hosting the web hosting accounts which is even more severe if you have to make a connection through the open internet to another physical location to reach the database server. If you are trying to separate the MySQL databases from the hosting accounts for performance reasons then you are actually doing the exact opposite of what you intended and would be much better off splitting the hosting accounts between the machines each with their own local MySQL database server or getting rid of the extra machines and putting the money into upgrades and more memory for your main hosting machine, either of which will give you better performance than the configuration you are asking about now.

If there is some unusual purpose outside of performance concerns, tell us here and I might be able to tell you the best way to implement exactly what it is that you are really trying to do.

 

[jimpoo]

Before getting into the configuring of these, let me ask you a couple of questions ...

Why do you have separate database servers instead of using the database server built into your Cpanel / WHM server?

Why are two machines dedicated to MySQL only?

Are the machines in the same physical location (same data center)?

More specifically, what is your reasoning for setting up things this way and is there some particular special purpose behind it?

Under normal circumstances, putting web hosting accounts and database servers on separate machines would cause substantial performance loss on the machine hosting the web hosting accounts which is even more severe if you have to make a connection through the open internet to another physical location to reach the database server. If you are trying to separate the MySQL databases from the hosting accounts for performance reasons then you are actually doing the exact opposite of what you intended and would be much better off splitting the hosting accounts between the machines each with their own local MySQL database server or getting rid of the extra machines and putting the money into upgrades and more memory for your main hosting machine, either of which will give you better performance than the configuration you are asking about now.

If there is some unusual purpose outside of performance concerns, tell us here and I might be able to tell you the best way to implement exactly what it is that you are really trying to do.

The purpose to separate the mysql server from the cpanel (web) server is that we wanted to be able to do mysql cluster and web server load balancing in the future. cPanel is only for website account creation .

We are hosting ecommerce shopping cart for customers, each website requires a mysql database. Our servers are networked in a virtual rack.

Then, what would be a good server solution for the ability to host a few thousands of ecommerce websites that each comes with a standalone mysql db?
Let's say 10% of these websites will take about 80% of the total server traffics.

Thank you,