The latest from the MySQL community

Welcome to the 107th edition of the Log Buffer. My name is Keith Murphy and I am a MySQL database administrator for the Pythian Group. In addition, I am the editor of MySQL Magazine. This is my second go for the Log Buffer, so I must be doing something right!

This week for the open source world brings OSCON in Portland Oregon. There are plenty of MySQL people present and there have been more posting this week from these realms than normal. Also, Lewis Cunningham, among others, posted news that EnterpriseDB released the results of their open source survey at OSCON. The 451 CAOS Theory …

Linux desktop users: this post is probably not for you. You've got like a gazillion of these tools available.

Windows users: If you're like me, and use PuTTY all the time to manage your Linux MySQL servers, you'll appreciate this gem. It's called PuTTY Connection Manager and it, obviously, manages PuTTY connections. Not a very creative name, but a fine piece of software.

It's actively developed (latest alpha version out about two months ago), and boasts these features (taken from the developer website):

• Tabs and dockable windows for PuTTY instances.
• Fully compatible with PuTTY configuration (using registry).
• Easily customizable to optimize workspace (fullscreen, minimze to tray, add/remove toolbar, etc...).
• Automatic login …

Dana Blankenhorn asks whether open source is hurt by piracy, prompted by comments made by Louis Suarez-Potts, Sun’s community manager for OpenOffice.org at OSCON.

Dana is unconvinced that open source supporters should necessarily be doing anything about piracy, noting that “There is no direct financial loss to Open Office when someone has a pirated copy of Microsoft Office. To the extent that BSA enforcement actions cause fear in the market, that just benefits open source, so why join it?”

He also notes that “On the other hand if we helped Oracle enforce its license terms we might accelerate the move to MySQL and Ingres.”

However, one need only remember …

Larry Wall, Tim O'Reilly, Brian Aker, Michael Tiemann and more READ MORE

In an internal mail thread, I was asked whether there would be any “objections from an integration perspective” to some Sun initiated plans for a more organised French MySQL community.

My reply was that it’s great, if it’s something related to the self-organisation of the already very active French MySQL community (as witnessed for instance by the huge numbers that Véronique Loquet of Al’x Communication attracted to our Paris meetup in April). But if it’s about a centrally-imposed structure of “marketing towards the user base”, then I want to understand more and we need to discuss a bit further.

Based …

Daniel Nichter, the author of several very useful MySQL tools, has joined with Percona to continue to improve Maatkit -- the "other" toolkit we rely on daily. Daniel is a skilled Perl programmer who understands MySQL. He is in a perfect position to move the project forward on a more regular basis than I've been able to commit time to since I've taken on a leadership role in Percona.

Right now he's working on an unreleased tool we will use to make our performance audits more efficient. As a result, we'll be able to deliver more value to our customers and assess servers more quickly in the event of an emergency. (By the way, if you'd like to sponsor features you need for a Maatkit tool, contact us and we'll be glad to discuss it with you.)

Welcome, Daniel! And a …

I was doing some multi-threaded, multi-transactional testing for the backend of the MySQL Enterprise Monitor. I came across a weird failure, where it appeared I was able to successfully insert a row, and then (in the same transaction), a select from the same table did not return any rows.

Consider the following transactions:


mysql> create table t1 (id integer primary key auto_increment, name varchar(32) unique) engine=innodb;

a> begin;

b> begin;
b> select * from t1;

a> insert into t1 values(null, 'oldag');

b> insert into t1 values(null, 'oldag) on duplicate key update id=LAST_INSERT_ID(id);
(b blocks)

a> commit;

(b is released)
...
Query OK, 0 rows affected (0.00 sec)
b> select * from t1;
Empty set (0.00 sec)


what, what, …

This TOTD (Tip Of The Day) shows how to create a Persistence Unit (PU) for a MySQL database using NetBeans IDE. This PU can then be used in any of Java EE artifacts (JSP, Servlet, EJB, ...) for database interaction.

1. In NetBeans IDE, create a new project
   1. Create a new NetBeans Web project and enter the values ("Autocomplete") as shown:
      
      
      
      and click on "Next".
   2. Choose GlassFish v2 as the deployment server and then click on "Finish".
2. Set up the database
   1. Start the database as:
      
      

      ~ >sudo mysqld_safe --user root Password:<YOUR …

Brian Aker was at the Sun booth today, in a premier slot, where there must have been about 50-60 people, huddled around, to listen to him talk about Drizzle. The project motivations, what’s behind it, what its not aimed to be, and so much more. Check the video out (21 minutes long)!

The Birds of a Feather (BoF) session in the night, was well attended, and there was lots of large discussion on what’s next. I think the important message to take away is that Drizzle doesn’t aim to be MySQL, and there are no plans to “merge” things back (fixes where the code-base is shared though, might make sense). Its also important that the design is for the future, i.e. multi-core machines. It was great to see Brian say that this …

Some likely and unlikely candidates snap up SourceForge Community Choice Awards READ MORE