What are you trying to achieve? start slave all; show all slave

Question

What are you trying to achieve? start slave all; show all slave

status;

replication errors will be there.
but basically, if slaves don't start - restore from backup. skipping transactions is bad, like George Floyd himself

#english #programming #sql

0

04.04.2024

11 ответов

48 просмотров

A

A
I will check n go through the docs. But yes still ...

On master to slave it's fine

0

8 месяцев назад

Какой-то Хмырь Автор вопроса

A
I will check n go through the docs. But yes still ...

what is the error in slave status?) it should shed the light

0

8 месяцев назад

A

Какой-то Хмырь
what is the error in slave status?) it should shed...

It's show connecting only on DR

0

8 месяцев назад

Какой-то Хмырь Автор вопроса

A
It's show connecting only on DR

did you check network connectivity via telnet between servers?

0

8 месяцев назад

A

Какой-то Хмырь
did you check network connectivity via telnet betw...

Yes checked through telnet n ping.. It's fine

0

8 месяцев назад

Какой-то Хмырь Автор вопроса

A
Yes checked through telnet n ping.. It's fine

if it doesn't write error and says connecting, i'd say it is a network related problem. when doing telnet, you specified the right mysql port? both sides? check settings on slave, so that master address and port are specified. also look for errors in logs on both sides

0

8 месяцев назад

A

Какой-то Хмырь
if it doesn't write error and says connecting, i'd...

It would be great help if we cn connect on zoom or teams as Oracle support is useless

0

8 месяцев назад

Какой-то Хмырь Автор вопроса

A
It would be great help if we cn connect on zoom or...

sorry, mate. i have two jobs, a kid and a pregnant wife. Ain't nobody got time for that (c)

0

8 месяцев назад