Drizzle: Rethinking the MySQL Database Kernel

Drizzle is a re-thought and re-worked version of the MySQL kernel designed specifically for high-performance, high-concurrency environments. In this exclusive article, MySQL guru Jeremy Zawodny takes an inside look at the goals and state of Drizzle development.

What’s New?

The old MySQL protocol and the client libraries have been re-thought and re-implemented.  The protocol work itself is now part of the libdrizzle sub-project that’s used by both the server and client utilities, as well as any other projects that wish to talk to Drizzle servers.  Aside from simply being more efficient, the protocol allows for checksums on data, has built-in sharding support, and support for connecting via TCP, UDP, and Unix Domain Sockets.  When used over TCP or UDS, the protocol is “full-duplex”, which means that the  client and server can preempt otherwise long operations to cancel them or provide additional information (errors, warnings, and the like).

To ease migration, libdrizzle completely supports the MySQL protocol as well, so you can build applications using libdrizzle that talk to either Drizzle or MySQL servers. If you ever move from MySQL to Drizzle, this feature will be invaluable. If you’d like to know more, have a look at the Drizzle protocol draft.

The on-disk format for table definitions (.frm files) has been replaced with a representation based on Google Protocol Buffers. This removes a lot of custom code from the server and makes it easier for other tools to understand table definitions as well.

While not an end-user feature, the development model around Drizzle is new, too. It’s completely open (unlike MySQL) and is very easy to get involved with. Testing is a big focus for the Drizzle team. When the team compiles Drizzle, every compiler warning is treated as an error, and each new build is checked against previous builds for any performance regressions.  When a regression occurs, no new code is committed to the trunk until the source of the regression has been identified and fixed. A recent example involved the tcmalloc library.

Brian Aker discusses some of the testing philosophy in Drizzle, State of Testing.

Getting Involved

As noted earlier, Drizzle has a very open and approachable development model. The first thing you’ll probably want to do is check out and build a copy of the source code. That means building and installing both libdrizzle and Drizzle itself.

You’ll need a few prerequisites, many of which are probably already on your system, but the configure script will notify you of any omissions.  The most problematic tends to be Google Protocol Buffers. You may need to build and install the package from source if the package repository for your distribution doesn’t have an up-to-date version available.

Once you have the prerequisities, the builds are simple enough.

$ bzr branch lp:libdrizzle
$ cd libdrizzle
$ ./config/autorun.sh
$ ./configure
$ make
$ make test
$ sudo make install

$ bzr branch lp:drizzle
$ cd drizzle
$ ./config/autorun.sh
$ ./configure
$ make
$ make test

The commands yield an installed copy of libdrizzle and a locally-built Drizzle server that you can start (without installing) by simply running drizzled/drizzled --datadir=/tmp.

And then you’re off and running. You can connect to the Drizzle server and use it in much the same way you use MySQL today.

To get move involved, here are some links to visit:

Keep in mind that the Drizzle team does not believe that Drizzle is ready for prime-time yet. However, that hasn’t stopped some people from using it on a daily basis.

Nonetheless, the project is still evolving at a rapid pace, so if you do plan to use Drizzle soon, it’s best to stay informed about what’s going on in the project. And, by all means, report any bugs you find!

Comments on "Drizzle: Rethinking the MySQL Database Kernel"

Hello i am kavin, its my irst time to commenting anyplace, when i read this post i thought i
couuld also make comment due to this sensible paragraph.

Visit mmy homepage … cheap car insurance in ohio

I’m not sure why bbut this web site is loading
very sloww forr me. Is anyonje else having this problem
or iss it a problem on my end? I’ll check back later andd see if the problem still exists.

Also visit my blog post: cheap car insurance

continukusly i used to read smaller articles which also clear their motive, and that
is also happening witrh this article which I am reading here.

Feel free to visit my web page – cheap full coverage car insurance

I simply want to tell you that I am just beginner to blogging and site-building and absolutely loved this website. Probably I’m going to bookmark your website . You absolutely come with impressive stories. Appreciate it for sharing with us your website page.

It’s actually a nnice and helpful piece of information. I
am glad that you just shared this heelpful info with us.
Please stay uss informed like this. Thank you for sharing.

my weblog … cheap car insurance in florida

For most recent news youu have to go to see the web and on world-wide-web
I found this web page as a best website for most up-to-date updates.

Here is my site – cheap car insurance

I just want to say I am all new to weblog and definitely enjoyed your web blog. Almost certainly I’m want to bookmark your blog . You actually come with good stories. Kudos for revealing your website page.

Hi my family member! I wksh to sayy tyat this
post is amazing, great written and come with approximately all important infos.
I’d like to look more posts like this .

my page: cheap car insurance online

Way cool! Some very valid points! I appreciate yoou penning this post plus the rest of the website is also very good.

Visit myy weblog cheap car insurance texas

Asking questions are genuinely nice thing if you arre
not understanding something completely, however this post offers good understanding even.

Also visit my webgpage – cheap car insurance

Hmm it seems like your website ate my first commenjt (it was extremely long)soI guess I’ll just sum it up what I submitted and say, I’m thooroughly enjoying your blog.
I as well am an aspiring blog blogger bbut I’m still new to everything.
Do you have anyy points for rookie blog writers? I’d definitely appreciate it.

