Hi,
I am going to install a remote mySQL server to lower the load on one of my DA boxes.
I will do it this way:
- Install the same version of mySQL on the remote server
- Stop mysqld on DA server
- Copy all the files on /var/lib/mysqld/ from DA to mySQL server
- Create da_admin user on mySQL server using this toturial:
http://help.directadmin.com/item.php?id=45
- Edit /usr/local/directadmin/conf/mysql.conf on the DA server to add:
host=1.2.3.4
Where 1.2.3.4 is the IP of the remote mySQL server
- Edit /var/www/html/phpMyAdmin/config.inc.php
to replace the line:
$cfg['Servers'][$i]['host'] = 'localhost';
by:
$cfg['Servers'][$i]['host'] = '1.2.3.4';
To let phpmyadmin know where the mySQL server is
Over.
But I still have one question:
- my customers are using "localhost" as mySQL server on their installation. Do they need to change and put mySQL server IP?
Is there anyway to instruct DA server to consider:
localhost=1.2.3.4 ?
Thank you for your help. I will keep you updated about this project.
I am going to install a remote mySQL server to lower the load on one of my DA boxes.
I will do it this way:
- Install the same version of mySQL on the remote server
- Stop mysqld on DA server
- Copy all the files on /var/lib/mysqld/ from DA to mySQL server
- Create da_admin user on mySQL server using this toturial:
http://help.directadmin.com/item.php?id=45
- Edit /usr/local/directadmin/conf/mysql.conf on the DA server to add:
host=1.2.3.4
Where 1.2.3.4 is the IP of the remote mySQL server
- Edit /var/www/html/phpMyAdmin/config.inc.php
to replace the line:
$cfg['Servers'][$i]['host'] = 'localhost';
by:
$cfg['Servers'][$i]['host'] = '1.2.3.4';
To let phpmyadmin know where the mySQL server is
Over.
But I still have one question:
- my customers are using "localhost" as mySQL server on their installation. Do they need to change and put mySQL server IP?
Is there anyway to instruct DA server to consider:
localhost=1.2.3.4 ?
Thank you for your help. I will keep you updated about this project.