Configuring MySQL to Run on a Separate Server

Configuring MySQL to Run on a Separate Server

This procedure sets up database connection pooling between the two servers.

1. Enable permissions on MySQL, so web servers can access the database server:
   

   GRANT ALL ON *.* to 'root'@'web_server_IP_Address' IDENTIFIED BY 'password'

2. Direct the database server to the application server:
   1. Edit {install_dir}/tomcat/conf/server.xml
   2. Replace url="jdbc:mysql://{domain}/relationals" with
      url="jdbc:mysql://IP_address_of_database_server/relationals"
   3. Save the file
   4. If the Application server is currently running, then Restart the Application Server.

Learn More: http://dev.mysql.com/doc/refman/5.5/en/replication-solutions-backups.html