MySQL Master to master replication - multiserver

Discussion in 'General' started by MaxxNevis, Dec 3, 2013.

  1. MaxxNevis

    MaxxNevis New Member

    Hi guys,

    I've followed the guide for a multiserver setup, I did everything twice, meaning, two of everything, DNS, Apache, Postfix, Dovecot so on and so forth.

    now I've got isp5 and isp6 they hande client DBs and isp6 is setup as mirror for isp5 through the ISPconfig interface.

    My question: to have a truly redundant solution, so that when I create a DB on one server it'll be replicated to the other. Should I setup master-master replication between two servers?. Which DBs should I exclude, dbispconfig & mysql?.

    I appreciate your advice.

    Thanks.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes. Otherwise the database configuartion gest mirrored (by ispconfig) but not the actual data inside the databases.

    Yes.
     
  3. MaxxNevis

    MaxxNevis New Member

    @till, thank you very much for pointing me in the right direction. This is a production ISPConfig cluster and I do not want to screw anything up.

    You guys are the best. Thanks :)
     

Share This Page