DRX

√app«drx

Web Developer Resource Index: MySQL

MySQL is an open source relational database management system (RDBMS). It is designed for simplicity and speed, with many features of the big commercial database systems as well. It is very popular with Web developers for delivering dynamic content.

MySQL forms the ‘M’ in the acronym AMP. And while most commonly used with the PHP programming language, there are also interface libraries available for Perl, Python and vast assortment of others including C and C++, Lisp, Eiffel, Smalltalk, Java, Ruby and Tcl.

MySQL is portable. It is designed for use on a wide variety of platforms and operating systems including the open source Unix-like Linux, FreeBSD, Mac OS X, and many others including NetBSD, OpenBSD, Windows, OS/2, AIX, HP-UX, and SunOS/Solaris.

loadaverageZero uses MySQL. To learn more about how I use MySQL, including the schema for this application, I recommend exploring my dbrowse application.

Updated: Wednesday, December 3rd, 2008 @ 1:00 PM EST

Software:Databases:MySQL {0}(24)[26]

Visit Category:

Navigation

§ Title Index

§ Tag Cloud

§ Related Categories

§ Other Indexes

§ Search and RSS

Resources

1.MySQL Reference Manual

The Reference Manual for the MySQL Database System. It documents MySQL up to the latest version, but is also applicable for older versions of the MySQL software. [50]
★★★★☆
URI:http://dev.mysql.com/doc/mysql/
Author:
Documentation Staff
[1]
Reviewed:Tuesday, April 26th, 2005 @ 3:27 AM EDT
by:
Douglas Clifton

MySQL Reference Manual database mysql reference
2.MySQL Tips

Content trumps everything else in this index, and this resource is basically just plain text (all 135k of it!). But oh what a resource, it's packed full of outstanding MySQL tips, and the advanced SQL query techniques towards the end are mind boggling. [1450]
★★★★★
URI:http://souptonuts.sourceforge.net/readme_mysql.htm
Author:
Mike Chirico
[1]
Reviewed:Saturday, July 30th, 2005 @ 11:07 PM EDT
by:
Douglas Clifton

MySQL Tips howto mysql sql sysadmin tutorial
3.MySQL Forge

MySQL Forge is a repository of tools, projects, roadmaps, and wiki content that is created and maintained by the MySQL user and developer community. It is intended to be a resource for learning, contributing, and sharing information, techniques, and code. [1860]
★★★★☆
URI:http://forge.mysql.com/
Author:
MySQL AB
[1]
Reviewed:Wednesday, December 3rd, 2008 @ 1:00 PM EST
by:
Douglas Clifton

MySQL Forge code community developer mysql repository resources tools wiki
4.ONLamp: MySQL DevCenter

An O'Reilly ONLamp Development Center dedicated to this popular open-source RDBMS. Features articles on such topics as installation and configuration, optimization and performance tuning, backups, table engines, replication, SQL, and scripting interfaces. [1775]
★★★★☆
URI:http://www.onlamp.com/onlamp/general/mysql.csp
Author:
O'Reilly Network
[13]
Reviewed:Sunday, October 26th, 2008 @ 12:35 AM EDT
by:
Douglas Clifton

ONLamp: MySQL DevCenter config database developer install mysql onlamp open-source oreilly performance sql
5.Building a High-Availability MySQL Cluster

Serious business services really can't go down, whether due to hardware or software failures. If your necessary services rely on MySQL, clustering and high availability can prevent failures. This article covers configuring MySQL Cluster and Heartbeat. [1647]
★★★★☆
URI:http://oreillynet.com/pub/a/databases/2006/02/16/ha_mysql_cluster.htm...
Author:
Kris Buytaert
[1]
Reviewed:Saturday, February 18th, 2006 @ 2:52 AM EST
by:
Douglas Clifton

Building a High-Availability MySQL Cluster config database mysql sysadmin
6.Securing MySQL: Step-by-Step

Unfortunately, the default installation of MySQL, and in particular the empty root password and the potential vulnerability to buffer overflow attacks, makes the database an easy target for attacks. Learn how to close these gaps in this detailed article. [1523]
★★★★☆
URI:http://securityfocus.com/infocus/1726
Author:
Artur Maj
[1]
Reviewed:Wednesday, August 31st, 2005 @ 1:41 AM EDT
by:
Douglas Clifton

Securing MySQL: Step-by-Step config mysql security sysadmin
7.Schemaball

