It's my great pleasure to announce the release of mylvmbackup version 0.14.

This release includes a large number of improvements, code cleanups, and new functionality.

I would like to thank Ask Bjørn Hansen, Ben Bonnel, Norbert Tretkowski, Neil Wilson, Klaus Ethgen and Alexandre Anriot for their feedback and contributions to this release.

The release is available as a source tarball and generic RPM package. Packages for other distributions are available from the openSUSE Build Service.

Some notable highlights from the …

So lets see how this goes.

This week we start to discuss the Openark Toolkit. Ear Candy talks about how to estimate the size of MySQL's working set, and At the Movies is a backup presentation from Open Database Camp.

Openark Kit series:
Part 2
Part 3

Openark Kit
Openark Kit

Episode 80, discussing the Percona Toolkit

read more

Such as SQL I guess. And nerdiness and vi and emacs. Not to mention new potatoes!
Yes, Swedish new potatoes. To be honest, this was the first batch this year, but this was the first proper batch for me, with Dill and some salt and eaten with some butter and an extra pinch of salt. Yummy, better than candy! And yes, this was yesterday, on midsummer eve!

And not only are the potatoes a tradition, my blog about them is one too I guess, and for you newcomers, this started out in MySQL days with a mailing to life@mysql.com and when I left MySQL in 2010, I have continued this as a blog.

And as a final word, this years new potatoes were just as good as ever. My twins are real cute and love them dearly, but they do take a lot of time and energy from me and the wife (in particular the wife), but …

There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a good simple one. Usually, setting up MySQL SSL is not really a smooth process due to such factors like “it’s not your day”, something is broken apparently or the documentation lies I am going to provide the brief instructions on how to setup MySQL with SSL, SSL replication and how to establish secure connections from the console and scripts showing the working examples.

Quick links:

• Setup SSL on MySQL
• Establish secure connection from console
• Setup SSL replication
• Establish …

Over the years JavaScript has become an integral part in every web developers life. The Dojo Toolkit is one of many JavaScript frameworks offering language goodies and interface voodo. It may not be the most used framework but it is a certain beauty to it – once you get used to it. The steep learning curve may be a bit in its way to success. However, to demo how to connect from browser-side JavaScript to MySQL it is about perfect as all its bells and whistles show what can be done, given enough time…

Feel free to skip all the recap sections, if you are familiar with the very basics of AJAX/JSONP.

Recap: JavaScript in a LAMP application

If your web site is driven by MySQL, a mix of a script language (PHP, Python, Perl, Ruby, …) and you plan to have quite some …

Async and PXC

A common question I get about Percona XtraDB Cluster is if you can mix it with asynchronous replication, and the answer is yes!  You can pick any node in your cluster and it can either be either a slave or a master just like any other regular MySQL standalone server (Just be sure to use log-slave-updates in both cases on the node in question!).  Consider this architecture:

However, there are some caveats to be aware of.  If you slave from a cluster node, there is no built in mechanism to fail that slave over automatically to another master node in your cluster.  You cannot assume that the binary log positions are the same on all nodes in your cluster (even if they start binary logging at the same time), so you can’t issue a CHANGE MASTER without knowing the proper binary log position to start at.

…

Close your eyes and imagine an affordable holiday featuring islands, pools, simmering white sandy beaches, and clubs. Chances are that you’re thinking about a resort in Hawaii, Fiji or French Polynesia. Now picture such a trip right now. I’ll give you a second. Still wondering? Yep, it’s this edition of Log buffer. :)

Oracle:

Bobby has hacked a script together Tuesday night to figure out how to fit all his production data files and temp files on a development server for a RMAN restore of a production backup onto a new server.

SQL Gone Bad – But Plan Not Changed? Kerry has more.

During …

Did you know that dbForge Studio for MySQL is a great alternative to MySQL Workbench? In case you have used MySQL Workbench in the past, or consider using it now, you might want to take a closer look at dbForge Studio for MySQL, to make sure you pick wisely the tool that will meet your [...]

Not really a “blip,” it’s like saying the documentation to a product you once relied upon is now no longer freely available. Taken to the extreme, it’s as if someone just raised the price on a product you like. All that said, they did fix it and the damage control was swift, so the harm here is pretty minimal.