A customer rose a support case with a problem on his Master-Master set-up. The 2nd Master claims to have a problem:

master2> SHOW SLAVE STATUS\G
                ...
    Master_Log_File: master1-bin.000014
Read_Master_Log_Pos: 97975045
   Slave_IO_Running: No
  Slave_SQL_Running: Yes
Exec_Master_Log_Pos: 97975045
      Last_IO_Errno: 1236
      Last_IO_Error: Got fatal error 1236 from master when reading data from binary log:
                     'Client requested master to start replication from impossible position'

What has happened?

When we look at the actual Masters binary logs we see the following situation:

master1> SHOW BINARY LOGS;
+--------------------+-----------+
| Log_name           | File_size |
+--------------------+-----------+
| master1-bin.000013 |  68757710 |
| master1-bin.000014 |  97973131 |
| master1-bin.000015 |    626440 |
+--------------------+-----------+

That looks really odd: The Slave …

The MyCleaner program, that is used to clean up data in the MySQL database that is no longer used, no longer referenced or is just unnecessary, is now available for download from SourceForge.net in version 1.1. This new version adds a few things, like the ability to sleep between rounds, more extensive log print control, and above all, the ability to run a non-SELECT to get IDs.
The latter feature may seem weird, but in some cases it is useful, as it will allow you to select IDs into a temporary table, for example, and then use these for deleting the real data, something which can be achieved in many other ways of course, but which is still useful in some cases.

In addition, the ability to run SQL after the program having finished all other processing, has been added, to allow cleanup of temporary objects.

/Karlsson

Today, more and more proprietary software vendors are choosing to go Open Source. Doing this enables them to leverage the community benefits of Open Source, shorten the sales cycle, and gain a competitive advantage over other proprietary products.

However, for those firms considering a switch to Open Source, there are some hard decisions to make with regard to their product architecture. Should they provide only a single Open Source product, and earn revenue from add-on services like support and consulting (RedHat)? Or should they adopt the Open Core model, offering their product under both Open Source and proprietary licenses (MySQL)? Or …

From August 15th to 17th FromDual will have an Advanced MySQL Developer Workshop with Citrus in Helsinki (Finland). The workshop will be held in English. The workshop topics you can find here and the registration form is available here.

Databases are the heart of applications. It is a disaster when a problem takes down the database, as your applications can no longer function. Continuent's Tungsten Enterprise gives you advanced technology to make open source databases like MySQL and PostgreSQL fault tolerant against a wide range of common failures.In this webinar we cover the basic principles of database fault tolerance and

If you missed the general public call for papers, you have another opportunity to get included in this year's event!  Submit a paper through Oracle Mix.

Do you believe your MySQL topic would grab the OpenWorld audience? We invite you to submit it for review and voting by your peers. Sessions with the highest number of votes within tracks will be included in this year's event and speakers will get a free pass to Oracle OpenWorld 2011. The paper submission and voting on Oracle Mix goes through June 19, 2011. Get your submissions in early to maximize your voting potential!

Get more information and suggest a session here.

Recently, we celebrated SkySQL reaching its first, “half birthday” since its official launch on October 15th. It’s been an amazing half-year. While most “newborns” are still getting a feel for the lay of the land at 6 months, SkySQL is already off and running!

Keeping to the high level corporate strategy we set in place when we dreamed-up SkySQL last summer, we have worked hard to establish a presence in the MySQL™ database ecosystem and to drive awareness amongst customers/users. Our goal continues to be for SkySQL to become the first and obvious choice for affordable MySQL database solutions for the enterprise and cloud. In our first six months, we:

• Grew the company to nearly 40 employees, working out of 14 countries, ensuring that we’re able to deliver our expert MySQL database services and support wherever our customers are located;

• Extended our global reach …

1. OMG Text -- a plugin for CSS framework Compass for directional text shadows. (via David Kaneda)
2. Build a Cheap Bitcoin Mine -- some day it will be revealed that the act of generating a bitcoin token is helping the Russian mafia to crack nuclear missile launch codes and Afghan druglords built the Bitcoin system to destabilize the US dollar.
3. Polycode -- a free, open-source, cross-platform framework for creative code. You can use it as a C++ API or as a standalone scripting language to get easy and simple access to accelerated 2D and 3D graphics, hardware shaders, sound and network …

I bring this up because of recent conversations I have found myself in.

Over the years I have gone back and forth between OSX & Linux laptops. Over these same years I was also monitoring several MySQL databases. I have found numerous server side solutions for you to be able to monitor your database, Nagios and of course MySQL Enterprise Monitor to list a couple. Both of these are great solutions and allow you to try and get some sleep and night.
Years ago, while using OS X, I was enlightened to learn about a free module called Geektool, it is not new, but I often find people are unaware of it.  I have had at least three conversations about it lately. While Nagios and …

Oracle Open World has a MySQL track this year and you can submit session proposal and vote on proposed sessions until June 19th!1 Please vote to help determine what you will see at OOW.

Before the regular OOW sessions, on Sunday October 2nd, MySQL will have two simultaneous tracks for Community Sunday. Session speakers are also needed and we do have two rooms to fill. So dust off that presentation idea you have been working on and get it polished. If you would like to present at on Sunday, please let me know and I will pass on the information to the MySQL Community Sunday Organizers.

And we will have a MySQL booth in the USer Group Area for you to drop[ in and talk about MySQL. And we need …