Hello Thomas I cleaned up the MySQL and ASSP and added the string "slave-skip-errors=1582 1062" to the my.ini files. Up to now and after some tests the replication works well and the MySQL table entries remain equal on both servers.
I understand that "slave-skip-errors" is needed that the replication should not break any more and duplicated entries can be handled but to be honest I don't know where the values "1582 1062" come from. I'm looking forward that ASSP after this changes will run more stable in my environment. regards Marco -----Original Message----- From: Marco Rauchenstein Sent: Mittwoch, 11. März 2009 15:52 To: ASSP development mailing list Subject: RE: [Assp-test] Antwort: Re: Antwort: Re: Antwort: ASSP 2.x with Master-Master SQL Hello Thomas Ok, I will do this in the evening and give you a feedback later. Would be absolutely great if this change in the MySQL config solves the problem. Thank you again for your help Marco -----Original Message----- From: Thomas Eckardt/eck [mailto:[email protected]] Sent: Mittwoch, 11. März 2009 15:40 To: ASSP development mailing list Subject: [Assp-test] Antwort: Re: Antwort: Re: Antwort: ASSP 2.x with Master-Master SQL >Do I have to delete and rebuild the assp database Just check if master and slaves are ok 'show slave status \G' backup and restore the database with MySQL-Admin on one host -> shutdown ASSP before! Thomas Marco Rauchenstein <[email protected]> 11.03.2009 15:35 Bitte antworten an ASSP development mailing list <[email protected]> An ASSP development mailing list <[email protected]> Kopie Thema Re: [Assp-test] Antwort: Re: Antwort: ASSP 2.x with Master-Master SQL Done! Do I have to delete and rebuild the assp database? Marco -----Original Message----- From: Thomas Eckardt/eck [mailto:[email protected]] Sent: Mittwoch, 11. März 2009 15:24 To: ASSP development mailing list Subject: [Assp-test] Antwort: Re: Antwort: ASSP 2.x with Master-Master SQL >On my MySQL servers the entry "slave-skip-errors=1582 1062" is currently not included in the my.ini files. You have to! Thomas Marco Rauchenstein <[email protected]> 11.03.2009 15:21 Bitte antworten an ASSP development mailing list <[email protected]> An ASSP development mailing list <[email protected]> Kopie Thema Re: [Assp-test] Antwort: ASSP 2.x with Master-Master SQL Hello Thomas Thank you for your feedback. What I meant was that Master-Master replication is not supported officially by the MySQL server. I'm glad to hear that it is supported by ASSP 2.0. On my MySQL servers the entry "slave-skip-errors=1582 1062" is currently not included in the my.ini files. Yes, I am trying to replicating the the DB's of both MySQL. Because I thought that the "mysqlSlaveMode" option in assp is for a Master-Slave MySQL replication, I have not activated this option. Currently I have this entries added in the my.ini files: ............................................................................................. # SERVER SECTION (part of the my.ini on NS1) # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 # My Replication Settings on NS1 server-id=10 log-bin=mysql-bin log-slave-updates replicate-same-server-id=0 replicate-do-db=assp auto_increment_increment=10 auto_increment_offset=1 master-host=172.16.5.151 master-user=root master-password=MyPassword report-host=NS1 relay-log=NS1-relay-bin ............................................................................................. # SERVER SECTION (part of the my.ini on NS2) # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 # My Replication Settings on NS2 server-id=20 log-bin=mysql-bin log-slave-updates replicate-same-server-id=0 replicate-do-db=assp auto_increment_increment=10 auto_increment_offset=2 master-host=172.16.5.150 master-user=root master-password=MyPassword report-host=NS2 relay-log=NS2-relay-bin -----Original Message----- From: Thomas Eckardt/eck [mailto:[email protected]] Sent: Mittwoch, 11. März 2009 14:58 To: ASSP development mailing list Subject: [Assp-test] Antwort: ASSP 2.x with Master-Master SQL > (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 ------------------------------------------------------------------------------ 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 ------------------------------------------------------------------------------ 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 ------------------------------------------------------------------------------ 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
