(Corra) In MySQL 5.1 Cluster Certification Study Guide at page 151 there’s the following sentence: “InnoDB operates with the REPEATABLE READ isolation level, which still allows phantom reads but suppresses non-repeatable reads”.

(Leo Hsu and Regina Obe) Representationl State Transfer (REST) is a term to describe an architectural style of sharing information with consumers using already existing protocols such as HTTP. In the strictest sense of the term, the transport protocol need not be HTTP.

(pabloj) Sometimes I see people having great difficulties in describing how to fetch data for a report.

(Peter Zaitsev) Doing performance analyzes today I wanted to count how many hits come to the pages which get more than couple of visits per day.

(Jignesh K. Shah) In my previous post I briefly mentioned Database Appliance with Project Indiana. Now that Sun has acquired MySQL (or as some people say MySQL has acquired Sun) and with our existing work in progress with PostgreSQL, there are quite a bit of options available of using some combinati

(Peter Zaitsev) I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write some simple steps you can take to get a good feeling about it, it is not perfect but usually can tell you quite a lot of what you should expect from the sys

(George J. Trujillo Jr.) A ”tipping point” is a concept, product or idea that becomes a hot commodity that attracts everyone’s attention, interest or inspiration. There are always specific reasons and factors that are not easily identifiable why one product becomes a tipping point and others do no

(Peter Zaitsev) Implementing MySQL database in 24/7 environments we typically hope for uniform component performance, or at least would like to be able to control it. Typically this is indeed the case, for example CPU will perform with same performance day and night (unless system management softwar

(pabloj) A question pops out quite often on Devshed forums, “How do I keep table x of my local database in sync with a remote copy?”

In preparation for disaster recovery and for training purposes I asked our Junior DBA to document the innodb_force_recovery options in our internal Wiki. I am modestly familiar with the command having used it a few times because of data corruption. However, somehow, I completely missed something t