Here's how to reproduce:
mysql> create table t (i int); Query OK, 0 rows affected (0.37 sec)
mysql> insert into t values (1),(2),(3),(4),(5); Query OK, 5 rows affected (0.00 sec)
mysql> ALTER TABLE `t` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;Query OK, 5 rows affected (0.58 sec)
mysql> select * from t; +----+------+ | id | i | +----+------+ | 1 | 1 | | 3 | 2 | | 5 | 3 | | 7 | 4 | | 9 | 5 | +----+------+ 5 rows in set (0.00 sec)
Node 2: =======
mysql> select * from t; +----+------+ | id | i | +----+------+ | 2 | 1 | | 4 | 2 | | 6 | 3 | | 8 | 4 | | 10 | 5 | +----+------+ 5 rows in set (0.00 sec)
Here's how to reproduce:
mysql> create table t (i int);
Query OK, 0 rows affected (0.37 sec)
mysql> insert into t values (1),(2) ,(3),(4) ,(5);
Query OK, 5 rows affected (0.00 sec)
mysql> ALTER TABLE `t` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY
KEY FIRST;Query OK, 5 rows affected (0.58 sec)
mysql> select * from t;
+----+------+
| id | i |
+----+------+
| 1 | 1 |
| 3 | 2 |
| 5 | 3 |
| 7 | 4 |
| 9 | 5 |
+----+------+
5 rows in set (0.00 sec)
Node 2:
=======
mysql> select * from t;
+----+------+
| id | i |
+----+------+
| 2 | 1 |
| 4 | 2 |
| 6 | 3 |
| 8 | 4 |
| 10 | 5 |
+----+------+
5 rows in set (0.00 sec)