I have next setup: two servers each serving completely independent web
projects. Each webserver has its own mysqld and programs on web server
use only local mysqld.
To minimize possible downtimes in case of any problems with one of
servers (hardware failure, serious misconfiguration and so on) I need
ability to temporary host web projects from "broken" server on "good"
one. I can have a copy of all web projects files on both servers so
the only problem is availability of databases.
After some thinking I've came up with next solution. When both servers
are up theirs mysqld are setup to have two-way replication. Since both
servers serve completely independent projects and these projects use
different sets of databases and tables there is should be no conflicts
between two mysqld. In should be look like first mysqld pushes changes
in one set of tables on second mysqld and second mysqld pushes changes
in another set of tables on first mysqld.
So my question: Will it work?
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/) |
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.com/) |
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
