MySQL autoincrement column jumps by 10- why?

by

Please do not change the auto_increment_increment. ClearDB is doing this on purpose. It’s explained in the documentation:

ClearDB uses circular replication to provide master-master MySQL
support. As such, certain things such as auto_increment keys (or
sequences) must be configured in order for one master not to use the
same key as the other, in all cases. We do this by configuring MySQL
to skip certain keys, and by enforcing MySQL to use a specific offset
for each key used. The reason why we use a value of 10 instead of 2 is
for future development.

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. What is the error “Every derived table must have its own alias” in MySQL?
  3. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  4. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  5. How to pivot a MySQL entity-attribute-value schema
  6. Generating a series of dates [duplicate]
  7. MySQL find_in_set with multiple search string
  8. Oracle Database Link – MySQL Equivalent?
  9. Select mysql query between date?
  10. MySQL COUNT DISTINCT
  11. How to take backup of a single table in a MySQL database?
  12. mysql -> insert into tbl (select from another table) and some default values [duplicate]
  13. Convert MySQL schema to Github Wiki?
  14. Capitalize first letter of each word, in existing table
  15. MySQL trigger to update a field to the value of id
  16. What does SQL clause “GROUP BY 1” mean?
  17. Bogus foreign key constraint fail
  18. How to get a list of MySQL views?
  19. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  20. Syntax error when using except in a query
  21. Convert Unix timestamp into human readable date using MySQL
  22. Why the order of evaluation for expressions involving user variables is undefined?
  23. Easiest way to copy a table from one database to another?
  24. sql like operator on integer
  25. The best way to remove value from SET field?
  26. How do you force mysql LIKE to be case sensitive? [duplicate]
  27. MySQL Alter table causes Error: Invalid use of NULL value
  28. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  29. Migrating data into Firebase from MySQL
  30. Inventory management with stock options

Leave a Comment