(Giuseppe Maxia) After part I: the basics, and part II: parallel apply, we deal now with some more mundane topic, or how to deploy replication services in a way that they fit our business, covering from the basic master/slave to the most advanced multi-source scheme.

(Darren Cassar) Many out there will have different ideas about this, some using procs, some using a function, others using a shell script. Well I didn’t want to spend much time on it so decided a group_concat(concat would be enough.

(Baron Schwartz) A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then committed on multiple systems, with an external transaction coordinator.

(Giuseppe Maxia) The MySQL general log is one of my favorite features for a quick debug. I especially like the ability of starting and stopping it on demand, which was introduced in MySQL 5.1.

This tutorial will introduce you to seven MySQL command-line tool tips that help increase your productivity and skills using the command-line method. These are written with beginners in mind, but can still be applied by any MySQL user.

(Chris Schneider) Versions of MySQL now come equipped with the powerful and stable InnoDB plugin. The InnoDB plugin comes with a lot of new features, bug fixes and performance gains. We will be covering file formats today, which is a very important part of the InnoDB plugin feature set.

This is a tutorial on how to develop your own Mono CMS using MySQL database in ASP.NET 3.5. To make this tutorial series easy to understand, it is recommended that you have some background in the use of MySQL database in Mono.

(Shlomi Noach) You have old_passwords=1 in your my.cnf. I’m guessing this is because you used one of the my-small.cnf, my-large.cnf etc. templates provided with your MySQL distribution.

(Anders Karlsson) Which one do you prefer? SHOW TABLES or SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE()

(Ronald Bradford) Given the popular response from my first lesson in improving scalability where I detailed simple ways to eliminate unnecessary SQL, let me share another common bottleneck with MySQL scalability that can be instantly overcome.