Using remote mysql

[AlexCl]

Hello,

I currently use a server with these specs:

Intel Xeon X3440
2x1.5 TB HDD + 1x 60 GB SSD ( for mysql )
16 GB RAM
100 mbps connectivity
Cpanel

As Mysql usage is growing and space is starting to get low, I was thinking of moving MySQL to a different server and using this server for /home only. The new server would have similar specs, just the drives would be 2x120 GB SSD or 2x240 SSD. What would the downside of using this setup be ? Would it take longer for websites using mysql to load ? Anything else ?

Also, would I need Cpanel on the MySQL server?

Thank you.

 

[MilesWeb]

Hello,

I currently use a server with these specs:

Intel Xeon X3440
2x1.5 TB HDD + 1x 60 GB SSD ( for mysql )
16 GB RAM
100 mbps connectivity
Cpanel

As Mysql usage is growing and space is starting to get low, I was thinking of moving MySQL to a different server and using this server for /home only. The new server would have similar specs, just the drives would be 2x120 GB SSD or 2x240 SSD. What would the downside of using this setup be ? Would it take longer for websites using mysql to load ? Anything else ?

Also, would I need Cpanel on the MySQL server?

Thank you.

SAS/SSD drives for just MySQL is always a good option. Try getting the server in the same rack and connect the MySQL over a private network. This will minimize the latency when connecting the remote database. I don't just for MySQL you need a cPanel. If you wish to manage the MySQL users, use phpMyadmin good to go with cPanel.

 

[AlexCl]

I do have another question: will the mysql DBs be backed up when backup runs on the cPanel server ?

 

[cPanelMichael]

Hello

cPanel is not required on the remote MySQL server. You can find documentation on setting it up at:

Setup Remote MySQL Server

The "Per Account" MySQL database backups will continue when using a remote MySQL server provided the databases were created in cPanel. I recommend testing a backup generation after setting up the remote MySQL server to make sure it works as you intend it to.

Thank you.

 

[AlexCl]

Hi Michael,

Thank you very much for the information and link. I will do some testing as you suggested.

Have a great day!