Adding MySQL Servers to Offload MySQL Processes

craigedmonds

• June 02, 2016 09:33

I have two cpanel servers. Server1 has web sites on it and mysql. Server2 has no web sites on it. Server1 is starting to get a bit "podgy" with some of the mysql requests and my idea of Server2 was to move the mysql databases to so that Server1 does not have to handle mysql processes. Is this the best way or can I somehow "link" Server2 to Server1 so that Server2 takes some of the Mysql work away from Server1?

• 

  tank

  • June 03, 2016 02:51

  Why not just make server 2 MYSQL ? Your kind of getting into load balancing with what you described, I really not the familiar with that.

  0
• 

  twhiting9275

  • June 03, 2016 05:37

  Hi there, You should be able to do what you're after with MySQL clustering For some reason, cPanel calls this 'MySQL profiles' but essentially it's the same thing.

  0
• 

  craigedmonds

  • June 03, 2016 07:51

  Hi there, You should be able to do what you're after with MySQL clustering For some reason, cPanel calls this 'MySQL profiles' but essentially it's the same thing.

  
  Ah ok, maybe this is what I am looking for. As @tank suggested I could just simply move the database from server1 and use server2 purely as mysql server but if I can leave the mysql where it is but add some extra "oooomph" to the server by adding a second server to take up some of the mysql process then this will be ideal. I am off to investigate now!!

  0
• 

  cPanelMichael

  • June 07, 2016 14:41

  Hello, You can find additional information on the following document if you decide to make the second server a MySQL database server:

  0
• 

  craigedmonds

  • June 07, 2016 15:36

  Hello, You can find additional information on the following document if you decide to make the second server a MySQL database server:

  0
• 

  cPanelMichael

  • June 15, 2016 15:20

  Hello, The following URL continues to load well from multiple locations:

  0
• 

  craigedmonds

  • June 16, 2016 08:19

  Hello, The following URL continues to load well from multiple locations:

  0
• 

  cPanelMichael

  • June 20, 2016 21:09

  It looks like a cached version of the page is still active. You can try using the following alternate URL if the initial URL fails to load: Manage MySQL" Profiles - Documentation - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.