# Mysql replica is up and running but I can't see updates on my slave

**URL:** <https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [June 9, 2025, 8:02am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245 "2025-06-09T08:02:49Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 9, 2025, 8:02am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/1 "2025-06-09T08:02:49Z")

</div>

I have a problem with MySQL replica. MySQL version is 8.0.23.

MySQL replica is up and running but I can’t see updates on my slave.

```auto
mysql> show replica status\G
***************************1. row***************************
             Replica_IO_State: Waiting for master to send event
                  Source_Host: dccaz012avm.gruppogavio.corp
                  Source_User: replica_user
                  Source_Port: 3306
                Connect_Retry: 60
              Source_Log_File: MySQL_log.000022
          Read_Source_Log_Pos: 520071650
               Relay_Log_File: MySQL_relaylog.000023
                Relay_Log_Pos: 520071865
        Relay_Source_Log_File: MySQL_log.000022
           Replica_IO_Running: Yes
          Replica_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Source_Log_Pos: 520071650
              Relay_Log_Space: 520072160
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Source_SSL_Allowed: Yes
           Source_SSL_CA_File:
           Source_SSL_CA_Path:
              Source_SSL_Cert:
            Source_SSL_Cipher:
               Source_SSL_Key:
        Seconds_Behind_Source: 0
Source_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error:
               Last_SQL_Errno: 0
               Last_SQL_Error:
  Replicate_Ignore_Server_Ids:
             Source_Server_Id: 1
                  Source_UUID: 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9
             Source_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
    Replica_SQL_Running_State: Slave has read all relay log; waiting for more updates
           Source_Retry_Count: 86400
                  Source_Bind:
      Last_IO_Error_Timestamp:
     Last_SQL_Error_Timestamp:
               Source_SSL_Crl:
           Source_SSL_Crlpath:
           Retrieved_Gtid_Set: 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1992417-2050018
            Executed_Gtid_Set: 2f3b2e03-76b2-11eb-b016-000d3a44150a:1-48,
8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-891211298
                Auto_Position: 0
         Replicate_Rewrite_DB:
                 Channel_Name:
           Source_TLS_Version:
       Source_public_key_path:
        Get_Source_public_key: 0
            Network_Namespace:

```

If I create a new database on master server or I create a table on an existing db on master server, I can’t see the db or the table on my slave that has read\_only and super\_read\_only set.

Any suggestions?

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 9, 2025, 8:24am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/2 "2025-06-09T08:24:07Z")

</div>

Hi @Fborgoglio71,

I see seconds behind source is 0 and binlogs are moving based on the coordinates. If you’re writing on the source but not getting the data on replica then I’d check the following.

- Source is not writing to binary log? Are you using sql\_log\_bin=0? Do we have filters like binlog\_do\_db?

- I don’t see any filters on replica relicate\_do/ignore… thus it is not a problem.

- Does the binary log on master contains the DDL/DML that you expect to replicate?  
`mysqlbinlog --base64-output=decode-rows -vv MySQL_log.000022 > MySQL_log.000022.dbg`

- Is there anything in your replica error log?

About read\_ony / super\_read\_only … that will not impact replication threads and that may not be the reason for you not s eeing your data on the replica.

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 9, 2025, 2:17pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/3 "2025-06-09T14:17:24Z")

</div>

> [@kedarpercona](#):
>
> sql\_log\_bin=0

-) sql\_log\_bin is set equal to ON on master and slave servers, but not as GLOBAL variables.

mysql\> show global variables like ‘%bin%’;  
±-----------------------------------------------±---------------------------------------------+  
| Variable\_name | Value |  
±-----------------------------------------------±---------------------------------------------+  
| bind\_address | \* |  
| binlog\_cache\_size | 32768 |  
| binlog\_checksum | CRC32 |  
| binlog\_direct\_non\_transactional\_updates | OFF |  
| binlog\_encryption | OFF |  
| binlog\_error\_action | ABORT\_SERVER |  
| binlog\_expire\_logs\_seconds | 259200 |  
| binlog\_format | ROW |  
| binlog\_group\_commit\_sync\_delay | 0 |  
| binlog\_group\_commit\_sync\_no\_delay\_count | 0 |  
| binlog\_gtid\_simple\_recovery | ON |  
| binlog\_max\_flush\_queue\_time | 0 |  
| binlog\_order\_commits | ON |  
| binlog\_rotate\_encryption\_master\_key\_at\_startup | OFF |  
| binlog\_row\_event\_max\_size | 8192 |  
| binlog\_row\_image | FULL |  
| binlog\_row\_metadata | MINIMAL |  
| binlog\_row\_value\_options | |  
| binlog\_rows\_query\_log\_events | OFF |  
| binlog\_stmt\_cache\_size | 32768 |  
| binlog\_transaction\_compression | OFF |  
| binlog\_transaction\_compression\_level\_zstd | 3 |  
| binlog\_transaction\_dependency\_history\_size | 25000 |  
| binlog\_transaction\_dependency\_tracking | COMMIT\_ORDER |  
| innodb\_api\_enable\_binlog | OFF |  
| log\_bin | ON |  
| log\_bin\_basename | /opt/mysqldata00/bin\_log\_dir/MySQL\_log |  
| log\_bin\_index | /opt/mysqldata00/bin\_log\_dir/MySQL\_log.index |  
| log\_bin\_trust\_function\_creators | OFF |  
| log\_bin\_use\_v1\_row\_events | OFF |  
| log\_statements\_unsafe\_for\_binlog | ON |  
| max\_binlog\_cache\_size | 18446744073709547520 |  
| max\_binlog\_size | 1073741824 |  
| max\_binlog\_stmt\_cache\_size | 18446744073709547520 |  
| mysqlx\_bind\_address | \* |  
| sync\_binlog | 1 |  
±-----------------------------------------------±---------------------------------------------+  
36 rows in set (0.03 sec)

