> (I know this is not officially supported for this product) This is supported in V2!
Setup the second MySQL to slave mode (mysqlSlaveMode), so only the first is doing the maintenance. As I can understand you are replicating the DB's of both MySQL?! In both my.ini you have to setup slave-skip-errors=1582 1062 because replication will stop, if a record already exists! Thomas Marco Rauchenstein <[email protected]> 11.03.2009 14:48 Bitte antworten an ASSP development mailing list <[email protected]> An "'[email protected]'" <[email protected]> Kopie Thema [Assp-test] ASSP 2.x with Master-Master SQL Dear ASSP community First of all thank you for your great product. I is really amazing what ASSP can do fighting against spam. Because I'm not a skilled database administrator I just want to ask if my current setup has a chance to work stable. My Environment: I have to two windows 2008 x64 servers in my DMZ running ASSP 2.0 with MySQL 5.1. On this two server (ns1 and ns2) there is also the MS SMTP service running. In my LAN there is a MS Exchange 2007 which is using the two servers NS1 and NS2 as smart hosts. The MX record of the two ASSP Servers is equal weighted so both servers get mails from the internet in parallel. The Exchange server itself also uses both ASSP Servers to send mails to the internet (alternating order). Internet -> ASSP -> SMTP -> Exchange or the other way Exchange -> ASSP -> SMT Exchange Up to here the base setup works so far but seems not be stable. After running some time (about a day) the ASSP service on Windows hangs. I assume this is because of my setup described below. It is my wish to setup ASSP for redundancy and load balancing. So I'm trying to setup ASSP with a Master-Master SQL backend (I know this is not officially supported for this product) so that both servers always know about blocked IP's, white list, spam db and so on from each other and can also actively add their records. If you are interested in this scenario please have a look at this great manual found here: http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html The used MySQL servers on my scenario are exactly configured as described in the manual above. The ASSP on NS1 is using the MySQL on NS1 and the ASSP on NS2 is using the MySQL on NS2 as its database server. This works great for the whitelist for example because there should be never the situation that both ASSP Servers try to add the same whitelist record. So every ASSP server knows also about the added whitelist records from the other server because of MySQL replication and both servers are able to add their records as needed. However with the spam db for example I can see that after some time the MySQL records are not identical any more. I assume that conflicting records must me the reason for this. The same is true for blocked IP's and so on. Would it be possible to address this scenario in ASSP? Some more information or some help would be appreciated. best regards Marco ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test DISCLAIMER: ******************************************************* This email and any files transmitted with it may be confidential, legally privileged and protected in law and are intended solely for the use of the individual to whom it is addressed. This email was multiple times scanned for viruses. There should be no known virus in this email! ******************************************************* ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
