3/12
Learn a technique to fetch column data for MySQL crosstabs by emulating views. By replacing tables with a subquery subset, the resulting view will contain a limited dataset that has been filtered for that column field.
3/11
MySQL has an interesting architecture that sets it apart from some other enterprise database systems. It allows you to plug in different modules to handle storage. What that means to end users is that it is quite flexible, offering an interesting array of different storage engines with different features, strengths, and tradeoffs.
2/23
Inserting additional columns to a crosstab query is less straightforward than adding row data, because SQL naturally groups data by rows. Moreover, the efficacy of the CASE statement within an aggregate function decreases in direct proportion to the complexity of the criteria. Read on to learn more...
2/22
MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis.
2/11
Heartbeat automates all the moving parts and can work as well with the MySQL master-master active/passive solution as well as it can with the MySQL & DRBD solution. It manages the virtual IP address used by the database, directs DRBD to become primary, or relinquish primary duties, mounts the /dev/drbd0 device, and starts/stops MySQL as needed.
2/05
Rob Gravelle takes a
complex SQL statement and shows you several ways to re-write it that both
simplifies and shortens it, while still yielding the same results.
1/28
MySQL's Latin-1 default encoding combined with MySQL 4.1.12's (or greater) UTF8 encoding allows the maximum number of characters codes, however incoming data with different character encoding can still present problems. Rob Gravelle shows you how to avoid problems before a lot of work is required to undo the damage.
1/04
DRBD is a Linux project that provides a real-time distributed filesystem. Sean Hull demonstrates how to use Sun's virtualbox software to create a pair of VMs, then configure those VMs with DRBD, and finally install and test MySQL running on volumes sitting on DRBD.
12/30
Monty Widenius launches a new campaign to stop the Oracle-Sun merger.
12/29
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
12/21
Did you know that MySQL has supported subqueries since version 4.1? In fact, it even boasts a few MySQL-specific features! Rob Gravelle shows you how to use subqueries in MySQL to get the most out of your SELECT queries while making your SQL more readable.
12/10
DRBD is not only an exciting technology, and a great match with MySQL but it provides
a more bulletproof, HA solution for MySQL when you want to do seamless failover. But wait! There's more! It requires less maintenance, and avoids many of the headaches of in-built MySQL replication.
12/04
New York Post claims the database giant gave in to EU concerns.
11/23
During the past few weeks, we've been getting better acquainted with XML support in MySQL. This article finishes the series by talking about how to manipulate XML data using the XPath, which is a language for navigating and querying XML documents.
11/19
Today's article continues to explore XML support in MySQL. Specifically, we'll look at a nicer way to format our resultset. We'll also discuss how to retrieve all of the records from the XML document, using a stored procedure.