MySQL Forums
Forum List  »  Replication

Re: Replication sql errors
Posted by: sharath s
Date: May 06, 2021 06:59AM

Hello Peter,
I identified the below parameters to have different values. can this be the cause for the errors in slave c. should the values of this parameter to be same across all three servers

server a
mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 2 |
| auto_increment_offset | 1 |
+--------------------------+-------+
2 rows in set (0.00 sec)



server b
mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 2 |
| auto_increment_offset | 2 |
+--------------------------+-------+
2 rows in set (0.00 sec)


server c
mysql> SHOW VARIABLES LIKE 'auto_inc%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
+--------------------------+-------+
2 rows in set (0.01 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
864
May 01, 2021 06:47AM
379
May 01, 2021 09:28AM
461
May 03, 2021 01:51AM
401
May 03, 2021 11:07AM
1077
May 06, 2021 12:08AM
546
May 06, 2021 11:17AM
485
May 07, 2021 04:25AM
521
May 06, 2021 11:20AM
Re: Replication sql errors
472
May 06, 2021 06:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.