MySQL Database Replication Tips
1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master
2. Password problem are solved by carefully checking your grant statements
3. When you have more than two master servers, you must use log-slave-updates option to ensure that changes are propagated in a chain. Beware of infinite looping of updates. Infinite loop is prevented with:
replicate-same-server-id = [...]
Categories: MySQL Tags: check, configuration, configure, database replication, logs, master servers, mysql, passwords, prevent, replication, replication problems, scripts, servers
How to choose between MySQL or PostgreSQL – A Comparison
MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software. MySQL has long been assumed to be the faster but featureless of the two database systems, while PostgreSQL was assumed to be a more [...]
