AgileApps Support Wiki

Configuring MySQL to Run on a Separate Server

From AgileApps Support Wiki
Revision as of 18:46, 3 May 2011 by imported>Aeric (Text replace - 'Category:System Administration' to 'Category:Installation')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Configuring MySQL and LongJump to Run on Separate Servers

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=11885"