You need to enable JavaScript to view more than 15 articles by this author.
Getting Started with MySQL Proxy Publish Date: Jul. 12, 2007
Imagine if you could make non-relational data looking like it came out of a database. Using MySQL Proxy, you can get access to such prosaic information as system uptime and virtual memory statistics, as well as being able to rewrite queries on the fly before they get to the database.
MySQL Federated Tables: The Missing Manual Publish Date: Aug. 10, 2006
A new MySQL storage engine allows you to use tables in remote servers as if they were local. Unfortunately, the documentation doesn't explain much more than that. Fortunately, Giuseppe Maxia can explain everything you need to know to make federated tables work correctly and efficiently.
Advanced MySQL Replication Techniques Publish Date: Apr. 20, 2006
MySQL Cluster is a powerful peering system to add high availability and replication across multiple database servers. It's not perfect, though. Using features of MySQL 5.0 and 5.1, it's possible to build a master/slave replication system with fail-over. Giuseppe Maxia shows how.
Generating Database Server-Side Cross Tabulations Publish Date: Dec. 4, 2003
Normalizing data into a database saves you time and trouble representing information, but actually displaying and reporting that information is trickier. Crosstabs (or pivot tables) make it easier, though trying to pivot on more than two fields is painful. That's where generating crosstab queries can help. Giuseppe Maxia demonstrates.
