Hallo Michael,
> You did added the modulus 100 to make sure that mysql replication didn't > end > up with an email address on server 1 with a id of 101 and the same email > address on server 2 with a id of 201? (or whatever) > Yes but I removed the modulus 100 because I got duplicate entry errors. But I still have issues with Amavisd-New and MySQL. I get those kind of errors: ---- Error 'Duplicate entry '[email protected]' for key 'email'' on query. Default database: 'sysdb_amavis'. Query: 'INSERT INTO maddr (partition_tag, email, domain) VALUES ('28','[email protected]','ch.werbewoche')' ---- > If you created these with REAL partitions, then you could alter table drop > partition (which is even faster) > What do you mean with REAL partitions? Partitions in MySQL? > -- > Michael Scheidell, CTO > Steve -- Neu: GMX Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://portal.gmx.net/de/go/dsl02 ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
