Here goes... Please tell me it does not make sense so I can stop banging my head over what was wrong.
On a reboot the private connection between the two servers would not re- establish. They would have to be shutdown and then restarted simultaneously... That was not a problem. I only had issues if one server was shut down, the backup took over. When the first server comes back up, if the private connection did not get re-established before the second server is restarted then the head aches would start... The two servers would become out of sync and replication would stop because of duplicate entry. After I upgraded to a 10/100MB switch I could not get MySQL to use that ethernet card... In case you want to know, the private connection was a tulic (24x4x) fiber connection running a 192.168.10.x/255.255.255.252 ip scheme. On Tue, 2005-05-17 at 15:57 +1200, Tristram J. Cheer wrote: > Could you expand on the hardware issues your talking about? They way I > plan to have it is that a SMTP connection comes in a Linux Virtual > Server “Director” directs it to the lesser used server and the server > running DBMAIL and PostgreSql then takes the connection. From there > Postgresql then is clustered with the other server and all data is > sync’ed up > > > > > ______________________________________________________________________ > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Steven Lynn > Sent: Tuesday, 17 May 2005 2:31 p.m. > To: DBMail mailinglist > Subject: Re: [Dbmail] DbMail in a ISP Cluster > > > > > O, and hardware was not the limiting factor. Hardware problems are > what made me switch to just a master mysql server running dbmail, > postfix, etc and a slave only has a data backup. Sorry if I was not > clear on that part. > > On Mon, 2005-05-16 at 17:49 -0400, Curtis Maurand wrote: > > > > > I would hope that you can get better performance than that. I ran an > ISP that handled over 6,000 messages per day which is nothing for a > moderate ISP. figure at least 10 messages per day (including spam) > per user. If you've got 3500 users that's 35,000 messages. (35,000 / > 24 = 1458.33 per hour.) > > 500 messages per day limit due to hardware is pretty pathetic. I ran > the 6,000 messages per day on Linux on a K6-II 400 w/512MB of RAM and > sendmail. I've just put two systems together using Postfix and > dbmail. One of them is on very modest hardware about to be upgraded > (Celeron 1GHz/ 1GB RAM - don't go there.) the database is on the same > machine MySQL). The other is running on Athlon 1GHz 1GB RAM and the > database is on a separate machine (Pentium IV 2.8 GHz 1GB RAM running > Gentoo Linux and MySQL). My assumption is that I can run multiple > mailservers against the database server. The dbserver also performs > DNS using powerdns (also a MySQL backend.) > > Curtis > > > > Steven Lynn wrote: > > > > I ran it in a similar setup but I had two machines with a private > replication network connection. It ran very strong for about 6-8 > months before hardware issues got in the way. It was handling a > 500message per day average with the bulk in the morning (SPAM). I am > now down to 1 primary and 1 slave and no fail-over. I had no special > setup for DBMail, only special setup with the util (ucarp) to do > failover... > > Hope this helps. > > On Mon, 2005-05-16 at 20:53 +1200, Tristram J. Cheer wrote: > > > > Hey All, > > > > We are looking for a pop3/smtp solution for our ISP, we are wanting to > use DBMAIL in our 5 server LVM cluster – we try and do everything via > SQL so that out we can keep a single SQL db on each machine and have > it clustered. > > > > Does anyone have anything like this running and if so can they provide > some info about how they did it? > > > > Cheers > > > > Tristram > > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > ______________________________________________________________________ > > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail
