Solved

MySQL Master to Master To slave Replication

Posted on 2011-03-11
5
673 Views
Last Modified: 2013-11-10
Ok, I've been looking and can't seem to come up with a answer on this.

Right now I have a Master To Master Replication in place for part of my failover system in place. Though lately the servers have been starting to slow down a lot because we have a lot of reporting that is going on and it's affect the software that powered by the MySQL Database.

So what i want to do with throw in a third computer as a slave just for these reports. Something like this

[S1]
^
[M1] <-> [M2]


So if M2 is currently the active computer in my fail over system, what I'm wondering is if the new data sent to M1 is also replicated down to S1.
0
Comment
Question by:Pyromanci
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:mwiercin
Comment Utility
Hi,

The data won't go into S1 unless M1 gets back alive and passes binlog to it. Check Multi-Master-Mysql (documentation is pretty rubbish, but software is just great), which is bunch of scripts that will take care of this situation (and couple others in Multi-Master scenario).

http://mysql-mmm.org/
0
 
LVL 5

Author Comment

by:Pyromanci
Comment Utility
I looked at MMM earlier before i posted and the problem is, that MMM requires a virtual IP (if i understood the documentation correctly when i read. I do agree it's documentation is pretty shitty). We do not have that.

Our server sit in data centers M1 is in NY and M2 in Denver and S1 here in our office. So i don't have a virtual IP i can float between M1 and M2.

0
 
LVL 5

Accepted Solution

by:
Pyromanci earned 0 total points
Comment Utility
Never mind, I found it. Add this to my config file.
log_slave_updates = 1
0
 
LVL 3

Expert Comment

by:mwiercin
Comment Utility
Hi

Keep in mind to have separate server-ids. One more thing there, if you use both as write nodes, you won't be able to safely switch the slave to replicate of other master.

Cheers,
0
 
LVL 5

Author Closing Comment

by:Pyromanci
Comment Utility
Found answer to problem else where.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now