Here is my web page … Cheap car insurance

Oh my goodness! Amazing article dude! Many thanks, However I am going through divficulties wuth your
RSS. I don’t understand the reason why I am unable
to subscribe to it. Is there anybody getting similar RSS issues?
Anyone who knows the answer can you kindly respond?

Feel free to surf to my web page … very cheap car insurance

Appreciate this post. Let me try it out.

My web page :: Car insurance companies

I’m curious to find out what blog system you are utilizing?
I’m having some small security problems with my latest blog and I would like to find something more safeguarded.
Do youu have any solutions?

Also visit my blog post: cheap car insurance in nj

Here are some hyperlinks to web pages that we link to due to the fact we feel they are worth visiting.

Excellent blog right here! Additionally your site lots
up very fast! What host are you the usage of? Can I get your
associate hyperlink in your host? I want my
website loaded up as quickly as yours lol

Here is my web site; Cheap car insurance

I couldn’t resist commenting. Exceptionally well written!

Feel free to surf to my webpage – Cheap Car Insurance

You could definitely see your expertise in the article you write.
The arena hopes for even more passionate writers like you
who aren’t afraid to say how they believe.
At all times follow your heart.

Review my blog: cheap car insurance in md

I just want to mention I’m all new to blogs and definitely loved your web-site. More than likely I’m going to bookmark your blog . You actually come with fabulous posts. With thanks for revealing your web-site.

Muchos Gracias for your post. Really Cool.

Usually posts some really interesting stuff like this. If you?re new to this site.

Awesome blog article.Much thanks again. Really Great.

With the relation to Black Mamba, Nike Zoom Kobe VI is
more populated. Diesel sneakers have a rubber sole for superb traction, wherever you go.

They coordinate their work with the fashion merchandisers and
store managers who are assigned in different store outlets and locations by overseeing the visual merchandising initiatives
of each unit.

Feel free to visit my webpage … cheap giuseppe zanotti shoes

I love it when folks get together and share views.
Great blog, keep it up!

Look into my weblog canadian pharmacy

If you’re still on the fence: grab your favorite earphones, head down to a Best Buy and ask to plug them into a Zune then an iPod and see which one sounds better to you, and which interface makes you smile more. Then you’ll know which is right for you.

Apple now has Rhapsody as an app, which is a great start, but it is currently hampered by the inability to store locally on your iPod, and has a dismal 64kbps bit rate. If this changes, then it will somewhat negate this advantage for the Zune, but the 10 songs per month will still be a big plus in Zune Pass’ favor.

Light-ray frames are lighter yet stronger and hypoallergenic as
well. Straps are quite stylish nowadays and young fashionistas are getting
all creative with their spectacles using these straps, so not
only will you be able to safeguard your glasses
better, however you also get to improve their charm too.

Crystal clear frames with bright lenses are coming out from multiple designers as well.

Feel free to visit my blog post – http://www.hfpacoustical.us/hfp/

I am in fact pleased to read this web site posts which includes lots of helpful information, thanks for providing these data.

Feel free to visit my website; cialis from online pharmacy

Marinate it or season it with salt, pepper and lemon juice.
Teach the sentence words for preparing materials to cook.

Two slices of pimento filled olives make great snake eyes and a sliver of red pimento for a tongue.

Its really great how you explain issues in a few sentences but portray a great message. I really love what MySQL guru Jeremy Zawodny is doing for drizzle. Great article.

I simply want to mention I am newbie to blogs and truly savored you’re web page. Likely I’m planning to bookmark your site . You amazingly have fabulous posts. Kudos for sharing with us your webpage.

Wow, incredible blog layout! How long have you been blogging for?
you made blogging look easy. Thee overall look of your web site
is fantastic, llet alone the content!

Here is my homepage: dyson dc25

Article writing is also a fun, if you know afterward you can write if not it is complex to write.

my weblog: dyson fan

Asking questions are actually pleasant thing if you are not understanding something completely, except this
paragraph provides nice understanding yet.

We can play with the color of the blouse and adapt it to the style and workplace of each person. com,a number of us are manufacturer, wholesale and
exporter regarding rattan furniture everywhere over the Indonesia.
Most women and major celebrities prefer branded leather Chanel handbags simply because it is their style icon.

My weblog … cheap prada bags

?ev?rtheless, when dealing wwith this kind of agency, modest and ?uge business will
be the concentration. After reaching my ?ccountant and relaying my concerns, the next attribut? wortgh addressingg
is ?ommunicat?on. T?e skills you acquire iin you? training to
become a CPA will give you confidence in yourself and yokur newfound abilities.

my homepage :: boca raton Florida cpa

The inclusion of important aspects such as athletic shorts for
men or other proper clothing outside of safety equipment should
also be considered depending on the sport or activity played.
Lady Gaga was photographed stepping out for errands in New York City on Sunday (March 23, 2014).
Whether it’s sandals, trainers or high heels, we
usually go out with something on our feet in the morning.

Here is my weblog – outlet christian louboutin

Although websites we backlink to below are considerably not associated to ours, we really feel they’re essentially worth a go by means of, so have a look.

Here are some hyperlinks to web sites that we link to since we consider they may be really worth visiting.

Leave a Reply