(Giuseppe Maxia) Working with MySQL Proxy, besides returning a dataset and an error you could also return a status of successfully executed query, without a dataset being involved. For example, every data modification query (INSERT, UPDATE, DELETE, CREATE …, DROP …) returns such a result.

(Paul Moen) So you have got your nice MySQL Master-Slave replication pair setup. Everything is sweet, then the master dies/restarts or you have a slightly extended network outage.

(Brian Aker) A number of months ago, possibly a year ago, I wrote an internal letter to the MySQL internal discuss list with the title of “The Death of Read Replication”. Ever since then I’ve been getting pinged internally to publish my thoughts on this externally.

(Leo Hsu and Regina Obe) People have asked us on several occasions if there is such a construct SELECT * EXCEPT(…list) FROM sometable. Sadly we do not think such a thing exists in the ANSI SQL Specs nor in PostgreSQL.

(Peter Zaitsev) We have an application which stores massive amount of urls. To save on indexes instead of using URL we index CRC32 of the URL which allows to find matching urls quickly. There is a bit of chance there would be some false positives but these are filtered out after reading the data so

(Robin Schumacher) Performance tuning is one of the top disciplines (if not THE top discipline) that database professionals want to excel at. Being able to take a system that’s running sluggish and turn it into one that’s running as fast as a scalded dog is a talent that’s part art and part science,

(Giuseppe Maxia) MySQL Proxy, in addition to dealing with the packets sent between client and server, can optionally send text messages to the terminal window where it was launched. These messages, using the built-in function print(), can be very useful when you develop an application, because can g

(Peter Zaitsev) Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I did not find it with two minutes of googling so I wrote a simple one myself and posting it here for public benefit or my late

(Giuseppe Maxia) MySQL Proxy allows you to execute multiple queries, by inserting them into the query queue.

(Rob Young) In an earlier article I described how MySQL Enterprise takes the guesswork out of deciding which version of the MySQL server customers should be running by providing alerts around regularly scheduled Monthly Rapid Update and Quarterly Service Pack releases of the Enterprise Server. Being