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 ответов

17 просмотров

A

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

On master to slave it's fine

0

1 месяц назад

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

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

1 месяц назад

A

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

It's show connecting only on DR

0

1 месяц назад

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

A
It's show connecting only on DR

did you check network connectivity via telnet between servers?

0

1 месяц назад

A

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

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

0

1 месяц назад

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

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

1 месяц назад

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

1 месяц назад

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

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

1 месяц назад