replication question (have set up but need advice)

Discussion in 'Installation/Configuration' started by yougotserved, Jan 6, 2014.

  1. yougotserved

    yougotserved New Member

    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 :)
     
  2. yougotserved

    yougotserved New Member

  3. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    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.
     

Share This Page