mysql\> show variables like ‘%bin%’;  
±-----------------------------------------------±---------------------------------------------+  
| Variable\_name | Value |  
±-----------------------------------------------±---------------------------------------------+  
| bind\_address | \* |  
| binlog\_cache\_size | 32768 |  
| binlog\_checksum | CRC32 |  
| binlog\_direct\_non\_transactional\_updates | OFF |  
| binlog\_encryption | OFF |  
| binlog\_error\_action | ABORT\_SERVER |  
| binlog\_expire\_logs\_seconds | 259200 |  
| binlog\_format | ROW |  
| binlog\_group\_commit\_sync\_delay | 0 |  
| binlog\_group\_commit\_sync\_no\_delay\_count | 0 |  
| binlog\_gtid\_simple\_recovery | ON |  
| binlog\_max\_flush\_queue\_time | 0 |  
| binlog\_order\_commits | ON |  
| binlog\_rotate\_encryption\_master\_key\_at\_startup | OFF |  
| binlog\_row\_event\_max\_size | 8192 |  
| binlog\_row\_image | FULL |  
| binlog\_row\_metadata | MINIMAL |  
| binlog\_row\_value\_options | |  
| binlog\_rows\_query\_log\_events | OFF |  
| binlog\_stmt\_cache\_size | 32768 |  
| binlog\_transaction\_compression | OFF |  
| binlog\_transaction\_compression\_level\_zstd | 3 |  
| binlog\_transaction\_dependency\_history\_size | 25000 |  
| binlog\_transaction\_dependency\_tracking | COMMIT\_ORDER |  
| innodb\_api\_enable\_binlog | OFF |  
| log\_bin | ON |  
| log\_bin\_basename | /opt/mysqldata00/bin\_log\_dir/MySQL\_log |  
| log\_bin\_index | /opt/mysqldata00/bin\_log\_dir/MySQL\_log.index |  
| log\_bin\_trust\_function\_creators | OFF |  
| log\_bin\_use\_v1\_row\_events | OFF |  
| log\_statements\_unsafe\_for\_binlog | ON |  
| max\_binlog\_cache\_size | 18446744073709547520 |  
| max\_binlog\_size | 1073741824 |  
| max\_binlog\_stmt\_cache\_size | 18446744073709547520 |  
| mysqlx\_bind\_address | \* |  
| sql\_log\_bin | ON |  
| sync\_binlog | 1 |  
±-----------------------------------------------±---------------------------------------------+  
37 rows in set (0.01 sec)

-) binlog\_do\_db is not set

-) Yes. Binary log on master contains the DDL/DML that I expect to replicate.

-) I have no errors on my replica error log

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [June 9, 2025, 2:31pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/4 "2025-06-09T14:31:57Z")

</div>

Could you please run this command on the replica:

SHOW VARIABLES LIKE ‘%replicate%’;

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 9, 2025, 2:37pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/5 "2025-06-09T14:37:31Z")

</div>

> [@Wayne\_Leutwyler](#):
>
> SHOW VARIABLES LIKE ‘%replicate%’;

Here it is the output:

mysql\> show variables like ‘%replicate%’;  
Empty set (0.00 sec)

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 9, 2025, 3:27pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/6 "2025-06-09T15:27:28Z")

</div>

Hi @Fborgoglio71,  
Can you try this one exercise and provide me with the output. Sorry but I doubt we’re missing something very basic:

Connect to replica ( ??.gruppogavio.corp)

```auto
mysql -uUSER -p
show replica status\G
SHOW BINARY LOG STATUS;

```

