After Further Review ...: Monthly Open Source Software Recap

Here is the February recap of news, blogs, links and other info regarding MySQL.  Lots of activity, you'll find the 'commits' at the end of the post.

• Using the MySQL Connector/J JDBC Driver With the Java SE Platform  

  http://java.sun.com/developer/technicalArticles/mysql_java/index.html

• The \G modifier in the MySQL command line client

  http://pento.net/2009/02/27/the-g-modifier-in-the-mysql-command-line-client/

• Backing up MySQL using file system snapshots

  http://www.lenzg.net/archives/245-Concluded-my-first-MySQL-University-Session-about-MySQL-backups-using-file-system-snapshots-some-questions-remained-unanswered....html

• Facebook DBAs Chris Schneider & Kevin Knapp Presentation is now online

  http://mysqltalk.wordpress.com/2009/02/26/powerpoint-presentation-of-facebook-dbas-chris-schneider-kevin-knapp-is-now-online/

• Drizzle Podcast #1

  http://www.pythian.com/news/1502/drizzle-podcast-1

• Another Drizzle Podcast

  http://technocation.org/content/drizzle-podcast-%25231

• Mixing engines in transactions

  http://mysqlmusings.blogspot.com/2009/02/mixing-engines-in-transactions.html

• Cool Little Utilities 

  http://tag1consulting.com/node/54

• InnoDB Hot Backup Utility Bug 

  http://www.pythian.com/news/1500/innodb-hot-backup-utility-bug

• Watching a MySQL Slave Catch Up

  http://ronaldbradford.com/blog/watching-a-slave-catchup-2009-02-24/

• Moving data from SQL Server to MySQL

  http://www.haidongji.com/2009/02/23/moving-data-from-sql-server-to-mysql/

• Upgrading MySQL with minimal downtime through Replication

  http://pento.net/2009/02/24/upgrading-mysql-with-minimal-downtime-through-replication/

• Stored Procedures are Slow (Part II)

  http://dbscience.blogspot.com/2009/02/stored-procedures-are-slow-part-2.html

• MySQL Proxy: Yet Another MySQL Shell 

  http://jan.kneschke.de/2009/2/23/mysql-proxy-yet-another-mysql-shell

• Save time and energy: How to …

  http://mysqlpreacher.com/wordpress/2009/02/save-time-and-energy-how-to/

• MySQL DB Pie Graph

  http://www.ruturaj.net/mysql-google-pie-charts

• Best Practices for Migrating to MySQL

  http://ronaldbradford.com/presentations/#200902

• Quick Tip: Demangling MySQL static DTrace probes

  http://blogs.sun.com/amitsaha/entry/quick_tip_demangling_mysql_static

• The 5 minute DBA: Storage Engine Selection

  http://www.bigdbahead.com/?p=130

• Log Buffer #136: A Carnival of the Vanities for DBAs
  

  http://www.pythian.com/news/1498/log-buffer-136-a-carnival-of-the-vanities-for-dbas

• MySQL Proxy: .address is now .dst|src.name

  http://jan.kneschke.de/2009/2/20/mysql-proxy-address-is-now-dst-src-name

• My Favorite New Feature of MySQL 5.1: Less InnoDB Locking

  http://harrison-fisk.blogspot.com/2009/02/my-favorite-new-feature-of-mysql-51.html

• On MySQL Slave Usage 

  http://www.pythian.com/news/1496/on-slave-usage

• A MySQL Backup Primer 

  http://www.pythian.com/news/1495/a-mysql-backup-primer

• Performance Tuning Knowledge is Important for the New DBA

  http://mysql-dba-journey.blogspot.com/2009/02/performance-tuning-knowledge-important.html

• Even more on Stored Procedure performance 

  http://karlssonondatabases.blogspot.com/2009/02/even-more-on-stored-procedure.html

• Of Character Sets, MySQL, and localization woes… 

  http://www.linuxbloke.com/2009/02/19/of-character-sets-mysql-and-localization-woes/

• Developing MySQL on Solaris

  http://forge.mysql.com/wiki/Developing_MySQL_on_Solaris

