(Justin Swanhart) In my previous post I introduced materialized view concepts.

(Frazer Clement) MySQL Cluster distributes rows amongst the data nodes in a cluster, and also provides data replication. How does this work? What are the trade offs?

(Justin Swanhart) If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables you to create and maintain incrementally

(Shlomi Noach) An InnoDB table must have a primary key (one is created if you don’t do it yourself). You may have a natural key at hand. Stop! Allow me to suggest an AUTO_INCREMENT may be better.

(Henrik Ingo) There has been an increase in the discussion about MySQL replication and how to make it happen faster. I don’t think Marco Tusa’s blog is on Planet MySQL, so let’s highlight it first: A dream on MySQL parallel replication. This is a good account of what it looks like out in the field o

(Baron Schwartz) The duration of a benchmark is an important factor that helps determine how meaningful it is. Most systems have some “burstable capacity,” and this can influence the results a lot.

(Sheeri Cabral) So, you are going to Collaborate (or thinking of going) and you saw my blog post about what to go to if you are a beginner with MySQL. But what if you are more experienced with MySQL? There is plenty of content for you too! I have put together this list of what I would recommend to a

(Baron Schwartz) The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination of the C binary and the Perl script) has support for printing out stats on InnoDB tables and indexes.

MySQL is a heavy-duty database server. Used with various software languages, most notably PHP, and component of the LAMP family (which is comprised of Linux, Apache, MySQL, and PHP),

(Rob Gravelle) All of the larger systems that I’ve helped develop necessitated storing some combination of date and time fields. Almost universally, these fields presented difficulties of some kind or another.