MySQL Master to master replication - multiserver
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.