MySQL Forums
Forum List  »  Replication

Re: Replication sql errors
Posted by: sharath s
Date: May 07, 2021 04:25AM

Hello Peter,
Row based is for a reason that the data is critical and it is the safest form of replication.

2. Need suggestion on how do i set the increment and offset variables if i have one master and slave a and slave b. I have already given hte current values.

If i am increasing replication to another server how should i consider the value setting this parameter. Is there any calculation or formula to set this.

Or can i set the same values in all slaves and ensure it is consistent across.

THis info would be helpful as we are planning to do a server migration using replication. No changes to db version.

Regards,
Sharath

Options: ReplyQuote


Subject
Views
Written By
Posted
387
May 01, 2021 06:47AM
164
May 01, 2021 09:28AM
194
May 03, 2021 01:51AM
159
May 03, 2021 11:07AM
270
May 06, 2021 12:08AM
178
May 06, 2021 11:17AM
Re: Replication sql errors
157
May 07, 2021 04:25AM
189
May 06, 2021 11:20AM
170
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.