«

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: Thursday, October 19th, 2006 @ 11:08 PM EST [26]

Visit Category: Treeview of the Index  Accessibility  Apache  Browsers  C  CGI  CSS  Character Encoding  Clients  Data Formats  Databases  Design and Development  Developer Resources  Directories  Dublin Core  FOAF  Firefox  FreeBSD  GeoURL  HTML  HTTP  History  Innovators  Internet  JavaScript  Languages  Licenses  Linux  Mac OS X  Markup Languages  Media Types  Metadata  MySQL  OPML  OWL  Open Source  Opera  Operating Systems  PHP  PICS  Perl  PostgreSQL  Programming  Protocols  Python  RDF  RSS  Safari  Semantic Web  Servers  Site Promotion  Software  Standards  Style Sheets  URI  Unix  WWW  Web Developer News  XHTML  XMDP  XML  XML Languages  XPath  XPointer  XQuery  XSL  XSL-FO  XSLT

Navigation

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 @ 2:27 AM EST
  by:
  Douglas Clifton
  
  MySQL Reference Manual databasemysqlreference
   

• 2.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:Thursday, October 19th, 2006 @ 11:08 PM EST
  by:
  Douglas Clifton
  
  MySQL Projects databasemysqlopen source
   

• 3.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 configdatabasemysqlsysadmin
   

• 4.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 @ 12:41 AM EST
  by:
  Douglas Clifton
  
  Securing MySQL: Step-by-Step configmysqlsecuritysysadmin
   

• 5.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 @ 4:43 PM EST
  by:
  Douglas Clifton
  
  Schemaball databasegraphicsmysqlperlschema
   

• 6.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
  [8]
  Reviewed:Friday, August 19th, 2005 @ 12:25 AM EST
  by:
  Douglas Clifton
  
  mMaim databasegooglemysqlopen sourceperformancepythonserverssysadmin
   

• 7.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 @ 10:07 PM EST
  by:
  Douglas Clifton
  
  MySQL Tips howtomysqlsqlsysadmintutorial
   

• 8.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 @ 2:23 PM EST
  by:
  Steve Perjesi
  
  Pros and Cons of MySQL Table Types databasemysqlreference
   

• 9.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 @ 12:47 AM EST
  by:
  Douglas Clifton
  
  MySQL Database Design databasedesignmysqlnormalizationperformanceschema
   

• 10.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:Saturday, June 25th, 2005 @ 11:09 PM EST
  by:
  Douglas Clifton
  
  MySQL Protocol client-servermysqlprotocoltcp
   

• 11.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 traveral methods. [1319]

  ★★★★☆
  URI:http://www.sitepoint.com/article/hierarchical-data-database
  Author:
  Gijs van Tulder
  [1]
  Reviewed:Wednesday, June 22nd, 2005 @ 1:27 PM EST
  by:
  Douglas Clifton
  
  Storing Hierarchical Data in a Database databasedevelopermysqlschemasql
   

• 12.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 @ 1:22 PM EST
  by:
  Douglas Clifton
  
  Tagging Systems in MySQL del.icio.usmysqlqueryschemasqltagging
   

• 13.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 @ 5:06 PM EST
  by:
  Douglas Clifton
  
  myphp mysqlphpprogramming
   

• 14.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 @ 12:55 PM EST
  by:
  Douglas Clifton
  
  An Introduction to Database Normalization databasemysqlnormalizationperformanceschemasql
   

• 15.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 @ 2:23 PM EST
  by:
  Douglas Clifton
  
  How to Optimize MySQL with @Mail databasehowtomysqlperformancesysadmin
   

• 16.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.ilovejackdaniels.com/php/mysql-cheat-sheet/
  Author:
  Dave Child
  [4]
  Reviewed:Wednesday, May 25th, 2005 @ 2:47 PM EST
  by:
  Douglas Clifton
  
  MySQL Cheat Sheet databasemysqlphpqueryreferencesql
   

• 17.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 @ 1:28 AM EST
  by:
  Douglas Clifton
  
  Comparing MySQL Performance benchmarkbsddatabasefreebsdlinuxmysqlperformance
   

• 18.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
  [11]
  Reviewed:Tuesday, April 26th, 2005 @ 3:29 AM EST
  by:
  Douglas Clifton
  
  Dev Shed: MySQL mysql
   

• 19.mysql.faqts

  MySQL frequently asked questions and tips. [55]

  ★★★★☆
  URI:http://faqts.com/knowledge_base/index.phtml/fid/52
  Author:
  Community
  [22]
  Reviewed:Monday, April 4th, 2005 @ 8:20 PM EST
  by:
  Douglas Clifton
  
  mysql.faqts faqmysql
   

• 20.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
  [2]
  Reviewed:Monday, April 4th, 2005 @ 7:12 PM EST
  by:
  Douglas Clifton
  
  MySQL Functions databasemysqlphpreferenceservers
   

• 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 @ 7:09 PM EST
  by:
  Douglas Clifton
  
  Build your own Database Driven Website using PHP & MySQL databasedevelopermysqlphp
   

• 22.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 @ 6:23 PM EST
  by:
  Douglas Clifton
  
  The phpMyAdmin Project mysqlphpsysadmin
   

Related Categories

Matching Tags

benchmark bsd client-server config database del.icio.us design developer faq freebsd google graphics howto linux mysql normalization open source performance perl php programming protocol python query reference schema security servers sql sysadmin tagging tcp tutorial

Indexes

Search for MySQL on:

drx Search:

Last updated: Thursday, October 19th, 2006 @ 11:08 PM EST [2006-10-20T04:08:31Z]