Re: Databases are not showing up on Replicated Server
Posted by:
Lib Tech
Date: July 26, 2024 07:15PM
Barry, I loaded the dump file to the slave, and it worked fine, and the error went away. The second step was to change the slave to a master and have two masters. I almost followed the same steps, except I didn't create a dump file. However, now the issue is the previous master (master 1) is working as a slave, and Master 2 (previously a slave) is working as a master. When I run the command "SHOW REPLICA STATUS\G," it shows the same error that I mentioned earlier. If I create a table from master 2, it shows up on master 1, but if I create a table or db in master 1, it won't show up on master 2. Any idea how can fix the issue? Thanks
Log
2024-07-27T00:34:29.596287Z 25 [Warning] [MY-010897] [Repl] Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
2024-07-27T00:34:29.648550Z 25 [System] [MY-014001] [Repl] Replica receiver thread for channel '': connected to source 'replica@192.168.1.212:3306' with server_uuid=this-was-server-uuid, server_id=1. Starting replication from file 'FIRST', position '4'.
2024-07-27T00:34:29.722648Z 27 [ERROR] [MY-010584] [Repl] Replica SQL for channel '': Worker 1 failed executing transaction 'ANONYMOUS' at source log mysql-bin.000001, end_log_pos 485; Error 'Operation CREATE USER failed for 'replica'@'192.168.1.112'' on query. Default database: ''. Query: 'CREATE USER 'replica'@'192.168.1.112' IDENTIFIED WITH 'caching_sha2_password' AS '$somepassword.#\"/iupdatedthispart'', Error_code: MY-001396
2024-07-27T00:34:29.723689Z 26 [ERROR] [MY-010586] [Repl] Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with "START REPLICA". We stopped at log 'mysql-bin.000001' position 157