Earlier today I asked on this blog and everywhere else people to fill in a simple survey of how do they use MySQL, which one and what should I focus on. I already have more than 30 answers (don’t stop answering, keep providing more) so I will have to publish the results and do something with them. But first I’ll let the survey run for at least a week Oh, and even though I write MySQL, this post is general about all MySQL variants (MariaDB, MySQL Cluster, … (not counting Drizzle)).
Now what is behind this survey? Well, I have a lot of stuff to do and MySQL is not my only responsibility. And I know that sometimes it can use some extra hands. Sometimes I get lucky and we have new beta packaged same day as it …

Another of GSoC ideas that I volunteered to mentor for our GSoC was adding support for BitBake to the openSUSE Build Service. In this post I want to talk about why do I think that BitBake support for openSUSE Build Service will be useful and why do I think that OpenEmbedded is actually pretty cool.

What is BitBake? Why is OpenEmbedded cool?

BitBake is a build system used mainly by OpenEmbedded. In a way it is kind of similar to what openSUSE does for us. It takes one sources and makes it possible to build them for many distributions. There are some differences though. Let’s start with few notes a out OpenEmbedded. BitBake description will make more sense once you’ll know what OpenEmbedded …

Usually I inform you here about MySQL related news in openSUSE. This time it will be a little bit different. But it will be still database related. You probably know that not so long ago (maybe still valid today), NoSQL databases were the cool thing to try. I think it has settled a bit now and it is no more about being cool, but more about your actual needs. So you may actually need some of these. And I can happily inform you, that thanks to the efforts of gladiac, we’ve got some of these in server:database repository now! Namely we’ve got MongoDB there and also Redis. Hurray! They don’t build for all distributions, but if you’ve got recent openSUSE, you can find a package for you there
Although some of us might like the idea of playing around with new …

MySQL 5.5 is GA for more then a month already. If you are reading some news, you probably already heard, that it is great, million times faster, has trillion new features that you desperately need and much more. Of course, I’m exaggerating a little bit. But anyway, MySQL 5.5 is new version everybody talks about. So now when do you get it? It is already lying around for some time in server:database:UNSTABLE repository. It was there since beta, but took me some time to get final version ready. Just add it to your repositories for example by:

zypper ar -f http://download.opensuse.org/repositories/server:/database:/UNSTABLE/openSUSE_11.3 server-database-unstable

and then install it by

zypper in mysql-community-server_55

As it conflicts with whatever MySQL variant you currently have, it will ask you to confirm uninstallation of your currently installed MySQL. Then it will replace it and you can start trying it. …

You maybe already noticed, that MariaDB folks released their new stable version 5.2.3 today. And as we’ve got our great openSUSE Build Service, we already have this version packaged and you can install it easilly on openSUSE. I didn’t had much time to test it deeply, I just tried that it runs, and that I’m able to connect to it, so it is currently in server:database:UNSTABLE repository, but after some testing, it will proceed futher If you want to try it, make sure to backup your data first! So talks on openSUSE you can use one click install to get MariaDB 5.2.3. For others, you …

It’s been some time already since I informed you about server: database: UNSTABLE repository in openSUSE Build Service. Today I want to mention what is going on there. As the name of the repository suggests, it’s probably not the best idea to use anything from here on your production servers

MySQL 5.4

I’m keeping there MySQL 5.4. Currently in version 5.4.3 beta. 5.4 branch of MySQL contains some patches to improve performance. That is the reason why it might be interesting. Downside is that it isn’t released as often as 5.1 and it is not considered production ready. I already wrote …

You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

(note: give the mirrors some hours to sync up)

Quick overview

• See the Release Notes for relevant bugfixes.
• Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview). …

MySQL 5.0.87-d10 OurDelta builds are now available (32 and 64-bit):

• Debian: Etch (4), Lenny (5)
• Ubuntu: Hardy (8.04), Intrepid (8.10), Jaunty (9.04), Karmic (9.10)
• RHEL/CentOS: 4, 5
• Binary tarballs: generic Linux, built on Ubuntu Hardy

Apart from the 5.0.87 upstream fixes there were a few minor fixes in the build environment, and one updated Percona patch. The -sail builds now include the OQGRAPH engine. Source packages are with the respective distro repos, and there are …