11-27-2009
Does Failover/SwitchOver mechanisam supported in MySQL?
Hi,
I need setup like:
Consider, Master - A and Slave - B machine.
We do operations on master will replicate to Slave. But in case if
Case 1:
If master(A) goes down then changes / operations will be done on slave (B).
Case 2.
Later on , If slave down and Master is already up. Then changes on slave need to replicate on Master for consistency of data. and operations / changes will e done on Master.
Is MySQL database support this kind of mechanism? If Yes, How?
Any help on this highly appreciated.
Regards,
Amit
7 More Discussions You Might Find Interesting
1. Solaris
Would anyone know why a V440 Solaris 9 machine's interfaces (ce0 and ce1)
will not failover?
Both interfaces are on the same subnet, but different IPs. I can pull the plug on once interface (ce0) and ce1 will be accessible. I can reverse it and pull ce1, and ce0 will NOT be accessible. ... (5 Replies)
Discussion started by: StorageGuy
5 Replies
2. Solaris
Hai,
I am having ultra machine where SUN o.s 5.6 is installed with Clusters 2.2. Here, i am facing a problem of Cluster switchover oftenly. Can you suggest a solution.
Madan (1 Reply)
Discussion started by: madanrajan
1 Replies
3. UNIX for Advanced & Expert Users
Hi,
I have 3 directories (/1 /2 and /3) with same contents and want to achieve fail over among them.
The Solution i thought of:
1. link /data to /1 (and provide users with /data to access)
2. CRON a script (to run every minute) to verify if /1 exist or not, if it does not exist (or its... (3 Replies)
Discussion started by: prvnrk
3 Replies
4. AIX
Hi All,
How do I trigger the failover on the second hacmp server?
Please give me idea and I will do the rest.
Thanks,
itik (2 Replies)
Discussion started by: itik
2 Replies
5. Solaris
Hi guys,
I'm running vxdmp and powerpath at the same time. Vxdmp for internal disks and powerpath for external.
The problem is that, on the failover tests which a fiber cable should be removed, the system cannot recognize the disks.
Any hints on how to configure powerpath in order to... (4 Replies)
Discussion started by: glenioborges
4 Replies
6. IP Networking
All,
I am looking to setup a simple IP failover setup, but it seems every place i look has some difficult setup like pacemaker or LVS.
I only want to handle the IP piece to failover a VIP.
Any suggestions? I checked out keepalived and that my work for me. (4 Replies)
Discussion started by: markdjones82
4 Replies
7. Gentoo
How to failover the cluster ? GNU/Linux
By which command,
My Linux version
2008 x86_64 x86_64 x86_64 GNU/Linux
What are the prerequisites we need to take while failover ?
if any
Regards (3 Replies)
Discussion started by: sidharthmellam
3 Replies
LEARN ABOUT CENTOS
ocf_heartbeat_conntrackd
OCF_HEARTBEAT_CONNTR(7) OCF resource agents OCF_HEARTBEAT_CONNTR(7)
NAME
ocf_heartbeat_conntrackd - This resource agent manages conntrackd
SYNOPSIS
conntrackd [start | stop | monitor | promote | demote | meta-data | validate-all]
DESCRIPTION
Master/Slave OCF Resource Agent for conntrackd
SUPPORTED PARAMETERS
binary
Name of the conntrackd executable. If conntrackd is installed and available in the default PATH, it is sufficient to configure the name
of the binary For example "my-conntrackd-binary-version-0.9.14" If conntrackd is installed somewhere else, you may also give a full
path For example "/packages/conntrackd-0.9.14/sbin/conntrackd"
(optional, string, default "conntrackd")
config
Full path to the conntrackd.conf file. For example "/packages/conntrackd-0.9.14/etc/conntrackd/conntrackd.conf"
(optional, string, default "/etc/conntrackd/conntrackd.conf")
SUPPORTED ACTIONS
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 30.
promote
Promotes the resource to the Master role. Suggested minimum timeout: 30.
demote
Demotes the resource to the Slave role. Suggested minimum timeout: 30.
notify
Suggested minimum timeout: 30.
stop
Stops the resource. Suggested minimum timeout: 30.
monitor (Slave role)
Performs a detailed status check. Suggested minimum timeout: 20. Suggested interval: 20.
monitor (Master role)
Performs a detailed status check. Suggested minimum timeout: 20. Suggested interval: 10.
meta-data
Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.
validate-all
Performs a validation of the resource configuration. Suggested minimum timeout: 30.
EXAMPLE
The following is an example configuration for a conntrackd resource using the crm(8) shell:
primitive p_conntrackd ocf:heartbeat:conntrackd
op monitor timeout="20" interval="20" role="Slave"
op monitor timeout="20" interval="10" role="Master"
ms ms_conntrackd p_conntrackd
meta notify="true" interleave="true"
SEE ALSO
http://www.linux-ha.org/wiki/conntrackd_(resource_agent)
AUTHOR
Linux-HA contributors (see the resource agent source for information about individual authors)
resource-agents UNKNOWN 06/09/2014 OCF_HEARTBEAT_CONNTR(7)