Storing UUID Values in MySQL
Please note, a more up-to-date follow-up post is here: Storing UUID and Generated Columns
A few years ago Peter Zaitsev, in a post titled “
19 Dec 2014
09 Sep 2014
Multi-Valued INSERTs, AUTO_INCREMENT & Percona XtraDB Cluster
A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In this way, the new cluster acts as a slave […]
Read more 26 Oct 2010
Sharing an auto_increment value across multiple MySQL tables (revisited)
A couple of weeks ago I blogged about Sharing an auto_increment value across multiple MySQL tables. In the comments, a few people wrote in to suggest alternative ways of implementing this. I just got around to benchmarking those alternatives today across two large EC2 machines: (more…)
Read more 04 Oct 2010
Sharing an auto_increment value across multiple MySQL tables
The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two:
Option #1: Use a table to insert into, and grab the insert_id:
Shell
CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb;
# […]
Read more