Does Failover/SwitchOver mechanisam supported in MySQL?

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Does Failover/SwitchOver mechanisam supported in MySQL?
# 1  
Old 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
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Gentoo

How to failover the cluster ?

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

2. IP Networking

IP failover needed

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

3. Solaris

EMC Failover

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

4. AIX

failover on 4.5 hacmp

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. UNIX for Advanced & Expert Users

directories failover

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

6. Solaris

Cluster 2.2 Switchover Oftenly

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

7. Solaris

Interfaces do not failover

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
Login or Register to Ask a Question
erl_boot_server(3erl)					     Erlang Module Definition					     erl_boot_server(3erl)

NAME
erl_boot_server - Boot Server for Other Erlang Machines DESCRIPTION
This server is used to assist diskless Erlang nodes which fetch all Erlang code from another machine. This server is used to fetch all code, including the start script, if an Erlang runtime system is started with the -loader inet command line flag. All hosts specified with the -hosts Host command line flag must have one instance of this server running. This server can be started with the kernel configuration parameter start_boot_server . The erl_boot_server can both read regular files as well as files in archives. See code(3erl) and erl_prim_loader(3erl) . Warning: The support for loading of code from archive files is experimental. The sole purpose of releasing it before it is ready is to obtain early feedback. The file format, semantics, interfaces etc. may be changed in a future release. EXPORTS
start(Slaves) -> {ok, Pid} | {error, What} Types Slaves = [Host] Host = atom() Pid = pid() What = term() Starts the boot server. Slaves is a list of IP addresses for hosts which are allowed to use this server as a boot server. start_link(Slaves) -> {ok, Pid} | {error, What} Types Slaves = [Host] Host = atom() Pid = pid() What = term()() Starts the boot server and links to the caller. This function is used to start the server if it is included in a supervision tree. add_slave(Slave) -> ok | {error, What} Types Slave = Host Host = atom() What = term() Adds a Slave node to the list of allowed slave hosts. delete_slave(Slave) -> ok | {error, What} Types Slave = Host Host = atom() What = void() Deletes a Slave node from the list of allowed slave hosts. which_slaves() -> Slaves Types Slaves = [Host] Host = atom() Returns the current list of allowed slave hosts. SEE ALSO
init(3erl) , erl_prim_loader(3erl) Ericsson AB kernel 2.14.3 erl_boot_server(3erl)