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