• KDE 4.2 brings the MySQL server to the desktop

  http://www.bytebot.net/blog/archives/2009/02/19/kde-42-brings-the-mysql-server-to-the-desktop

• PHP 5.3: Persistent Connections with ext/mysqli 

  http://blog.ulf-wendel.de/?p=211

• Permissions by interface on the local server

  http://pento.net/2009/02/19/permissions-by-interface-on-the-local-server/

• MySQL for Developers 

  http://weblogs.java.net/blog/caroljmcdonald/archive/2008/09/mysql_for_devel.html

• Manually installing multiple MySQL instances on Linux: HOWTO

  http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto

• Leveraging Identity with Glassfish and MySQL

  http://www.sun.com/offers/details/LeveragingIdentityGlassFish.html

• Sun Blueprint : MySQL in Solaris Containers

  http://blogs.sun.com/mandalika/entry/deploying_mysql_in_solaris_containers

• MySQL, Windows 32-bit, and /3GB

  http://harrison-fisk.blogspot.com/2009/02/mysql-windows-32-bit-and-3gb.html

• MySQL Workbench 5.0.30 available  

  http://dev.mysql.com/workbench/?p=196

• MySQL Proxy: Lua classes

  http://jan.kneschke.de/2009/2/18/mysql-proxy-lua-classes

• Swapping Column Values in MySQL

  http://beerpla.net/2009/02/17/swapping-column-values-in-mysql/

• MySQL Memory allocation & TMPDIR

  http://www.bigdbahead.com/?p=121

• DRBD Management Console

  http://www.bytebot.net/blog/archives/2009/02/17/drbd-management-console

• Paper: Optimizing MySQL Database Application Performance with DTrace

  http://wikis.sun.com/display/BluePrints/Optimizing+MySQL+Database+Application+Performance+with+Solaris+Dynamic+Tracing

• A Better Parser Needed?

  http://www.jpipes.com/index.php?/archives/284-A-Better-Parser-Needed.html

• Replication Checksumming Through Encryption 

  http://pento.net/2009/02/16/replication-checksumming-through-encryption/

• Selective restoring using ndb_restore 

  http://blog.some-abstract-type.com/2009/02/selective-restoring-using-ndbrestore.html

• The Hidden Performance Bottleneck: Network (Part 2)

  http://www.bigdbahead.com/?p=119

• The Hidden Performance Bottleneck: Network (Part 1)

  http://www.bigdbahead.com/?p=100

• MySQL Plugin generator now supporting system variables 

  http://www.php-groupies.de/blogs/archives/28-MySQL-Plugin-generator-now-supporting-system-variables.html

• Date handling in MySQL

  http://blogs.sun.com/carriergrademysql/entry/date_handling_in_mysql

• The mess with Dates - And what really IS a valid date? 

  http://karlssonondatabases.blogspot.com/2009/02/mess-with-dates-and-what-really-is.html

• Poor man’s contention profiling

  http://dammit.lt/2009/02/15/poor-mans-contention-profiling/

• Case Insensitive REPLACE() for MySQL

  http://pento.net/2009/02/15/case-insensitive-replace-for-mysql/

• Contributing Code to MySQL -- Some Simple Guidelines

  http://blogs.sun.com/MortazaviBlog/entry/contributing_code_to_mysql_some

• MySQL Performance Schema (Part 7)

  http://blogs.mysql.com/peterg/2009/02/13/todo-mysql-performance-schema-7/

• Replication with InnoDB and MyISAM Transactions  

  http://pento.net/2009/02/13/replication-with-innodb-and-myisam-transactions/

• A Critical Warning If You Are Using InnoDB Hot Backup
  

  http://www.pythian.com/news/1485/a-critical-warning-if-you-are-using-innodb-hot-backup

• The 5 minute DBA: Default My.cnf File

  http://www.bigdbahead.com/?p=115

• Drizzle, MySQL, and the mess that is Dates and SQL_MODE

  http://www.jpipes.com/index.php?/archives/283-Drizzle,-MySQL,-and-the-mess-that-is-Dates-and-SQL_MODE.html

