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.
11/10
Continuing the article we began in "Faster & Stronger MySQL", this article covers adding additional servers, and application changes in our quest to make our database faster, stronger, bigger and better.
11/04
When first introduced, a script or application process had to parse XML data and convert it into a valid format for the database and underlying system. Later, databases started to support XML so that no conversion was necessary. This article looks at XML support in MySQL.
