Fixing these two misfeatures is exactly the purpose of this article. Using features introduced in MySQL 5.0 and 5.1, it is possible to build a replication system where all nodes act as master and slave at the same time, with a built-in fail-over mechanism.
Contents contributed and discussions participated by Ken Wei
MySQL Performance Blog » Covering index and prefix indexes - 0 views
Using the Ruby MySQL Module - 0 views
Advanced MySQL Replication Techniques - 0 views
"Streaming" MySQL slave deployment - 0 views
MySQL AB :: Articles about MySQL - 0 views
MySQL AB :: Using the New MySQL Query Profiler - 1 views
-
When it comes to overall performance, it's important to remember that the #1 contributor is always a good database design. The second highest contributor to performance is well-tuned SQL code.
-
But a better day has come along in MySQL 5.0.37 with the inclusion of the SQL Profiling utility. This interactive diagnostic aid allows a developer or DBA to gain insight into where a set of SQL code spends its time and the resources it is using.
A couple of useful mysqldump options - 0 views
MySQL AB :: MySQL Workbench - 0 views
MySQL AB :: MySQL Tools - 0 views
MySQL AB :: Using MySQL With Ruby - 0 views
‹ Previous
21 - 40 of 69
Next ›
Last »
Showing 20▼ items per page
Ken Wei