• Advanced MySQL Replication - Improving Performance 

  http://www.databasejournal.com/features/mysql/article.php/3801281/article.htm

• MySQL Magazine - Winter 2009 

  http://www.paragon-cs.com/mag/issue7.pdf

• Recovering an InnoDB table from only an .ibd file 

  http://www.chriscalender.com/?p=28

• Today's tip: The little known AS112 project 

  http://blogs.sun.com/trentlloyd/entry/this_week_s_tip_the

• Using DTrace with MySQL 

  http://forge.mysql.com/wiki/Using_DTrace_with_MySQL

• MySQL and UFS

  http://blogs.sun.com/realneel/entry/mysql_and_ufs

• Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications

  http://dev.mysql.com/tech-resources/articles/ebonat-exception-error-handling-implementation-in-vbnet-apps.html

• Recent MySQL Trends  

  http://mysql-dba-journey.blogspot.com/2009/02/recent-mysql-trends.html

• Reducing latency of queries with NBD Cluster realtime extensions

  http://www.bigdbahead.com/?p=109

• MySQL Performance Schema

  http://blogs.mysql.com/peterg/2009/02/05/mysql-performance-schema/

• Monitoring MySQL

  http://www.krisbuytaert.be/blog/monitoring-mysql

• Where Drizzle Is Succeeding

  http://www.jpipes.com/index.php?/archives/282-Where-Drizzle-Is-Succeeding.html

• Developing MySQL-Backed Applications with Netbeans, JRuby-on-Rails & Glassfish

  http://www.mysql.com/news-and-events/on-demand-webinars/display-od-272.html

• The Five Minute DBA: Fix your slow database - my.cnf parameters

  http://www.bigdbahead.com/?p=103

• Presentation: Partitioning in MySQL 5.1  

  http://www.pythian.com/news/1473/presentation-partitioning-in-mysql-51

• Facebook app creation: A look at the MySQL Quiz. (Part II)

  http://dave-stokes.blogspot.com/2009/02/facebook-app-creation-look-at-mysql_03.html

• mydumper

  http://dammit.lt/2009/02/03/mydumper/

• MySQL Replication - Audit, Test & Verify

  http://oracleopensource.com/2009/02/03/oreilly-webcast-mysql-replication-audit-test-verify/

• Facebook app creation: A look at the MySQL Quiz. (Part I)  

  http://dave-stokes.blogspot.com/2009/02/facebook-app-creation-look-at-mysql.html

• Triggers Use Case Compilation (Part III) 

  http://code.openark.org/blog/mysql/triggers-use-case-compilation-part-iii

• Quick DB Setups With MySQL Sandbox 

  http://blog.johngoulah.com/2009/01/mysql-sandbox/

• Recordings from Jersey / JAX-RS Webinars Now Available 

  http://blogs.sun.com/theaquarium/entry/recordings_from_jersey_jax_rs

• And finally, the commits for February 2009:

  http://lists.mysql.com/commits?date=2009-02

Here are some links to noteable news items, tips and other miscellaneous info on MySQL.  Please feel free to comment if I missed something relavant.

• MySQL and DTrace: Dynamically Tracing Better Performance

  http://dev.mysql.com/tech-resources/interviews/vince-carbone.html

• Open HA Cluster: Making MySQL highly available on Solaris

  http://dev.mysql.com/tech-resources/interviews/open-ha-cluster.html

• MySQL and ZFS: A File System Revolution

  http://dev.mysql.com/tech-resources/interviews/neelakanth-nadgir.html

• Performance Tuning: Scaling MySQL

  http://dev.mysql.com/tech-resources/interviews/allan-packer.html

• Another Look at MySQL 5.1’s SQL Diagnostic Tools

  http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html

• Exception Error Handling Implementation in MySQL/VB.NET Windows Database Applications

  http://dev.mysql.com/tech-resources/articles/ebonat-exception-error-handling-implementation-in-vbnet-apps.html

• Quick DB Setups with MySQL Sandbox 

  http://blog.johngoulah.com/2009/01/mysql-sandbox/

