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...]
IOUG MySQL Council, Collaborate and MySQL CE
I’ve had a week to think about and listen to the varying feedback around the O’Reilly MySQL and Collaborate conferences. There are many good points in the conversation I’ve been listening to. In particular, Baron Schwarz reminds everyone that the O’Reilly Conference brings together a unique cohort once a year that everyone … [Read more...]
Remote DBA for Drizzle
This morning at the MySQL User Conference and Expo, we’re excited to be included in Brian Aker’s keynote “The State of Drizzle” as one of the first organization to offer support for Drizzle now that it has reached GA with the release of Drizzle 7. Brian Aker is the CTO of Data Differential and is the lead developer for the … [Read more...]
Blue Gecko at the 2011 MySQL Conference
Hello to those of you who are in Santa Clara! Patrick Galbraith and I will be here this week, speaking and glad handing. You can find us both in the Attendee Directory and identify either or both of us as someone you’d like to meet. Patrick’s Sessions are: 5:15pm Wednesday – Perl programming with MySQL and Drizzle 11:55am … [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...]
MySQL Council activities and presence at Collaborate and MySQL Conference
In the land of the MySQL council, the IOUG has created a survey asking for community feedback on the future of the council and the IOUG’s programming for MySQL. This is an excellent opportunity for us to shape how the largest independent user group supporting Oracle technologies helps our community grow and work with Oracle going … [Read more...]
IOUG’s MySQL Council statement on public bug database uses
Being a MySQL Council member is something that takes up some of my time, but what I get in return is to help the community address issues in with Oracle when there is a lack of communication or understanding. The council drafted a statement late last week after Mark Callaghan’s post “Where have all the bugs gone?” and has reached … [Read more...]
Ninja tricks in top!
One of our senior MySQL DBAs, Mike Hamrick, wasn’t feeling well this week and so stayed home from the office. Instead of actually resting, produced this video about reading top output! I leave it to you all to watch and learn from our local tool tip pro. And, feel better Mike! Related posts:Introducing the Bluegecko MySQL Training … [Read more...]
OurSQL update and recording day!
The OurSQL podcasts will eventually make it into the Blue Gecko blog. But, in the mean time, I’d like to summarize what Sheeri Cabral and I have been getting up to. As I mentioned in the OurSQL revival post we are working to bring you a podcast every week about something technical or community related. Since mid-December, we’ve … [Read more...]
Patrick Galbraith named Oracle ACE!
A big congratulations to our very own Patrick Galbraith, who has just been recognized as an Oracle Ace for MySQL! In addition to being an absolute MySQL rock star, in his “spare time” he maintains DBD::mysql, DBD::drizzle, FederatedX storage engine and the Memcached Functions for MySQL. He has just authored “Developing Web Applications using … [Read more...]
2011 MySQL community dinner (west) at the O’Reilly MySQL Conference
This year’s facts: What: MySQL community dinner (west) Who: me, you, and many MySQL community members When: Monday, April 11th – Meet at 6:30 at the Hyatt Santa Clara or at 7 pm at the restaurant Where: Pedro’s Restaurant and Cantina – 3935 Freedom Circle, Santa Clara, CA 95054 How: Please RSVP and share this invitation with the community. I … [Read more...]
MySQL Gotchas on Debian (and Ubuntu)
Blue Gecko works with clients who run many different operating systems. Our preference generally is RedHat Enterprise Linux or CentOS, but we have customers who range far and wide from there including Solaris, Windows, SuSE, and (more and more) Debian and Ubuntu. As we’ve become more familiar with Debian and Ubuntu we have found that those … [Read more...]