I know most articles are more about DBA issues, however, being a MySQL DBA means that you have several hats that you can where– data architect, application developer, MySQL source developer, and often good old fashioned DBA. I recently had an interesting problem with a particular project I was working on that required the MySQL source code … [Read more...]
DBD::mysql 4.020 Released
I’m pleased to announce the release of DBD::mysql, the MySQL Perl client, 4.020. The release has several great fixes provided by the community, and in particular from Masahiro Chiba, who fixed several issues pertaining to prepared statement support as well as UTF8 support, something that I myself have had a difficult time fixing and … [Read more...]
Life made easier: Facebook’s Online Schema Change for MySQL
So often, you have a task where you need to perform an alteration of a huge table while not wanting to affect the operation of your website. With an alter table, MySQL will internally lock the table in question, create a temporary table with the new table definition, copy the date, then drop the current table, then rename the temporary table to the … [Read more...]
DBD::mysql 4.019 released
Dear Perl and MySQL enthusiasts, I’m pleased to announce the release of DBD::mysql 4.019. I’m especially pleased because there are some new enhancements and features that have been provided by contributions from the community: * Asynchronous support, added by Rob Hoelz. This is a new feature to DBD::mysql that takes advantage of … [Read more...]
Narada 0.202 (plus AMI!) released
I’m pleased to announce the release of the Narada Search Engine Application, version 0.202, as well as a ready-to-use AMI, ami-140df07d. The source release can be found at Launchpad – lp:narada and and a packaged version at http://patg.net/downloads/narada-0.202.tar.gz What is Narada? Narada is a search engine application. It does have … [Read more...]
Blue Gecko Drizzle i386 AMI Now Available!
I’m pleased to announce that we have just released 32-bit Drizzle AMIs, based off of Amazon’s stock 32-bit RPM-based AMIs. Launch an instance of this AMI (and you can use a small instance), log in as “ec2-user”, and you will have an instant Drizzle server to utilize! This server is utilizing file-based authentication, but … [Read more...]
Blue Gecko Drizzle AMIs now available!
I’m pleased to announce that we’ve made available two Drizzle Amazon AMIs for the community to take advantage of! The AMIs are: ami-d408fabd – Blue Gecko Drizzle AMI This AMI is a ready-to-use AMI that comes with a complete Drizzle version 2011.03.13 GA installation as well as the client library and Perl DBD::drizzle … [Read more...]
DBD::drizzle 0.303 Released
I’m pleased to announce the release of DBD::drizzle 0.303! As Drizzle progresses in development, so too does DBD::drizzle. The main issue is that there are changes that I need to keep up to and that’s what this release primarily consists of. Most of the test suite was broken due to an error “Transactional DDL not supported” … [Read more...]
DBD::mysql 4.018 released
Dear Perl and MySQL developers, admins and enthusiasts, I'm please to announce the release of DBD::mysql 4.018! This release includes some code cleanups, added documentation as well as new features (database handle attributes) that allow you to be able to ascertain the server and client versions (Thank you to Robert M. Jansen). An example below, … [Read more...]
DBD::drizzle .301 released
Dear Perl and Drizzle developers, I’m pleased to announce the release of DBD::drizzle .301! This release implements several fixes: * Eric Day’s fix to a bug where a result can be NULL after error. * A lot of reworking of column_info() to utilize Drizzle’s DATA_DICTIONARY and INFORMATION_SCHEMA as opposed to describe and show … [Read more...]
Debugging Stored procedures
Over the past several weeks, we've been working on debugging a stored procedure bug for a client. Coming from a software development background, I looked at the procedure like any piece of code -- how can I debug the program and be able to use some means of knowing the values within the program while it's running? In C, I've always used GDB, as … [Read more...]