Hi I have insttalled a mirrored system using a mix of: http://www.howtoforge.com/perfect-server-debian-wheezy-apache2-bind-dovecot-ispconfig-3 http://www.howtoforge.com/installin...tabase-cluster-on-debian-6.0-with-ispconfig-3 and for setting up the master master replication: https://www.digitalocean.com/community/articles/how-to-set-up-mysql-master-master-replication All seemed good then i started recieving : Replication failed. Error: (web_database) Access denied for user 'ispconfig2'@'localhost' (using password: YES) # SQL: DELETE FROM web_database WHERE database_id = 1 This broke the slave relation ship and was evident in the show slavestatus/g; I have now noticed the isp config will create the databases without the config i put in place for replication??? is this what it should be doing and if it is will it replicate all database changes or is it just database creation? If it is only the database creation do you know how to work around this issue to prevent the mysql replication breaking? I need both databases in sync for failover Hope this makes sense
Found this blog post seems to have resolved the issue hope it help some other people http://blog.schaal-24.de/?p=1921&lang=en
What I described in my post should not be used to "fix" mysql-permissions. As you can see, you got Access denied for user 'ispconfig2'. This indicates another problem in your setup. This has NOTHING todo with creating/dropping databases in a mirror-setup.
