Kerry Colligan writes:
> Hey all.
>
> How do I set up data replication such that immediate failover is attained?
> Or, if the primary MySQL server fails, how do I ensure that data on the
> secondary is current?
>
> Any comments greatly appreciated.
>
> Kerry Colligan
>
Hi!
Solution to the first question is to have service availability
checking. There are several ways to do it, simplest being the usage of
ping().
Switching from server to server can be done by some router, including
round - robin router, or by clustering management server.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
