I have a 3 node Percona XtraDB Mysql Cluster (PXC) , and separately a 1 node Async slave. I recently upgraded the Percona cluter to Mysql 8.0.29 from 5.7.
I used Percona's xtrabackup to transfer the data to the slave (I have done this dozens of times before). The data all copied.
I then start the slave, and it says: Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
Slave_IO_Running: Yes Slave_SQL_Running: Yes Slave_IO_State: Waiting for source to send event
Yet the data does not update when querying.
If I look at the file system, it looks like it is writing data to the disk - the timestamp of the files updates. Yet when I query it only shows the data at the time of the import.
I see no errors on either the master or the slave.
I tried using master_auto_position or specifying the specific binlog location. Same result. I tried this on several slave servers, with the same result.
I am not using binlog_do_db or replicate-do-db
