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 “
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 “
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 moreA 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 moreThe 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 moreMySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners. Proudly running Percona Server for MySQL
Copyright © 2006-2021 Percona LLC.