Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MySQL Master to Master To slave Replication

Posted on 2011-03-11
5
Medium Priority
?
682 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 3

Expert Comment

by:mwiercin
ID: 35111717
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
ID: 35112639
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
ID: 35130420
Never mind, I found it. Add this to my config file.
log_slave_updates = 1
0
 
LVL 3

Expert Comment

by:mwiercin
ID: 35131174
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
ID: 35170927
Found answer to problem else where.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Here in this article, you will get a step by step guidance on how to restore an Exchange database to a recovery database. Get a brief on Recovery Database and how it can be used to restore Exchange database in this section!
In this video we show how to create a Contact in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Contact ta…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

636 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