Schemaball is a Perl script which uses GD to generate formatted MySQL database schema views. Schemaball is well-suited for use in publications, online or print, presentations or schema development, and is suitable for visualizing schemas of all sizes. [1502]
★★★★☆
URI:http://mkweb.bcgsc.ca/schemaball/
Author:
Martin Krzywinski
[1]
Reviewed:Friday, August 19th, 2005 @ 5:43 PM EDT
by:
Douglas Clifton

Schemaball database graphics mysql perl schema
8.mMaim

MySQL Monitoring And Investigation Module: monitors and analyzes MySQL servers and easily integrates into any environment. It can show Master/Slave sync and efficiency stats, returns statistics from most of the "show" commands and more. From Google Code. [1499]
★★★★☆
URI:http://goog-mmaim.sourceforge.net/
Author:
Google
[11]
Reviewed:Friday, August 19th, 2005 @ 1:25 AM EDT
by:
Douglas Clifton

mMaim database google mysql open-source performance python servers sysadmin
9.Pros and Cons of MySQL Table Types

In addition to the default MyISAM table type, MySQL supports several others, some of which have more advanced features like transactions and rollbacks. In this article, Dr. Horn discusses the advantages of the MERGE, HEAP (memory), InnoDB and BDB types. [1427]
★★★★☆
URI:http://developer.com/db/article.php/2235521
Author:
John W. Horn PhD
[1]
Reviewed:Friday, July 22nd, 2005 @ 3:23 PM EDT
by:
Steve Perjesi

Pros and Cons of MySQL Table Types database mysql reference
10.MySQL Database Design

Careful design of your database schema pays BIG dividends later. In this detailed 10-part article, the author covers keys and relationships, 1st, 2nd and 3rd Normal Form, MySQL data types, null and default values, and indexing to improve performance. [1342]
★★★★☆
URI:http://peachpit.com/articles/article.asp?p=30885
Author:
Larry Ullman
[1]
Reviewed:Monday, June 27th, 2005 @ 1:47 AM EDT
by:
Douglas Clifton

MySQL Database Design database design mysql normalization performance schema
11.MySQL Protocol

A detailed document describing the low-level implementation of the MySQL protocol (version 10). Included is a descripion of the two most common client-server connection methods: via localhost, or a Unix socket, and over a TCP/IP network (port 3306). [1337]
★★★★☆
URI:http://www.redferni.uklinux.net/mysql/MySQL-Protocol.html
Author:
Ian Redfern
[1]
Reviewed:Sunday, June 26th, 2005 @ 12:09 AM EDT
by:
Douglas Clifton

MySQL Protocol client-server mysql protocol tcp
12.Storing Hierarchical Data in a Database

If the category system for drx was large, I would need to redesign my recursive implementation of the treeview (and OPML). In this article, Gijs discusses this simple approach, and then moves on to the more robust tree traversal methods. [1319]
★★★★☆
URI:http://www.sitepoint.com/article/hierarchical-data-database
Author:
Gijs van Tulder
[1]
Reviewed:Wednesday, June 22nd, 2005 @ 2:27 PM EDT
by:
Douglas Clifton

Storing Hierarchical Data in a Database database developer mysql schema sql
13.Tagging Systems in MySQL

This is Phillip's entire MySQL category, as all the articles are related and follow each other as he explores database schemas and query implementations for developing tagging systems in MySQL. Lots of developer feedback, highly recommended. [1318]
★★★★☆
URI:http://www.pui.ch/phred/archives/category/computer/database/mysql/
Author:
Philipp Keller
[1]
Reviewed:Wednesday, June 22nd, 2005 @ 2:22 PM EDT
by:
Douglas Clifton

Tagging Systems in MySQL del.icio.us mysql query schema sql tagging
14.myphp

Embeds a PHP interpreter into your MySQL server. Afterwards, a single User-Defined Function (UDF), php() becomes a gateway to the entire PHP library of functions you can call against the data columns in your SQL queries. Hmmm...myPerl? Of course! [1306]
★★★★☆
URI:http://www.sklar.com/page/article/myphp
Author:
David Sklar
[2]
Reviewed:Sunday, June 19th, 2005 @ 6:06 PM EDT
by:
Douglas Clifton

myphp mysql php programming
15.An Introduction to Database Normalization

