Backup Database

David Paras

• November 13, 2013 19:31

During the installation of the Adeptia software, we installed and pointed the logs and other data to MySql database. This database resides on our Prod1 server.

Without bringing another server into the mix, how can we make sure that MySql is available from Prod2 with all the logs from Prod2? Could they be written to both locations if we install MySql on Prod2?

0

• 

  David Paras

  • November 13, 2013 19:31

  One approach would be to setup a Mysql Database on Prod2 that is a slave to Mysql Database on EDI1. In the case of a mysql failure on the Prod1 server, you can point the log database to the Mysql database on Prod2.

  For more information on the master-slave setup in Mysql, you can refer to their documentation - http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html

  0

Post is closed for comments.