Sample Header Ad - 728x90

Change server_uuid in MySQL

2 votes
1 answer
1148 views
I want to know if there is any way to update server_uuid; I am trying master-slave replication, and I need different server_uuid. FYI - I don't have server_uuid in my my.cnf file, and when I update it like this:
> SET GLOBAL server_uuid = '1';
I get the following error:
ERROR 1238 (HY000): Variable 'server_uuid' is a read only variable
Asked by datascinalyst (105 rep)
Dec 18, 2023, 11:04 AM
Last activity: Dec 20, 2023, 06:05 AM