Wednesday 29 September 2010

Drizzle7 Beta Released! (now with MySQL migration!)

Today is a big day for us working on the Drizzle project.  Our first official Beta! We have come a long way since the original MySQL 6.0 fork and we couldn't have done it without the many community contributors involved, so many thanks to everyone who has helped us to get here (you know who you are).

One feature I have been working on recently is a MySQL migration tool.  This is basically a large modification to drizzledump which can do two extra things:

Firstly, it will automatically detect whether it is connecting to a MySQL or Drizzle server.  When connecting to a MySQL server it will automatically convert the table structures and data to create a Drizzle compatible dump file.

On top of this there are new options so that drizzledump can connect straight to a Drizzle server at the same time as a MySQL server and pipe the data over, converting on-the-fly, without any intermediate dump file!

To help read up about how to use this, another new feature is the integration of Sphinx Documentation Generator.  We are still in the process of writing documentation but we already have information on how to use the drizzledump migration options available.

The Drizzle server can already talk the MySQL protocol, so in many cases there will be little to no application modifications needed to switch from MySQL to Drizzle, you can even still use libmysqlclient!

Please test this and let us know what you think, we are always open to feedback.

7 comments:

  1. The migration on-the-fly is a great idea! Thanks :)

    ReplyDelete
  2. Excellent Job.

    Thank you for
    1. doing a big overhauling of drizzledump.
    2. drizzledump documentation is beautiful.
    New documentation system is very powerful. right selection of sphinx.

    ReplyDelete
  3. No problem, I'm hoping I've also pulled out some of stuff that was making your Windows build hard.

    ReplyDelete
  4. [...] is that it can make migration from MySQL to Drizzle more difficult.  I have previous noted that drizzledump can so the schema migration for you.  Now I will go into more details with some other information that may be useful if you are [...]

    ReplyDelete
  5. [...] is that it can make migration from MySQL to Drizzle more difficult.  I have previous noted that drizzledump can so the schema migration for you.  Now I will go into more details with some other information that may be useful if you are [...]

    ReplyDelete

Note: only a member of this blog may post a comment.