MySQL Database Replication Tips

MySQL No Comments »

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 [...]

 Read More

How to choose between MySQL or PostgreSQL – A Comparison

Articles, Database, MySQL 4 Comments »

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 densely featured database system [...]

 Read More
Techgurulive is a free Howtos and tutorials website on apache, Linux, windows, php, Networking, MySQL, Cisco, open source, IT-Tips, Nas, Virtualization, voip, vpn, email,send mail, lamp, security, SEO, squid, Anti virus, Backup, Database,and much more.