(Baron Schwartz) For a long time I’ve wanted to know how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core count. He looked for a balance between utilizing the hardware as much as possible, limiting the system complexity, and

(Shlomi Noach) I recently encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production.

(Henrik Ingo) A week ago Baron wrote a blog post which can only be described as the final nail in the coffin for MMM. At MySQL AB we never used or recommended MMM as a High Availability solution. I never really asked about details about that, but surely one reason was that it is based on using the M

(Robert Hodges) The last article on this blog described our planned MySQL to MongoDB replication hackathon at the recent Open DB Camp in Sardinia. Well, it worked, and the code is now checked into the Tungsten Replicator project.

(Justin Swanhart) Peter asked this question in comments to to my previous Shard-Query benchmark. Actually he asked if it could scale to 50, but testing 20 was all I could due to to EC2 and time limits. I think the results at 20 nodes are very useful to understand the performance:

(Rob Gravelle) Just when you thought that you understood the term Web 2.0, along comes this Cloud thing. Do you know what that’s all about? Do you care? What does that have to do with your MySQL database?

(Keith Larson) Over the last few years I have worked for few different companies that utilized versions of relayed replication with the MySQL databases. Their data handler connections where done with Java connection pooling or custom built PHP/PERL code.

(Aleksandr Kuzminsky) There are two ways InnoDB can organize tablespaces. First is when all data, indexes and system buffers are stored in a single tablespace. This is typicaly one or several ibdata files. A well known innodb_file_per_table option brings the second one.

(Ulf Wendel) The Mysqlnd replication and load balancing plugin alpha release has focused on laying foundations for read-write splitting and load balancing.

(Robert Gravelle) Don’t get me wrong; the LIKE operator is great for finding words or phrases within strings. I’ve used it for those times that you need to match complex string patterns in MySQL. But you’ll be happy to learn that it provides a form of advanced pattern matching that is based on exten