Hi All, I would like to have squirrelmail run on a different server than my main database server. The web server SM will be on is not located geographically near the dbmail DB server, therefore it's extremely inefficient to point the web server to this remote IMAP server (which is also the DB server). I would like to setup MySql replication in a two master server configuration. Here is my theory:
Server 1 hosts the dbmail database in MySql 4.1.7, and is running Exim as the MTA. There is no POP or IMAP daemon on this server. Server 2 hosts Apache, and has a replicated copy of the dbmail database from Server 1. It is NOT running any MTA at all. It does run the POP3 and IMAP daemons, pointing to localhost as the database. Server 1 replicates all DB changes to Server 2 Server 2 replicates all DB changes to Server 1 In short, *all* mail will be inserted on Server 1, and *all* mail will be retrieved from Server 2. I remember a long time ago on the -dev list some talk about changing the message id's in order to allow multi master databases work. But, at least in my limited knowledge - I think the above setup would work for my purposes. I simply do not want to run POP3 or IMAP on my main database server, and at the same time I do not want to point these daemons from Server 2 through a VPN or other type connection with limited speed to the database on Server 1. Can someone tell me if there is any reason that this could cause corruption, or whether this idea sounds feasible? This would be a temporary workaround until I can get another server to the same location as Server 1. Perhaps there is another solution. I'm open to ideas. Thank you, Angus
