What if the repetition of Last_IO_Errno: 1593 server-uuid in MySQL causes slave to report an error
This article mainly introduces the MySQL Last_IO_Errno: 1593 server-uuid repeated slave error report how to do, the article is very detailed, has a certain reference value, interested friends must read it!
[problem description]:
An error was found on the slave library:
Mysql > SHOW SLAVE STATUS\ G
...
Last_IO_Errno: 1593
Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.
...
The error message is clear that the uuid of master is equal to the uuid of slave, and the uuid must be different for replication to take effect.
View each of the two libraries:
Mysql > SHOW VARIABLES LIKE'% server_%'
+-+
| | Variable_name | Value |
+-+
| | innodb_ft_server_stopword_table |
| | server_id | 11 | |
| | server_id_bits | 32 | |
| | server_uuid | feac17c0-d55e-11e5-b426-525400079dc4 |
+-+
4 rows in set (0.00 sec)
Mysql > SHOW VARIABLES LIKE'% server_%'
+-+
| | Variable_name | Value |
+-+
| | innodb_ft_server_stopword_table |
| | server_id | 22 | |
| | server_id_bits | 32 | |
| | server_uuid | feac17c0-d55e-11e5-b426-525400079dc4 |
+-+
4 rows in set (0.00 sec)
The reason for this:
Take the virtual machine to do the experiment, the first installed mysql-server, and then directly take the first copy into the second.
Causes the content in $datadir/auto.cnf to be consistent:
[auto]
Server_uuid= xxxxxxxx
[solution]:
What I do is randomly copy and modify the value generated by a uuid () function:
Mysql > SELECT uuid ()
However, this parameter is static, so you need to restart mysql.
The above is all the content of the article "Last_IO_Errno: 1593 server-uuid repetition causes slave error in MySQL". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!
