InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Does Mysql 5.6 Have Sequences? |
|
Answer» No. HOWEVER, MySQL has an AUTO_INCREMENT system, which in MySQL 5.6 can also handle inserts in a multi-master replication SETUP. With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values that don't CONFLICT with other servers. The auto_increment_increment VALUE should be greater than the number of servers, and each server should have a unique OFFSET. No. However, MySQL has an AUTO_INCREMENT system, which in MySQL 5.6 can also handle inserts in a multi-master replication setup. With the auto_increment_increment and auto_increment_offset system variables, you can set each server to generate auto-increment values that don't conflict with other servers. The auto_increment_increment value should be greater than the number of servers, and each server should have a unique offset. |
|