CHMlib Logo Leading Translation Management System for Translation Agencies, Top Translation Management Software for Freelance Translators, Time Tracking Software, Word Count, Character Count and Line Count Software, Computer Assisted Translation Tool for Easy Word Count, Clipboard Character Count Software, User-Friendly Translation Memory Software, Terminology Management Software, Terminology Management Server, Microsoft Glossary Software, Dictionary of Acronyms, Social Network for Translators and Translation Agencies, Acronyms and Abbreviations Search Engine, Russian Translation Lab, Ukrainian Translation Lab.
You are reading help file online using chmlib.com
6.12. Auto-Increment in Multi-Master Replication

6.12. Auto-Increment in Multi-Master Replication

When multiple servers are configured as replication masters, special steps must be taken to prevent key collisions when using auto_increment, otherwise multiple masters may attempt to use the same auto_increment value when inserting rows.

To accommodate multi-master replication with auto_increment, two new server variables were introduced with MySQL 5.0.2: auto_increment_increment and auto_increment_offset. Each of these variables has a default (and mimimum) value of 1, and a maximum value of 65,535.

By setting non-conflicting values for these variables, servers in a multi-master configuration will not use conflicting AUTO_INCREMENT values when inserting new rows into the same table.

These two variables effect AUTO_INCREMENT column behavior as follows:

For additional information see Section 5.3.3, “Server System Variables”.

You are reading help file online using chmlib.com


If you want your help file to be removed or added please send e-mail to chmlibcom@gmail.com