MySQL Workbench is a cross-platform, graphical database modeling tool for MySQL. It allows you to create database models from scratch as well as by importing existing databases from SQL or DBDesigner4 models. You can then generate SQL code to CREATE databases, ALTER them, and export in various image formats and PDF/PS. Its extension system allows writing plugins and scripts in Lua, Python, and C++.
Usenet Downloader can be used to retrieve newsgroup articles from NNTP servers. There is a generic NNTP class that can retrieve listings of groups, listing of group articles, and the article headers and bodies. There are other classes that can retrieve listing of groups from several different sites and insert the listings into a MySQL database table. Other classes can retrieve groups stored in the database and retrieve articles of those groups from the NNTP servers.
check_mysql_health is a plugin for the Shinken (Nagios) software that allows you to monitor a MySQL database. Among the list of metrics are time to login, index usage, bufferpool hit rate, query cache hit rate, slow queries, temp tables on disk, table cache hit rate, connected threads, and many more. Requirements are either a DBD::mysql Perl module or a MySQL client package.
AShopV provides a shopping cart with digital goods delivery, affiliate tracking, Swoopo-style auctions, full PayPal support, support for many other payment gateways, many shipping calculation options, and multiple languages and currencies. The software also includes a CRM Sales Office with order management where you can create quotes and turn them into bills that can be paid online, set up automatic recurring billing, manage purchase orders, handle customer and vendor contact through POP3 or IMAP, and view customer and vendor history. A Shopping Mall integrates with the affiliate tracking to let you set up your own ClickBank clone.
Loomes' Nested Set is a class that can be used to manage a tree of information stored in a database. It can perform several types of operations to manipulate a hierarchy of nodes that are stored in a database as table records. Currently, it can insert a root node, insert a node that is child of a given parent, delete a branch of nodes under a given node, delete a single node, rename a node, move nodes, check whether the root node exists, and retrieve the whole tree of nodes.
MySQL Split Read/Write for Drupal is a patch for Drupal versions 5 and 6 that allows a Drupal-based Web site to access a multi-server MySQL setup with master/slave replication. This allows Drupal to send all MySQL select (read) queries to the slave nodes, while allowing insert, update, and select (write and read) queries to be pointed at the master node. The code modification allows for an increased 30% improvement under query-based transactions on this platform environment.