<div>
The official explanation is here: &nbsp;<a href="http://dev.mysql.com/doc/refman/5.7/en/replication-options-master.html" rel="ugc nofollow">http://dev.mysql.com/doc/refman/5.7/en/replication-options-master.html</a>
</div>


<div>
Thanks Dave. I already went through that link. <br />
<br />
My question is : in a group of 4 mysql db servers where 2 of them can be picked(randomly) as masters and the other two stays slaves. what values should I give for those two variables in each server.<br />
<br />
Thanks.
</div>


<div>
I don't know, someone else will have to answer that.
</div>


<div>
I found a link that helped me to understand how to set auto_increment parameters and put it here for others
</div>


<div>
<div class="content wysiwyg-content">
I have 4 Mysql database servers, at some point I will have two of them as masters. how can I configure the following variables :<br />
<br />

<blockquote>
auto_increment_increment<br />
auto_increment_offset
</blockquote>
<br />
Regards,
</div>
</div>


I have 4 Mysql database servers, at some point I will have two of them as masters. how can I configure the following variables :

auto_increment_increment
auto_increment_offset

Regards,

The official explanation is here:  http://dev.mysql.com/doc/refman/5.7/en/replication-options-master.html

Thanks Dave. I already went through that link. 

My question is : in a group of 4 mysql db servers where 2 of them can be picked(randomly) as masters and the other two stays slaves. what values should I give for those two variables in each server.

Thanks.

I don&#39;t know, someone else will have to answer that.

I found a link that helped me to understand how to set auto_increment parameters and put it here for others

Mysql auto increment

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.