Connect to source ( dccaz012avm.gruppogavio.corp)

```auto
SHOW BINARY LOG STATUS; 
create database debug;
use debug;
create table debug.test (id int not null auto_increment primary key);
SHOW BINARY LOG STATUS;

```

Connect to replica ( ??.gruppogavio.corp)

```auto
show replica status\G
SHOW BINARY LOG STATUS;

```

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 9, 2025, 3:44pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/7 "2025-06-09T15:44:15Z")

</div>

> [@kedarpercona](#):
>
> Can you try this one exercise and provide me with the output. Sorry but I doubt we’re missing

OK.  
But when I run “SHOW BINARY LOG STATUS;” I get this error:

mysql\> SHOW BINARY LOG STATUS;  
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LOG STATUS’ at line 1

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [June 9, 2025, 4:23pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/8 "2025-06-09T16:23:32Z")

</div>

> [@Fborgoglio71](#):
>
> SHOW BINARY LOG STATUS;

Your on 8.0.23. Run this command:

show master status;

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 10, 2025, 6:54am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/9 "2025-06-10T06:54:55Z")

</div>

Thank you very much.

Here is it the result.

–) Connected to replica

mysql\> show replica status\G  
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
Replica\_IO\_State: Waiting for master to send event  
Source\_Host: dccaz012avm.gruppogavio.corp  
Source\_User: replica\_user  
Source\_Port: 3306  
Connect\_Retry: 60  
Source\_Log\_File: MySQL\_log.000195  
Read\_Source\_Log\_Pos: 1060428051  
Relay\_Log\_File: MySQL\_relaylog.000542  
Relay\_Log\_Pos: 1060428266  
Relay\_Source\_Log\_File: MySQL\_log.000195  
Replica\_IO\_Running: Yes  
Replica\_SQL\_Running: Yes  
Replicate\_Do\_DB:  
Replicate\_Ignore\_DB:  
Replicate\_Do\_Table:  
Replicate\_Ignore\_Table:  
Replicate\_Wild\_Do\_Table:  
Replicate\_Wild\_Ignore\_Table:  
Last\_Errno: 0  
Last\_Error:  
Skip\_Counter: 0  
Exec\_Source\_Log\_Pos: 1060428051  
Relay\_Log\_Space: 1060428561  
Until\_Condition: None  
Until\_Log\_File:  
Until\_Log\_Pos: 0  
Source\_SSL\_Allowed: Yes  
Source\_SSL\_CA\_File:  
Source\_SSL\_CA\_Path:  
Source\_SSL\_Cert:  
Source\_SSL\_Cipher:  
Source\_SSL\_Key:  
Seconds\_Behind\_Source: 0  
Source\_SSL\_Verify\_Server\_Cert: No  
Last\_IO\_Errno: 0  
Last\_IO\_Error:  
Last\_SQL\_Errno: 0  
Last\_SQL\_Error:  
Replicate\_Ignore\_Server\_Ids:  
Source\_Server\_Id: 1  
Source\_UUID: 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9  
Source\_Info\_File: mysql.slave\_master\_info  
SQL\_Delay: 0  
SQL\_Remaining\_Delay: NULL  
Replica\_SQL\_Running\_State: Slave has read all relay log; waiting for more updates  
Source\_Retry\_Count: 86400  
Source\_Bind:  
Last\_IO\_Error\_Timestamp:  
Last\_SQL\_Error\_Timestamp:  
Source\_SSL\_Crl:  
Source\_SSL\_Crlpath:  
Retrieved\_Gtid\_Set: 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1992417-4078062  
Executed\_Gtid\_Set: 2f3b2e03-76b2-11eb-b016-000d3a44150a:1-48,  
8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-891211298  
Auto\_Position: 0  
Replicate\_Rewrite\_DB:  
Channel\_Name:  
Source\_TLS\_Version:  
Source\_public\_key\_path:  
Get\_Source\_public\_key: 0  
Network\_Namespace:  
1 row in set (0.00 sec)

mysql\> show master status;  
ERROR 2006 (HY000): MySQL server has gone away  
No connection. Trying to reconnect…  
Connection id: 29  
Current database: \*\*\* NONE \*\*\*

±-----------------±---------±-------------±-----------------±--------------------------------------------------------------------------------------------+  
| File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set |  
±-----------------±---------±-------------±-----------------±--------------------------------------------------------------------------------------------+  
| MySQL\_log.000008 | 196 | | | 2f3b2e03-76b2-11eb-b016-000d3a44150a:1-48,  
8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-891211298 |  
±-----------------±---------±-------------±-----------------±--------------------------------------------------------------------------------------------+  
1 row in set (0.00 sec)

–) Connecte to source

