Hi Matthew,
we are using exim4 mysql and dbmail (additional exilist spamassassin spfd
srsd) pretty successfully.
My recommendation is this: use mysql in a common circle replication. Log
client updates and use binary logs. Ignore primary key errors of the
database (yes, this is no problem!!!).
e.g. 3 servers: a > b > c > a
load balancing is done via dns round robin. If you want safe on fail, you
may code a little wrapper/proxy. Not hard to do.
Best regards
Simon
-----Ursprüngliche Nachricht-----
Von: dbmail-bounces@xxxxxxxxxx [mailto:dbmail-bounces@xxxxxxxxxx] Im Auftrag
von Matthew Story
Gesendet: Dienstag, 6. Juni 2006 23:38
An: dbmail@xxxxxxxxxx
Betreff: [Dbmail] problem with LVS and MySQL cluster
I'm trying to hook up exim4 with DBMail to a couple of MySQL servers
running MySQL Cluster 5.0.x that are being load balanced by a couple
of UltraMonkey Directors. The problem is this, i've set up the
database using the ndbcluster engine without any problems (aside from
the fact that the create_tables example file has two errors in it,
both define the default of a datetime variable as '0' not 0 as it
should be), but then I reconfigure DBMail using dpkg and I can't
connect to the database. (the connection times out). I can however
connect to each of the MySQL servers individually through DBMAil, but
not thruogh the VIP set up by the load-balencers. I know that the
load-balencing is being done properly because I have a webserver that
is able to access databases on the cluster through the VIP of the
load-balencers. Any thoughts?
--
regards,
matt
_______________________________________________
Dbmail mailing list
Dbmail@xxxxxxxxxx
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
