(Henrik Ingo) A while ago Baron blogged about his utter dislike for MMM, a framework supposedly used as a MySQL high-availability solution. While I have no personal experience with this framework, reading the comments to that blog I’m indeed convinced that Baron is right. For one thing, it includes

(Shinguz) It is common practice in MySQL table design that fields are declared as NOT NULL but some non-sense DEFAULT values are specified for unknown field contents. In this article we show why this behavior is non optimal an why you should better declare a field to allow NULL values and use NULL v

(Anders Karlsson) In my recent post on OR-conditions I made a mistake, and I appologize for that. I made the statement that MySQL will only use 1 index per statement, whatever you do.

(Mat Keep) In my previous post, I discussed scaling web database performance in MySQL Cluster using auto-sharding and active/active geographic replication – enabling users to scale both within and across data centers.

(Anders Karlsson) Some things are known to be just bad. GOTOs used to be one such thing (something I still use them, but only where appropriate, which isn’t that many places). Maybe it is just so, that some things are useful, but not for everything, so maybe the issue is that they are used inappropr

(Mat Keep) Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc. But it also brings with it more complexity.

(Simon J Mudd) While looking at partitioning I recently made a mistake which I guess can happen to others. Often this is due to not fully reading the documentation or scanning it too quickly and misunderstanding what’s being said.

(Alejandro Gervasio) In this database programming tutorial, you will be using the REPLACE statement and the UNIQUE clause to avoid duplicate records.

(Chuck) If you have two or more database servers containing the same data, how do you know if the objects are identical. Furthermore, how can you be sure the data is the same on all of the servers?

(Ovais Tariq) Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items. So before working with indexes, it is important to understand how indexes work behind the scene and what is the data structure that is used to store these indexes