"Since version 5, MySQL comes with built-in support for
master-master replication, solving the problem that can happen with
self-generated keys. In former MySQL versions, the problem with
master-master replication was that conflicts arose immediately if
node A and node B both inserted an auto-incrementing key on the
same table. The advantages of master-master replication over the
traditional master-slave replication are that you don't have to
modify your applications to make write accesses only to the master,
and that it is easier to provide high-availability because if the
master fails, you still have the other master."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.