Home › Forums › implementation › Implementation discussion ›

MySQL master config for replication

Submitted by Guest on Sun, 11/10/2015 - 13:44
in

I want to turn on master/slave replication. I figure that if I set up the master, then I can play with the slave (on our test system) to see what happens. [I only get a limited 4am maintenance window on the production system so I want to make sure I have it set correctly.]

Does the following additions to the ini file look correct ?

Regards, Tim G

‹ SMS Reminders in 1.8 Seiko SLP 440 Label Problem - Windows 7 ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: MySQL master config for replication

Submitted by tanderson on Mon, 12/10/2015 - 14:28.

Looks OK from what I've read, but I haven't actually tried it.

Note that in 1.9 you can configure your slave database to be used for SQL reports by changing the relevant hibernate.reportingconnection properties in hibernate.properties e.g. 

hibernate.reportingconnection.url=jdbc:mysql://localhost:3306/openvpmsbackup
hibernate.reportingconnection.username=auser
hibernate.reportingconnection.password=apassword

This can reduce the load on your master database.

Re: MySQL master config for replication

Submitted by tgething (not verified) on Mon, 12/10/2015 - 15:00.

Thanks Tim:  a) yes I planned to play with reporting running off the slave; and b) after more research I added "expire_logs_days = 7".

The production is now running with this recipe. I will connect the slave as soon as I can.

Regards, Tim G

Re: MySQL master config for replication

Submitted by Ben_Charlton on Tue, 13/10/2015 - 11:36.

By play I assume you mean run reports...we have been running a slave since inception as a primary backup solution with secondary dumps to the cloud.

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au

Re: MySQL master config for replication

Submitted by tanderson on Tue, 13/10/2015 - 11:50.

Do you do any sort of automated monitoring to ensure the slave is up to date?

Re: MySQL master config for replication

Submitted by Ben_Charlton on Wed, 14/10/2015 - 08:55.

Not automated no  - I check them both - I run 2 slaves.

I must admit I should look into a script - I have done  a practice fail over though and then a switch back to master as well.

In my experience learning that procedure is the most important part of running slave.

 

 

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au
Syndicate content