MySQL Failover / Failback

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am curious if anyone knows the best practices for this? Several use cases include
 
Note: We are choosing to use a vip for the two nodes to make the failover change transparent to the application side.
 
1) Node 1 (master) dies
        -How do we enable "sticky" failover so that it does not then fail back to Node 1
        -Is Node 2 active all the time or is the service completely shut off? And if its off, how would replication happen?
        -How do failover domains work in this case?
2) Node 2 (Master) Node 1 recovered
        -How does replication continue again?
        -How does the master slave relationship change? Is this automated, or does it require manual intervention? Should we be using DRDB?
3) Node 1 (master) Node 2 (slave) - network connectivity dies on node 1
        -There is an IP resource available, but how does this monitor and handle failover?
        -How can I move the vip in the event of a failure? Do I need to manually script this?
 
With the vip failover, do I attach the vip resource to the mysql resource in the failover domain for those two nodes? What happens if I do this?
 
Thanks,
 
Robert Gil
Linux Systems Administrator
American Home Mortgage
Phone: 631-622-8410
Cell: 631-827-5775
Fax: 516-495-5861
 
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster

[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux