I'm in the process of setting up remote mysql for our servers. Upon setup I am not recieving the "username" and "password" normal config like it says in the documentation.
Instead it is asking for SSH access and upon giving it the system installs all kind of cpanel stuff (completely...
I am intrested in setting up a second server to just run mysql for my site.
Now would there be a way to set it up so that all users scripts who set there mysql scripts to connect to "localhost" to be automaticly redirected to "what every ip the mysql server is"?
Or would I have to ask...
I have two servers. server1 and server2. I want to have server2 just do mysql.
One site already runs of server2's mysql (but that's server3 that does that).
When I switch the db over from server1 to 2 and enable the script it starts to lag really badly and eventually to a point where the...
since the last update cPAddon don't works longer with an external mysql server :eek:
I just got "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
it seams that the installer ignoring my remote mysql server...
I have just had 2 new servers provisioned:
Server 1 - Web/email server, running cPanel.
Server 2 - Database server, running cPanel DNS Only version.
I've got almost everything setup, just having some problems with remote MySQL.
For some reason cPanel keeps defaulting to...
Wow how great would it be to have a cpanel use two mysql servers and if one doesn't work then it rolls over to the next.
I actually don't think it would be that hard for them to set up. :D
Sorry just popped in my head.
Got the remote mysql almost working. Connection seems to be fine between both servers. But when a new account creates a db from addon scripts the only file that creates in /var/lib/mysql/use_db is : db.opt.
That file contains:
Guys, I experience strange issue. I have a server with cPanel which connects to MySQL remotely. Sometimes cPanel assigns db_users to databases properly, sometimes not. cPanel and MySQL logs don't show anything. The servers are connected via additional ethernet cards (LAN). Do you have...
There have been a lot posts concerning different issues on setting up the remote mysql server.
It seems that the root password script is being the main problem.
When you use "set up mysql remote server" the script connects to the remote host via ssh and generates new root password...
I couldn't quite find anything on this here on the forums, perhaps I was searching for the wrong stuff.
Anyhow, I just copied multiple accounts ~10 from another server and initiated full backup restoration. The restoration completed without error on all of the accounts, but I have...
I've been reading through this forum and evidentally people are using remote mysql servers with their cpanels. I'm wanting to do the same thing but run into a slight problem.
I've sync'd up the mysql database to the remote server. then rsync'd all the users databases to the remote mysql...
Can everyone say me if the backup of MySQL is working with remote MySql server ??
PS : if anyone from CPanel see this thread, can you go to see this bug for remote MySQL : http://bugzilla.cpanel.net/show_bug.cgi?id=4221
3 servers use a mysql server but the mysql server out of no where will not let one of the three servers connect.
This server was fine for about 6 months but tonight now will not connect.
Turned off the firewalls but the problem still occurred.
Not sure what could cause one of the...
hi every one
i have to servers i need to work with
one of them is the university server witch have PHP and Apache
and the other is my personal server witch have PHP, Apache and MySQL
now i want to use the university server as a web host and my personal server as a database host
We run a Free Web Hosting company. We are starting to get busy and would like to put all of the mysql on a separate server. We are a little confused as to how we would do this and get our control panel (iPanel) which uses cpanel to create the databases on our mysql server. iPanel...