mysql\> show master status;  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
| File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set |  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
| MySQL\_log.000196 | 34393362 | | | 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-4079233 |  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
1 row in set (0.00 sec)

mysql\> create database debug;  
Query OK, 1 row affected (0.03 sec)

mysql\> use debug;  
Database changed

mysql\> create table debug.test (id int not null auto\_increment primary key);  
Query OK, 0 rows affected (0.08 sec)

mysql\> show master status;  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
| File | Position | Binlog\_Do\_DB | Binlog\_Ignore\_DB | Executed\_Gtid\_Set |  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
| MySQL\_log.000196 | 70953379 | | | 8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-4079563 |  
±-----------------±---------±-------------±-----------------±-----------------------------------------------+  
1 row in set (0.00 sec)

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 10, 2025, 7:52am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/10 "2025-06-10T07:52:43Z")

</div>

Hi @Fborgoglio71,

Could you see the problem? Hint Hint Look at GTID.

```auto
mysql> show master status;
±-----------------±---------±-------------±-----------------±-----------------------------------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
±-----------------±---------±-------------±-----------------±-----------------------------------------------+
| MySQL_log.000196 | 70953379 | | | **8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-4079563** |
±-----------------±---------±-------------±-----------------±-----------------------------------------------+

```

but on replica

```auto
 Executed_Gtid_Set: 2f3b2e03-76b2-11eb-b016-000d3a44150a:1-48,
**8cce0b8e-75ed-11eb-9cb3-000d3a3a9cb9:1-891211298**

```

Let me say it… The replica is ahead of primary, it has more gtids than the primary! Thus all the writes on master are getting ignored! I think the replica was not correctly moved / cofigured under the writer…  
Best is for you to reseed the replica.

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [June 10, 2025, 10:53am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/11 "2025-06-10T10:53:29Z")

</div>

I published this document some time back. I will help you rebuild your replica using the clone plugin. Its an option to help you to re-seed your replica.

> **[Take a Clone it will last longer](https://percona.community/blog/2024/06/02/take-a-clone-it-will-last-longer/)**
>
> Want to learn more about MySQL and Cloning?

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 12, 2025, 7:05am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/12 "2025-06-12T07:05:14Z")

</div>

Thank You very much Wayne.  
I really don’t know Clone Plugin.  
I’m considering it but have you also a doc for reseeding my replica?  
I followed all the step and I can’t understand as it has more gtids than the primary.

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 12, 2025, 10:02am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/13 "2025-06-12T10:02:15Z")

</div>

I have run by mistake, the command

CHANGE MASTER TO  
MASTER\_HOST = ‘dccaz012avm.gruppogavio.corp’,  
MASTER\_PORT = 3306,  
MASTER\_USER = ‘replica\_user’,  
MASTER\_PASSWORD = ‘mysql\_replica8.0.23’,  
MASTER\_SSL = 1,

on my master server.

Could be this mistake that have caused the replica ahead of primary?

How can I fix the master server?

How can I reseed the replica server?

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [June 12, 2025, 12:24pm UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/14 "2025-06-12T12:24:50Z")

</div>

Hi @Fborgoglio71,  
Only executing CHANGE MASTER TO will do no harm unless you have “start replica” after that OR you had a stopped replica on that master itself. I doubt either of that was the case.  
Any issue on primary cannot raise txns on replica and make it go ahead of primary! I think investigating that will need more information but if it is not important I’d recommend you to prioritize reseeding the replica.

I don’t think you have done any harm on Master and hence you can just say “reset replica all” and that should take care of it. Besides, dccaz012avm is master itself, thus it won’t do self-replication 🙂

How can I reseed the replica server?  
In a high level

- Take fresh backup from primary
- Perform restore
- Setup replication

* * *

- You may follow [How to set up a replica for replication in 6 simple steps with Percona XtraBackup - Percona XtraBackup](https://docs.percona.com/percona-xtrabackup/8.0/set-up-replication.html#4-configure-the-replicas-mysql-server)
- If you want to follow @Wayne_Leutwyler 's guide [Restoring using clone plugin](https://percona.community/blog/2024/06/02/take-a-clone-it-will-last-longer/) which clearly showcases the steps.

Thanks,  
K

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 13, 2025, 8:40am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/15 "2025-06-13T08:40:58Z")

</div>

Thank you very much.

---

<div class="post-metadata">

**Author:** ![Fborgoglio71](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@Fborgoglio71](https://forums.percona.com/u/Fborgoglio71)\
**Post date:** [June 18, 2025, 7:49am UTC](https://forums.percona.com/t/mysql-replica-is-up-and-running-but-i-cant-see-updates-on-my-slave/38245/16 "2025-06-18T07:49:33Z")

</div>

Following your precious advice my replica is bask, up and ranning.  
Thank you very much.
