(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.
Tag: Open Source
When SHOW SLAVE STATUS lies
(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.
The Death of Read Replication
(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.
How to SELECT ALL EXCEPT some columns in a table
(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.
Multi-Column IN clause – Unexpected MySQL Issue
(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
A look at Falcon Diagnostic Tables
(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,
MySQL Proxy Recipes – Debugging messages on demand
(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
Stored Function to generate Sequences
(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
MySQL Proxy Recipes – Conditional query execution
(Giuseppe Maxia) MySQL Proxy allows you to execute multiple queries, by inserting them into the query queue.
How the MySQL Enterprise Upgrade Advisor Helps DBAs Avoid Being Bitten by Known Bugs
(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
