[ILUG] MySQL cluster

[John McCormac]

Donncha O Caoimh wrote:
> 
> http://prometheus.zerodivide.net/mysql_cluster/
> 
> Found this on freshmeat yesterday. Looks like they propogate changes to
> a central db through the MySQL logfile.. I wonder what would they do if
> the logfile grows to over a GB in a day ;)

One single nightmarish word for MySQL users: transactions. :-) It seems
that only one db is writable and the others are read-only clones of that
db. This ensures that there is no independent updating of the satellite
databases. The log method it uses is not one that I'd be comfortable
with but most of the applications for MySQL would not be extremely high
traffic. (I'm currently messing about with a MySQL based search engine
model for irishwebpages.com purely for speed.)

Regards...jmcc
-- 
********************************************
John McCormac            * Hack Watch News
jmcc at hackwatch.com       * 22 Viewmount, 
Voice:   +353-51-873640  * Waterford,
BBS&Fax: +353-51-850143  * Ireland
http://www.hackwatch.com/~kooltek
********************************************

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6

mQCNAzAYPNsAAAEEAPGTHaNyitUTNAwF8BU6mF5PcbLQXdeuHf3xT6UOL+/Od+z+
ZOCAx8Ka9LJBjuQYw8hlqvTV5kceLlrP2HPqmk7YPOw1fQWlpTJof+ZMCxEVd1Qz
TRet2vS/kiRQRYvKOaxoJhqIzUr1g3ovBnIdpKeo4KKULz9XKuxCgZsuLKkVAAUX
tCJKb2huIE1jQ29ybWFjIDxqbWNjQGhhY2t3YXRjaC5jb20+tBJqbWNjQGhhY2t3
YXRjaC5jb20=
=sTfy
-----END PGP PUBLIC KEY BLOCK-----