Difference between revisions of "Configuring MySQL to Run on a Separate Server"
From AgileApps Support Wiki
imported>Aeric m (Text replace - '{platform_installation}' to '<i>{platform_installation}</i>') |
imported>Aeric m (Text replace - '{platform_installation}' to '{install_dir}') |
||
Line 8: | Line 8: | ||
<li>Direct the database server to the application server: | <li>Direct the database server to the application server: | ||
<ol type="a"> | <ol type="a"> | ||
<li>Edit <tt><i>{ | <li>Edit <tt><i>{install_dir}</i>/tomcat/conf/server.xml</tt></li> | ||
<li>Replace <tt>url="jdbc:mysql://{domain}/relationals"</tt> with<br/> <tt>url="jdbc:mysql://IP_address_of_database_server/relationals"</tt></li> | <li>Replace <tt>url="jdbc:mysql://{domain}/relationals"</tt> with<br/> <tt>url="jdbc:mysql://IP_address_of_database_server/relationals"</tt></li> | ||
<li>Save the file</li> | <li>Save the file</li> |
Revision as of 00:08, 23 June 2011
Configuring MySQL to Run on a Separate Server
This procedure sets up database connection pooling between the two servers.
- Enable permissions on MySQL, so web servers can access the database server:
GRANT ALL ON *.* to 'root'@'web_server_IP_Address' IDENTIFIED BY 'password'
- Direct the database server to the application server:
- Edit {install_dir}/tomcat/conf/server.xml
- Replace url="jdbc:mysql://{domain}/relationals" with
url="jdbc:mysql://IP_address_of_database_server/relationals" - Save the file
- If the Application server is currently running, then Restart the Application Server.
Learn More: http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-backups.html