Difference between revisions of "Configuring MySQL to Run on a Separate Server"
From AgileApps Support Wiki
imported>Aeric |
imported>Aeric |
||
Line 15: | Line 15: | ||
</ol> | </ol> | ||
''Learn More:'' http://dev.mysql.com/doc/refman/ | ''Learn More:'' http://dev.mysql.com/doc/refman/{{MySqlVersion}}/en/replication-solutions-backups.html | ||
<noinclude> | <noinclude> | ||
[[Category:Installation]] | [[Category:Installation]] | ||
</noinclude> | </noinclude> |
Revision as of 02:27, 19 March 2014
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.5/en/replication-solutions-backups.html