Hi All,
I have been reading some threads on setting up remote mysql. I really would like to do this to relieve some load on the cpanel server.
From what I gather, I will install a second network card in the cpanel server and assign the interface a lan address. The new mysql server will have an ip address in the same network.
After it is setup, what I don't understand is what happens next? Do I have to manually move databases to the new server? And, if so, do I need to edit my clients web files in order to tell the config or dbsetup files the new ip address of the server? What about new databases?
There are so many unanswered questions on this topic that I Cannot find the answers too.
Thanks.
I have been reading some threads on setting up remote mysql. I really would like to do this to relieve some load on the cpanel server.
From what I gather, I will install a second network card in the cpanel server and assign the interface a lan address. The new mysql server will have an ip address in the same network.
After it is setup, what I don't understand is what happens next? Do I have to manually move databases to the new server? And, if so, do I need to edit my clients web files in order to tell the config or dbsetup files the new ip address of the server? What about new databases?
There are so many unanswered questions on this topic that I Cannot find the answers too.
Thanks.