MySQL Forums
Forum List  »  Replication

Mysql-HA- Auto failover
Posted by: chaitanya D
Date: June 16, 2017 08:48AM

Hi
I am new bee to MySQL world . Kindly help me with options and Solution

Requirement is to Setup a HA with out fail-over using 2 servers .

What are all the options available with out extra cost included, kindly let me know.

Current solution what i implemented .

Master -Master replication with mysql router on top of database to route application connections to destination node .

Is there a way to bring back failed node to sync with out restoring from other master database.

Say two servers M1 and M2 - Master - Master replication with GTID.


M1 was down for 10 min ( Manually stopped MySQL) after 10 min i started it again but M1 is not able to sync with M2 , replication is not working.

I have to restore M2 database to M1 and set up replication again to make replication work again .

Is there any better way to make replication work again .

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql-HA- Auto failover
803
June 16, 2017 08:48AM
405
June 16, 2017 08:52AM


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.