(Giuseppe Maxia) One of the goodies of MySQL Proxy is the execution of multiple queries in response of a single query from the client.
Tag: Open Source
MySQL Performance on Memory Appliance
(Peter Zaitsev) Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system.
How do you rename a database
(Leo Hsu and Regina Obe) You’ve created a database but made an embarrassing typo in the name or for whatever reason you don’t like it. How do you rename this database?
MySQL information_schema: Identifying rows from TABLE_CONSTRAINTS
(Roland Bouman) Yesterday, I set out a little quiz about the TABLE_CONSTRAINTS table in the MySQL information_schema. The task was: –Specify a minimal set of columns of the information_schema.TABLE_CONSTRAINTS table that is sufficient to reliably identify a single row in the information_schema.T
Constraint Exclusion when it fails to work
(Leo Hsu and Regina Obe) Constraint Exclusion is a feature introduced in PostgreSQL 8.1 which is used in conjunction with Table Inheritance to implement table partitioning strategies. The basic idea is you put check constraints on tables to limit what kind of data can be inserted into it. Constraint
MySQL Proxy recipes: tokenizing a query
(Giuseppe Maxia) Using regular expressions for query handling can become prohibitively complex after a while. If you need to manipulate parts of a query, either you are a regexp guru (I mean it, really, someone who speaks regular expressions more fluently than English) or you find some alternatives.
Simple MySQL Proxy Failover
(Sheeri Cabral) mysql-proxy defaults to round-robin load balancing. There are fancy tricks around to get mysql-proxy to balance connections based on how many idle connections there are in a proxy-based connection pool.
MySQL Proxy recipes: parsing a query with regular expressions
(Giuseppe Maxia) If you want to filter a query for further usage, you need first to identify the query as the one to process, and then you need to isolate the elements to use for the task.
Why you want to be good at data modeling
(Robin Schumacher) To be really successful at working with databases, there are many different disciplines to become proficient in – things like disaster recovery, security management, data integration, and more. But there are less than a handful of things you want to be really good at; becoming sup
Setting Up A MySQL Cluster
(Artem Russakovskii) This article contains my notes and detailed instructions on setting up a MySQL cluster. After reading it, you should have a good understanding of what a MySQL cluster is capable of, how and why it works, and how to set one of these bad boys up. Note that I’m primarily a develope
