Do not use sequential primary keys (auto-increment) on MySQL
Sequential primary keys introduce locks.
Use client-generated keys, such as GUIDs.
When you have master-master replication, auto-increment causes conflicts.
MySQL Sandbox with the Sakila sample database
You can go to https://www.katacoda.com/mysql-db-sandbox/scenarios/mysql-sandbox to access the MySQL Sandbox, which has the Sakila sample database loaded in a MySQL instance. You’ll have to set up a (free) Katacoda account. Then, click the Start Scenario button. See also: https://dev.mysql.com/doc/index-other.html
Comments
Post a Comment