DISQUS

For MySQL 5.0.2 or above

In the my.cnf file on server1 add:
auto_increment_increment=2
auto_increment_offset=1

In the my.cnf file on server2 add:
auto_increment_increment=2
auto_increment_offset=2

This will make the auto-increment on server1 go, 1,3,5,7,9,etc... and on server2 go, 2,4,6,8,etc... thereby preventing collisions.