Database Administration
Linux Magazine's Jeremy Garcia shows you how to take command of MySQL using MySQL Proxy, a lightweight application that sits between MySQL server and client applications. Using MySQL Proxy, you can set up load balancing, dynamic fail over, query analysis, query filtering, query modification, and more.
In March's "LAMP Post" column, we started to look at MySQL's replication subsystem. We covered how replication works, as well as putting it to use by configuring the master and slave(s). This month, in this inaugural "MySQL" column, let's spend some time looking at the lesser known aspects of MySQL replication, including filtering and log inspection.
Get under the hood of MySQL to find out how you can speed up your database applications.
This paper shows you how you can achieve true high availability and scalability for your PostgreSQL database.
Database Programming
All the prowess of Perl, plus a powerful
application framework
| Top Stories
New and nifty features in PostgreSQL 8.3 that could turn the head of even the MySQL faithful make it a must-have upgrade.
MySQL 5 promises many new features.
Since assuming the mantle of leadership of MySQL AB in 2001, M�rten Mickos has steered the database software company from open source darling to open source powerhouse, multiplying revenue some twentyfold in a very short time. On the eve of the release of MySQL 5.0, Linux Magazine spoke with Mickos about the unique challenges of running the decidedly unique — and very successful — software company.
This month and next, we'll look at the most significant addition to MySQL 4.1: native clustering. This month, let's start with an overview of the new clustering technology, see how it's been integrated into MySQL, and understand the benefits it provides. Next month, we'll cover the steps necessary to get a cluster up and running.
Six years ago, Oracle announced support for Linux, perhaps singlehandedly sparking the widespread adoption of Linux in the enterprise. Today, Oracle's Linux market share is growing by leaps and bounds, backed by the elegance, scalability, and low cost of Linux application clusters.
Suppose that you want to contact a company that you've found on the Internet, but you don't know where it's located, and the only contact information provided on the "About the Company" web page contains a phone number with the unfamiliar area code of 323. You could call them up, hope to reach a real person, and ask where the company is located. Or, you could look up what geographical region uses that area code. Using everyone's favorite search engine, and within a few clicks, you see that 323 is a new area code for Los Angeles. Problem solved, and time to move on.
MySQL is great for building database-driven Web sites of all shapes and sizes. It's fast, easy to configure, and incredibly reliable. But MySQL lacks a mature, easy-to-use GUI administration tool. Yes, you can use the mysql command-line, but that's rather tedious and you don't get a good overall picture of your server without doing a lot of typing.
The folks at Red Hat recently selected the open source PostgreSQL database as the foundation for their commercial Red Hat Database product. This decision, however, was not made without a good deal of whining from the ranks of the MySQL faithful, who weren't able to fully comprehend why it was that their baby had been passed over.
|
