In this BLOG post I will concentrate on the achievements with data synchronization with SQLyog 7.0 (beta 1 released just before the weekend).

SQLyog 7 provides 2-8 times speed improvement (depending on data) with a ‘mixed-type’ of syc-job (involving both INSERTS, UPDATES and DELETES) as compared to SQLyog 6. A few comparison examples (SQLyog 6, SQLyog 7 and Maatkit) with 4 testcases:

a)
Source Rows: 3950400, Target Rows: 3950400, Inserted Rows: 49599, Updated Rows: 49500, Deleted Rows:49599. Primary Col(INT). InnoDB
SQLyog 6: 1120 sec
SQLyog 7: 267 sec
Maatkit : 530 sec

b)
Source Rows: 48025 , Target Rows: 48775, Inserted Rows: 1225 , Updated Rows:1225, Deleted Rows : 1975. Primary Col(INT), InnoDB.
SQLyog 6: 30 sec
SQLyog 7 : 8 sec
Maatkit : 19 sec

c)
Source Rows:150404 , Target Rows: 152864, Inserted Rows: 12136, Updated Rows: 16236, …

UPDATE - 2008-06-23 - A member of O’Reilly’s editing team commented that this privilege has *NOT* been discontinued, and all O’Reilly authors should receive a free Safari account. Thanks a bunch, Mary, for the clarification (see comments for more).

I learned from one of the authors of the recently released second (read: first, squared) edition of High Performance MySQL that O’Reilly apparently did away with the idea of giving O’Reilly book authors free Safari accounts. Lame.

I do not know why in the world they would discontinue this offering for authors. Perhaps they’re not aware, but a great many of the O’Reilly authors are also bloggers. Tech bloggers. Some of them write on the O’Reilly blogs themselves, but …

Neocleus obtains new round of funding. Novell releases OpenSUSE 11. Red Hat acquires open source identity code from Identyx. (and more)

Neocleus Raises Over $11M in Series B Financing, Neocleus (Press Release)
openSUSE Project Announces Availability of openSUSE 11.0, Novell (Press Release)

Red Hat Delivers on Linux Automation with Identity Management and Open Source Systems Management Solutions, Red Hat (Press Release)

Sun Microsystems Releases New Version of Open Source …

With the bulk of my classes over, I finally have time to read some hand-picked books (rather than those 1000 page dry volumes required for courses). This is perfect timing since the new “High Performance MySQL” book was just released. I got a little carried away with my order, but felt I should catch up on some books I’ve been eyeing for some time. Anyone else care to share their summer reading list?

By June 30th, I should have:

• High Performance MySQL: Optimization, Backups, Replication, and More
• The Art of Multiprocessor Programming
• The Definitive ANTLR Reference: Building Domain-Specific Languages
• Programming Erlang: Software for a Concurrent World
• The Joy of Vegan Baking: The Compassionate Cooks’ Traditional Treats and Sinful Sweets

(The last book is for both Wendy and me, it should help provide tasty treats while reading the others)

I …

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing - I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago - but isn't a brand new disk a good time to change your OS version? 

 On the upside, Hardy was the first OS I've installed where I opted to keep the default wallpaper (the bird is purty). And I'm pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 

But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That's a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).

Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun & MySQL). My sunray solves …

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing – I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago – but isn’t a brand new disk a good time to change your OS version? 

 On the upside, Hardy was the first OS I’ve installed where I opted to keep the default wallpaper (the bird is purty). And I’m pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 

But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That’s a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).

Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun & MySQL). My sunray solves half of that problem for me, but until …

All right! In the past, some books seem to be delayed in getting into O’Reilly’s Safari site, but on the day that Baron announces the book’s arrival, I find that I’m able to access it in Safari right now! Sweet!

Welcome to the 102nd edition of Log Buffer, the weekly review of database blogs.

Since it was DB2’s 25th birthday this week, as Anant Jhingran reports, let’s start with it.

From ZDNet this week came a story that IBM was considering the open-sourcing of DB2 — big news, naturally, whether true or not. Matthew Aslett of 451 CAOS Theory says, Open source DB2? I don’t think so, suggesting that it was merely theorizing on the part of one IBM …

The book, that is. My dog is already studying it. You should buy a few copies for yourself, your family, and all your pets.

No Tags

I've been at MySQL for two and a half years now as a community manager. Through this time, I've learned a number of valuable lessons about what it means to be a community manager, what it means to belong to a community of technologists, and what it means to be an open source advocate. I think back now on the attitude and preconceptions I brought with me when I joined MySQL, and reflect about the changes in my own attitude that have happened.

One of the biggest "aha" moments I have had in the past three years is the following:

It is the role of a community manager to remove the barriers — both technical and ideological — between the user/developer community and the company or group of individuals which produces the open source software

Some barriers are small. Sometimes these barriers can be overcome by a simple email to an annoyed community member who has misunderstood a poorly communicated …