SQLyog 7.0 beta 1 is about to be released very soon (we are ‘polishing’ on details at the moment). This release includes completely new code for Data Synchronization that addresses user requests we have had since Data Synchronization was first introduced with SQLyog.

Probably we did not fully understand the needs of some users before. Users have told us

* It is not always desirable or possible to run the sync directly. Audit and access policies may prevent that. A SQL sync script is required in those situations.

* Also some users have wanted a detailed log for every (INSERT/UPDATE/DELETE) operation - for simple documentation or for comparing - in various ways - sync operations between different executions.

* Some users wanted sync scripts for ‘differential backup’ purposes or for auditing purposes.

* Even some users wanted not necessarily to actually perform any sync at all - they only wanted a …

Just a quick note to let folks know I'll be doing a presentation on Join-Fu: The Art of SQL, tonight in Cincinnati. Thanks to Elizabeth Naramore for inviting me down to OINK-PUG (Ohio-Indiana-Northern Kentucky PHP User Group)!

I'll be covering both Beginning Join-Fu and Intermediate Join-Fu tonight. Topics covered include:

• Schema optimization and vertical partitioning
• SQL Coding style guidelines
• Set-wise problem solving in SQL (and why it kicks for-loop-fu's ass.)
  • Rewriting correlated subqueries into joins
  • Using derived tables or subqueries in the FROM clause
  …

Now that MySQL has switched its development to Bazaar, we can play a bit with the new tools. One thing that I have tried immediately upon adoption of the new RCS is to create a test bench for multiple MySQL versions by combining Bazaar and MySQL Sandbox.

If you are into bleeding edge testing, you may like to know how to get a new MySQL server up and running in a sandbox from a source tree.
First move - make the repositoryThis is a zero time consuming move, and you will have to do this only once. But this move will save you heaps of time in future. By …

I wasn't really looking for a new job a few months ago when I received an email from Eric Scheide (see Team Bios), the CTO at craigslist. He mentioned that they were looking for someone with MySQL experience and asked if I knew anyone. This sort of thing happens all the time.

But this time it was different. Over the course of about three seconds, something clicked in my little brain and I realized that craigslist is a pretty unique combination of things: a small company with a solid financial base, a great service that I use myself, a focused groups of people who really care about doing things well, and an open-source friendly environment.

I replied that I might be interested myself and things kind of took on a …

During the last month, MySQL code has been migrated from BitKeeper to Bazaar. Bazaar is a distributed, free revision control system sponsored and supported by Canonical, the company behind the fast-growing Linux distribution Ubuntu.

We have migrated all MySQL code trees that were available in BitKeeper. This means not just current GA and development versions of MySQL Server and MySQL Cluster, but also the history all the way back to MySQL 3.23.22 released about eight years ago. And we’ve also migrated non-MySQL-server FOSS applications to Bazaar, such as MySQL Workbench (formerly not in BitKeeper but in Subversion, also known as svn) and our internal QA suites.

…

I have put up a new version of the Dimensioning Toolkit.
Now, there is a particular version for MySQL Cluster 6.2 and MySQL Cluster 6.3.

The reason for this split is that the libraries and include files are in different locations (include/ and lib/ in 6.2, but lib/mysql and include/mysql in 6.3).
I don't know why the build team changes this between versions (even builds) and so often... very annoying.

Anyways, follow the links to download:

Dimensioning Toolkit for MySQL Cluster 6.2
Dimensioning Toolkit for MySQL Cluster 6.3

This blog posting has little to do with MySQL or Sun. It’s about experiences gathered while shuttling around the world as MySQL’s Ambassador to Sun, but it’s not about databases, it’s not about operating systems, nor computer languages: it’s about human languages, and how going beyond English provides a business advantage.

Let me try to grab your attention by first sharing my perhaps somewhat controversial conclusion:

English as a language of communication is much overrated. In an international setting, English may be sufficient for conveying meaning, but it has severe deficiencies when it comes to establishing a social relationship, to showing respect, to building trust, and to having fun.

For many years, I have attempted at learning how to say “thank you” and “please don’t smoke” and “where is …

I got a few questions about how to configure the cluster for disk data.
The new version of the Dimensioning Toolkit does a better job calculating:

• UNDO LOG file size
• TABLESPACE size
• UNDO Buffer size

What I write about below is taken into account in the Dimensioning Toolkit. Moreover, the things below only applies to disk data tables (read about the generic stuff about them in the reference manual).

UNDO LOG and UNDO BUFFER
Disk data tables make use of an UNDO log and an UNDO buffer.
The size of the undo log and the undo buffer is specified when you create the logfile group.

I recommend setting:

• UNDO log size = 4 to 6 times the DataMemory, thus the same size as for the REDO log.
  
• UNDO buffer size= …

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

Sweden crashed out of EURO 2008 last night a Russia qualified for the knockout stages with a well-deserved 2-0 win. As home to MySQL Sweden might be expected to be one of the more progressive adopters of open source but while there is significant interest, details of deployment projects are relatively hard to find.

Key policies:
The Swedish Agency for Public Management?s 2003 …

Not sure if the post title actually reflects the contents. 

This post describes how you can obtain the traces that MySQL server leaves behind for you if you ask it to. Once you have the traces, you can use it for:

• Debugging - It can help you to find out which source file is the server crashing, for eg.
• Learn- learn more about which functions/methods are called for a particular query by the client

Okay, so lets start.

Traceable Server

To be able to obtain traces, your server needs to be compiled with "debug" enabled. If the version information shows you something like this:

Ver 5.1.24-rc-debug for pc-linux-gnu on i686 (Source distribution)

with 'debug' appended to the version name, then you have a traceable server, else you will have to recompile it by enabling debug support:

./configure …