Sunday, February 5, 2023

MYSQL::To set readonly false for secondary server to forcefully to take this as primary as standalone node#read only false

 --To set readonly false for secondary server to forcefully to take this as primary 

as standalone node.

Scenario: Issue in innodb cluster and if resolution take more time to fix means,

 We can take one of the node forcefully as read write from the latest gtids node.

mysql> DROP DATABASE mysql_innodb_cluster_metadata;

Query OK, 15 rows affected (0.13 sec)

mysql>  SET GLOBAL READ_ONLY=0;

ERROR 2006 (HY000): MySQL server has gone away

No connection. Trying to reconnect...

Connection id:    78805

Current database: *** NONE ***

Query OK, 0 rows affected (0.00 sec)

mysql> go

Then inform application team to connect this database server ip directly in 

their connection string instead of mysql router way.

No comments:

Post a Comment

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...