Slave becomes unresponsive
Hi,
We are using master slave replication we have 1 master instance and 2 slave instances.
The application is currently configured to use master only for writing operations and configured slaves for reading operation.
the problem is both the slaves are unresponsive due to migration on master server. It appeared that the statistical data was not correct in the slave
after running ALTER query on master to change a couple of columns from VARCHAR(255) to TEXT.
To recover the application we have changed the configuration to use the master server for both read and write operation.
I am wondering how this problem occurred and how to avoid such problem in future.
What was the root cause of this problem
Subject
Views
Written By
Posted
Slave becomes unresponsive
992
November 27, 2017 10:43PM
535
November 28, 2017 08:24AM
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.