Posts by Sheeri Cabral
This is the 137th edition of Log Buffer, the weekly review of database blogs.
In this first Drizzle podcast, Jay Pipes and I talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint. The podcast can be downloaded (5.76 Mb as an mp3 file) or played right through your browser, There are links in this post.
I have been talking more and more with colleagues about the Open Source community and licenses. Zak Greant recently wrote in Free Culture vs. Fear Culture vs. Fee Culture that, “People with bad intentions will do bad things . . . often regardless of the license on the work.” And, unfortunately, he is right. If I release an article or presentation video with a Creative Commons license, it is still possible for my work to be plagiarized, and if it is, I will still feel violated. Many of us who use Creative Commons or MySQL have an Open Source mentality. We often do not see value in pirating software—why would we use Microsoft Word (a legally licensed copy, or pirated) if we can use OpenOffice or NeoOffice?
As many of us know, the 5th annual MySQL Conference and Expo is happening April 20-23rd, 2009 in Santa Clara, California. The theme is Innovation Everywhere, and this year the conference organizers have taken an innovative page from OSCon and decided to host a free “camp” during the conference.
Slaves can be used for: horizontal read scalability, disaster recovery, consistent Backups. Be careful when using a slave for more than one purpose. Using a slave for more than one purpose can be done, but carefully. For example…
In this post I explain the different types of backup primers in MySQL and examine how the work.
f you are using InnoDB Hot Backup and a recent version of mysqld (at least 5.0.67 or higher, including 5.1.30, though it may be later versions), your backup will run fine and output OK! at the end, as it should. Except for one thing. The binary log file and position do not appear in their rightful place. Here’s a snippet of the output from the backup…The bug is an artifact of the eventual deprecation of TYPE in favor of ENGINE. There’s no reason for ibbackup to continue to use TYPE; while the product works well, it is much more expensive than it warrants.
At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning. The slides and video are available here.
So, a colleague ran into issues booking the Santa Clara Hyatt Regency Hotel—apparently there were no rooms with 2 double beds left for the MySQL 2009 Conference and Expo.
I realized tonight exactly why MySQL’s default behavior of silent truncation bothers me. It reminds me of people who use a ticketing system and close every ticket as soon as they are done working on the issue instead of actually asking the other party if they are satisfied, because closing more tickets make it look like they’re doing more work.