I came across a situation recently where I was asked if it was possible to edit a binary log to remove a part of it to restore onto a slave server. Now the choice of doing something like a hexedit did not seem appealing, and the more experienced might suggest that it is simply a matter of using  mysqlbinlog with the --start-position and/or --stop-position options. However, the problem had arisen that required the binary log to played through the replication process onto the slave based on specific options in MySQL cluster, so using an SQL dump from the binary log was of no use.

Initially this may seem like a daunting task where you will have to find some specialist tool or delve into the deep recesses of the binary log format, but a much simpler solution was found. The replication process allows the slave to be started up to a specific point in the log files. The command is the START SLAVE UNTIL... statement as seen in the manual at: …

I came across a situation recently where I was asked if it was possible to edit a binary log to remove a part of it to restore onto a slave server. Now the choice of doing something like a hexedit did not seem appealing, and the more experienced might suggest that it is simply a matter of using  mysqlbinlog with the --start-position and/or --stop-position options. However, the problem had arisen that required the binary log to played through the replication process onto the slave based on specific options in MySQL cluster, so using an SQL dump from the binary log was of no use.

Initially this may seem like a daunting task where you will have to find some specialist tool or delve into the deep recesses of the binary log format, but a much simpler solution was found. The replication process allows the slave to be started up to a specific point in the log files. The command is the START SLAVE UNTIL... statement as seen in the manual at: …

With all the changes between MySQL and Meetup Corporation, our Los Angeles MySQL Meetup has been in flux. But I’m happy to note that Navicat was kind enough to sponsor us for now & if that ever falls through, OpenQuery … Continue reading →

We're sponsoring an important webinar series along with Sun/MySQL starting this week on June 25th - The Kimball Group Data Warehousing Educational Webinar Series.  This webinar series will introduce the audience to data warehousing concepts and best practices, and will cover the history and evolution of data warehousing, provide an overview of dimensional modeling, and review the full life cycle of designing and implementing a data warehouse.  Part 1, on June 25th at 1:00P PDT, is on Data Warehousing Fundamentals.

There are two key reasons why we think this webinar series is important:

• First, we believe this webinar further advances data warehousing in the MySQL world. There is a whole new generation of database developers in the MySQL community that are at various stages of understanding data warehousing - what it …

Just the fact that a system can scale to a large number of nodes does not mean it is worth using.
Imagine a fictitious data system that scaled to 1 million nodes but could only process 100 bytes per second on each node.
This would be the worlds biggest energy wasting phenomenon, due to the electricity and cooling requirements for such a cluster. [arguably you could think of something else that wastes more energy than this :) ]
When supporters of a system start talking about how many nodes their system can scale to, don't forget to ask for an analysis of the efficiency of each of these nodes.
More later .... Ivan

And it has failed the testuite on every single build slave. I’ve filed BUG#45605, BUG#45630 (together with a patch), BUG#45631, BUG#45632. There is also rpl.rpl_innodb_bug28430 test failure which I didn’t report as I don’t yet have enough details about the build slave.

At the moment our setup works as follows: there is lp:~maria-captains/maria/mysql-5.1-testing branch, which our copy of lp:mysql-server. We periodically pull from the main tree into …

The 10th FISL starts this week. Like previous years, it looks like a lot of fun: the Program is full of good content, and there is also Porto Alegre... FISL starts on the 24th and it is preceded by Javali, an event focused on Java, on the 23rd (Agenda).

I did a quick pass through the FISL program to highlight some sessions, including those related to GlassFish Projects and friends:

• Arun on …

Warning!. This is not much database related, except that I write this as I am developing my Database Query Tool MyQuery 2.4 right now.

While working with MyQuery 2.4, which should be ready for beta real soon now, I have gotten myself into an issue with Windows and Multithreading. Actually, this issue exists to some extent most message based systems I guess, assuming they also support multithreading.

If you have not developed with Win16/Win32 or some other message based GUI system, then let me fill you in on how Windows does this. This to a large extent dates back to when Windows wasn't truly multi-threading at all (such as Win 3.0, Win 3.11 etc.). Even in those old versions of Windows, you could switch from application to application, window to window anyway. And the application didn't seem to be blocked (I am ignoring any general performance issues with those old versions of Windows here).

How did …

Why not distract your attention from usual database development and facilitate your work with projects?

Let’s inspect the reasons why you should.

1. Database projects provide quick access to SQL scripts and database objects. You have logically organized scripts and query files in one place.
2. Database projects allow developing databases in offline mode within a fully customizable environment.
3. Database projects support Source Control usage, so database development can be shared between development team members.
4. Database projects can be built to different outputs (they are used to deploy all the project changes to a database on the server): a single ready-to-deploy script, a set of scripts with a batch to run it in the MySQL Command-Line Tool or in dbForge Studio, etc. You can adjust the output for your needs.
5. Database projects …

Introduction

StackOverflow is an amazing site for coding questions. It was created by Joel Spolsky of joelonsoftware.com, Jeff Atwood of codinghorror.com, and some other incredibly smart guys who truly care about user experience. I have been a total fan of SO since it went mainstream and it's now a borderline addiction (you can see my StackOverflow badge on the right sidebar).

The Story

Update 6/21/09: This server is currently under very heavy load (10-200), even with caching plugins enabled. Please bear with me as I try to resolve the situation.

Feel free to …