MySQL FULLTEXT Searching (54 tags)
Storing text in your database is handy, but searching can be a pain. MySQL's
FULLTEXT search can save your sanity. Joe Stump demonstrates how it works and gives several ideas on how to use it in your own applications.
Live Backups of MySQL Using Replication (53 tags)
One of the difficulties with a large and active MySQL database is making clean backups without having to bring the server down. A simple method to ensure reliable backups is to set up replication for MySQL. Russell Dyer, author of MySQL in a Nutshell, walks through the process of using replication for data backups.
Advanced MySQL Replication Techniques (53 tags)
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.
Dreaming of an Atom Store: A Database for the Web (49 tags)
In this month's The Restful Web column, Joe Gregorio draws together some disparate threads into a single, exciting idea: the Atom Store.
How to Misuse SQL's FROM Clause (38 tags)
Many SQL queries misuse their
FROM clauses. Misuse them? That's right. Stéphane Faroult explains this common mistake and demonstrates how two types of subqueries can improve performance and reliability.