• Memcached Functions for MySQL 0.8 Released

  http://planet.mysql.com/entry/?id=17246

• MySQL Proxy: from 0.6.1 to 0.7.0

  http://planet.mysql.com/entry/?id=17242

• WFTO - End of January report Falcon Test Overview 2009-01-30

  http://esslingen.homeunix.net/~hakan/blog/2009/01/30/wfto-weekly-falcon-test-overview-2009-01-30/

• NULL fields in MySQL Row Format

  http://planet.mysql.com/entry/?id=17311

• MySQL AES Encryption Compatibility

  http://planet.mysql.com/entry/?id=17303

• Logging All Queries with MySQL 5.0

  http://planet.mysql.com/entry/?id=17214

• A Common Replication Error

  http://planet.mysql.com/entry/?id=17211

• Starting Point for Debugging MySQL

  http://planet.mysql.com/entry/?id=17313

• MySQL: Using CONNECT to Quickly Verify Replication Health

  http://planet.mysql.com/entry/?id=17197

• MySQL 6.0.9 Alpha Released

  http://planet.mysql.com/entry/?id=17188

• Expanding the MySQL Data Landscape

  http://planet.mysql.com/entry/?id=17187

• Putting 5.x Features to Good Use

  http://planet.mysql.com/entry/?id=17180

• Best Database Tool (MySQL Workbench)

  http://planet.mysql.com/entry/?id=17390

• Remote Connections Without Leaving the MySQL Shell

  http://planet.mysql.com/entry/?id=17167

• Optimizing Repeated Subexpressions in MySQL

  http://planet.mysql.com/entry/?id=17160

• 'GRANT ALL' to a Web DB User?

  http://planet.mysql.com/entry/?id=17157

• Query Cache and Comments

  http://planet.mysql.com/entry/?id=17151

• Another MySQL Proxy Tutorial

  http://planet.mysql.com/entry/?id=17146

• Demonstrating the Features of MySQL Native Driver for PHP, mysqlnd

  http://planet.mysql.com/entry/?id=17299

• Encrypting Replicated Data

  http://planet.mysql.com/entry/?id=17135

• Implementing Sharding in the Database

  http://planet.mysql.com/entry/?id=17130

• Caching and Actually Speeding Things Up

  http://planet.mysql.com/entry/?id=17074

• MySQL and Oracle: Top 10 things I love about them

  http://planet.mysql.com/entry/?id=17066

• Optimized MySQL Database Application Performance with Solaris Dynamic Tracing

  http://planet.mysql.com/entry/?id=17064

• Lesser Known MySQL Client Scripts

  http://planet.mysql.com/entry/?id=17060

• DBD::drizzle 0.003 Released
  

  http://planet.mysql.com/entry/?id=17053

• Setting, Changing and Resetting MySQL Root Passwords

  http://planet.mysql.com/entry/?id=17052

• InnoDB, MyISAM and Disk Space

  http://planet.mysql.com/entry/?id=17055

• MySQL Proxy is Back!

  http://planet.mysql.com/entry/?id=17045

• Refactoring MySQL Applications (Part 1)

  http://planet.mysql.com/entry/?id=17042

• Triggers Use Case Compilation (Part 1)

  http://code.openark.org/blog/mysql/triggers-use-case-compilation-part-i

• Triggers Use Case Compilation (Part 2)

  http://planet.mysql.com/entry/?id=17032

• Should You Move to InnoDB or MyISAM?

  http://planet.mysql.com/entry/?id=16963

• So, What is a Day Number?

  http://planet.mysql.com/entry/?id=16946

• Tips for Bulk Loading

  http://planet.mysql.com/entry/?id=16925

• Optimizer Tricks

  http://planet.mysql.com/entry/?id=16884

• A MySQL Cluster in Your Hand

  http://planet.mysql.com/entry/?id=16837

• MySQL 5.1 Q&A

  http://planet.mysql.com/entry/?id=16814

• A MySQL Cluster in Your Hand

  http://planet.mysql.com/entry/?id=16837