The goal of normalization is to reduce data redundancy and improve performance, if at the cost of more complex queries. Although not strictly related to MySQL, this excellent article is worth your time and will improve your DB schema design skills. [1304]
★★★★☆
URI:http://dev.mysql.com/tech-resources/articles/intro-to-normalization.h...
Author:
Mike Hillyer
[1]
Reviewed:Sunday, June 19th, 2005 @ 1:55 PM EDT
by:
Douglas Clifton

An Introduction to Database Normalization database mysql normalization performance schema sql
16.How to Optimize MySQL with @Mail

Sometimes you find high quality resources in unlikely places. If this comprehensive guide to optimizing your MySQL installation, table and query design, and database maintenance, is any indication, then the folks at @Mail have a top-notch product. [1285]
★★★★☆
URI:http://support.atmail.com/mysqloptimize.html
Author:
atMail Support
[1]
Reviewed:Saturday, June 11th, 2005 @ 3:23 PM EDT
by:
Douglas Clifton

How to Optimize MySQL with @Mail database howto mysql performance sysadmin
17.MySQL Cheat Sheet

Dave has done it again, this time for MySQL: a handy printable quick reference that includes built-in functions for use in your queries, a list of the MySQL data types, PHP functions for accessing your databases, and some sample MySQL queries. [1237]
★★★★☆
URI:http://www.addedbytes.com/cheat-sheets/mysql-cheat-sheet/
Author:
Dave Child
[7]
Reviewed:Wednesday, May 25th, 2005 @ 3:47 PM EDT
by:
Douglas Clifton

MySQL Cheat Sheet cheatsheet database mysql php query reference sql
18.Comparing MySQL Performance

Detailed comparison of MySQL performance under a number of different operating systems, including Linux, FreeBSD, NetBSD, OpenBSD and Solaris using the Super Smack and SysBench benchmarking utilities. [1067]
★★★★☆
URI:http://software.newsforge.com/article.pl?sid=04/12/27/1243207
Author:
Tony Bourke
[1]
Reviewed:Friday, April 29th, 2005 @ 2:28 AM EDT
by:
Douglas Clifton

Comparing MySQL Performance benchmark bsd database freebsd linux mysql performance
19.Dev Shed: MySQL

MySQL help, tutorials, articles, code samples, and other resources. Features in-house authors, freelance writers, and several exclusive publishing relationships. [1052]
★★★★☆
URI:http://www.devshed.com/c/b/MySQL/
Author:
Contributors
[10]
Reviewed:Tuesday, April 26th, 2005 @ 4:29 AM EDT
by:
Douglas Clifton

Dev Shed: MySQL mysql
20.mysql.faqts

MySQL frequently asked questions and tips. [55]
★★★★☆
URI:http://faqts.com/knowledge_base/index.phtml/fid/52
Author:
Community
[19]
Reviewed:Monday, April 4th, 2005 @ 9:20 PM EDT
by:
Douglas Clifton

mysql.faqts faq mysql
21.Build your own Database Driven Website using PHP & MySQL

A hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database-driven Website using PHP & MySQL. [54]
★★★★☆
URI:http://www.sitepoint.com/article/php-mysql-tutorial
Author:
Kevin Yank
[1]
Reviewed:Monday, April 4th, 2005 @ 8:09 PM EDT
by:
Douglas Clifton

Build your own Database Driven Website using PHP & MySQL database developer mysql php
22.MySQL Functions

Complete documentation on the PHP functions for accessing MySQL servers and the databases they contain. [53]
★★★★☆
URI:http://php.net/mysql/
Author:
PHP Staff
[3]
Reviewed:Monday, April 4th, 2005 @ 8:12 PM EDT
by:
Douglas Clifton

MySQL Functions database mysql php reference servers
23.The phpMyAdmin Project

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. [52]
★★★★☆
URI:http://www.phpmyadmin.net/home_page/
Author:
Tobias Ratschiller
[1]
Reviewed:Monday, April 4th, 2005 @ 7:23 PM EDT
by:
Douglas Clifton

The phpMyAdmin Project mysql php sysadmin
24.MySQL Projects

A collection of projects from the author that are related to MySQL, a fast and reliable Open Source Relational Database Server. [51]
★★★★☆
URI:http://jeremy.zawodny.com/mysql/
Author:
Jeremy Zawodny
[1]
Reviewed:Friday, October 20th, 2006 @ 12:08 AM EDT
by:
Douglas Clifton

MySQL Projects database mysql open-source