Q

Incorporating multi-master support in MySQL

A MySQL expert describes two ways that the multi-master support can be used.

Is there a way to incorporate multi-master support into MySQL?

MySQL interprets multi-master to mean two servers which replicate to each other -- that is, each server is both master to and slave of the other. Implementation is largely the same as any other replication setup, with the exception that the servers should not be permitted to generate the same auto_increment values. This is solved by setting one server to use even numbers, and the other to use odd numbers. The same principle applies...

to creating a ring of servers; obviously, the auto_increment_increment will need to match or exceed the number of servers in the ring.

See http://dev.mysql.com/doc/refman/5.0/en/replication-auto-increment.html

Multi-master can also mean one slave accepts updates from two different masters. At this time, MySQL does not readily support such a setup with replication. The desired end results might be achieved using MySQL Cluster.

This was first published in July 2007

Dig deeper on Open source databases

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataCenter

SearchServerVirtualization

SearchCloudComputing

SearchEnterpriseDesktop

Close