AgileApps Support Wiki

Difference between revisions of "Configuring MySQL to Run on a Separate Server"

From AgileApps Support Wiki
imported>Aeric
m (Text replace - 'Category:System Administration' to 'Category:Installation')
 
imported>Aeric
Line 1: Line 1:
=== Configuring MySQL and LongJump to Run on Separate Servers ===
=== Configuring MySQL to Run on a Separate Server ===


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

Revision as of 17:04, 7 June 2011

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 longjump_installation/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.1/en/replication-solutions-backups.html

Retrieved from "https://agileappscloud.info/aawiki-src/index.php?title=Configuring_MySQL_to_Run_on_a_Separate_Server&oldid=11886"