Note: "permalinks" may not be as permanent as we would like,
direct links of old sources may well be a few messages off.
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 alex at crackpot.org wrote: > Quoting Lars Ellenberg <lars.ellenberg at linbit.com>: > >> so replicating it using drbd and a cluster file system, >> and then simultaneously accessing it with a second mysql instance >> on a second box >> can not magically make it work. >> >> to have more than one application instance access the same data source, >> they have to coordinate access, >> whether they run on a single host, or on two different hosts. >> not only writes (that should be obvious), >> but also reads, to avoid cache coherency issues. > > You can do this if you configure MySQL to use external locking. Why not simply use MySQL clustering, if clustering is, what's needed? http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html Of course this only makes sense, if the rest of the application can be clustered, too. If not, replication is much easier and works great. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iD8DBQFGzS9c1QuEJQQMVrgRAsIFAJ9QIyDJyjBRkfHWQuv8p2p8qspDJgCdH2gQ up8igs5Dgo3FzAiyEanzdNg= =2xiv -----END PGP SIGNATURE-----