MySQL Forums
Forum List  »  Router & Proxy

High Availability MySQL - Proxy as dual Master tool
Posted by: Mark Conlin
Date: March 16, 2011 06:15PM

The High Availability MySQL book states MySQL Proxy could be used to read from two masters and write to a single slave.

Has anyone actually done this?

This would certainly solve my problems and I am hoping to implement just such a strategy.

I am assuming you would be essentially reading from two binary logs and combining them into one. The target DB could have two different schemas to prevent table name and update collisions.

Any thoughts would be much appreciated. I have read the use case list for MySQL proxy and I dont see this listed.

Options: ReplyQuote

Written By
High Availability MySQL - Proxy as dual Master tool
March 16, 2011 06:15PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.