Jan 25

MySQL, MariaDB & openSUSE 12.3

MariaDB logoopenSUSE 12.3 is getting closer and closer and probably one of the last changes I pushed for MySQL was switching the default MySQL implementation. So in openSUSE 12.3 we will have MariaDB as a default.

If you are following what is going on in openSUSE in regards to MySQL, you probably already know, that we started shipping MariaDB together with openSUSE starting with version 11.3 back in 2010. It is now almost three years since we started providing it. There were some little issues on the way to resolve all conflicts and to make everything work nicely together. But I believe we polished everything and smoothed all rough edges. And now everything is working nice and fine, so it’s time to change something, isn’t it? :-D So let’s take a look of the change I made…

MariaDB as default, what does it mean?

First of all, for those who don’t know, MariaDB is MySQL fork – drop-in replacement for MySQL. Still same API, still same protocol, even same utilities. And mostly the same datafiles. So unless you have some deep optimizations depending on your current version, you should see no difference. And what will switch mean?

Actually, switching default doesn’t mean much in openSUSE. Do you remember the time when we set KDE as a default? And we still provide great Gnome experience with Gnome Shell. In openSUSE we believe in freedom of choice so even now, you can install either MySQL or MariaDB quite simply. And if you are interested, you can try testing beta versions of both – we have MySQL 5.6 and MariaDB 10.0 in server:database repo. So where is the change of default?

Actually, the only thing that changed is that everything now links against MariaDB and uses MariaDB libraries – no change from users point of view. And if you will try to update from system that used to have just one package called ‘mysql’, you’ll end up with MariaDB. And it will be default in LAMP pattern. But generally, you can still easily replace MariaDB with MySQL, if you like Oracle ;-) Yes, it is hard to make a splash with a default change if you are supporting both sides well…

What happens to MySQL?

Oracles MySQL will not go away! I’ll keep packaging their version and it will be available in the openSUSE. It’s just not going to be a default, but nothing prevents you from installing it. And if you had it in past and you are going to do just a plain upgrade, you’ll stick to it – we are not going to tell you what to use if you know what you want.

Why?

As mentioned before, being default doesn’t have many consequences. So why the switch? Wouldn’t it break stuff? Is that MariDB safe enough? Well, I’m personally using MariaDB since 2010 with few switches to MySQL and back, so it is better tested from my point of view. I originally switched for the kicks of living on the edge, but in the end I found MariaDB boringly stable (even though I run their latest alpha). I never had any serious issue with it. It also has some interesting goodies that it can offer to it’s user over MySQL. Even Wikipedia decided to switch. And our friends at Fedora are considering it too, but AFAIK they don’t have MariaDB yet in their distribution….

Don’t take it as a complain about MySQL guys and girls at Oracle, I know that they are doing a great job that even MariaDB is based on as they do periodical merges to get newest MySQL and they “just” add some more tweaks, engines and stuff.

So, as I like MariaDB and I think it’s time to move, I, as a maintainer of both, proposed to change the default. There were no strong objections, so we are doing it!

Overview

So overall, yes, we are changing default MySQL provider, but you probably wouldn’t even notice

Permanent link to this article: http://michal.hrusecky.net/2013/01/mysql-mariadb-and-opensuse-12-3/

Nov 19

GPG Key Signing Party

Last Thursday we had GPG Key & CAcert Signing party at SUSE office inviting anybody who wants to get his key signed. I would say, that it went quite well, we had about 20 people showing up, we had some fun, and we now trust each other some more!

GPG Key Signing

We started with GPG key signing. You know, the ussual stuff. Two rows moving against each other, people exchanging paper slips

Signing keys

For actually signing keys at home, we recommended people to use signing-party package and caff in particular. It’s easy to use tool as long as you can send mails from command line (there are some options to set up against SMTP directly, but I run into some issues). All you need to do is to call

caff HASH

and it will download the key, show you identities and fingerprint, sign it for you and send each signed identity to the owner by itself vie e-mail. And all that with nice wizard. It can’t be simpler than that.

Importing signatures

When my signed keys started coming back, I was wondering how do I process them. It was simply too many emails. I searched a little bit, but I get too lazy quite soon, so as I have all my mails stored locally in Maildir by offlineimap, I just wrote a following one liner to import them all.

   grep -Rl 'Your signed' INBOX | while read i; do 
        gpg -d "$i" | gpg --import -a;
   done

Maybe somebody will find it useful as well, maybe somebody more experienced will tell me in comments how to do it correctly ;-)

CAcert

One friend of mine – Theo – really wanted to be able to issue CAcert certificates, so we added CAcert assurance to the program. For those who doesn’t know, CAcert is nonprofit certification authority based on web of trust. You’ll get verified by volunteers and when enough of them trusts you enough, you are trusted by authority itself. When people are verifying you, they give you some points based on how they are trusted and how do they trust you. Once you get 50 points, you are trusted enough to get your certificate signed and once you have 100, you are trusted enough to start verifying other people (after a little quiz to make sure you know what are you doing).

I knew that my colleague Michal čihař is able and willing to issue some points but as he was starting with issuing 10 and I with 15, I also asked few nearby living assurers from CAcert website. Unfortunately I got no reply, but we were organizing everything quite quickly. But we had another colleague – Martin Vidner – showing up and being able to issue some points. I assured another 11 people on the party and now I can give out 25 points. As well as Michal and I guess Martin is now somewhere around 20 as well. So it means that if you need to be able to issue CAcert certificates, visiting just SUSE office in Prague is enough! But still, contact us beforehand, sometimes we do have a vacation ;-)

Permanent link to this article: http://michal.hrusecky.net/2012/11/gpg-key-signing-party/

Nov 14

openSUSE Connect Survey results

Last week I posted a survey about openSUSE Connect. Although some answers are still coming and you are still welcome to provide more feedback, let’s take a look at some results. Some numbers first. openSUSE Connect is not really busy website, it gets about 80 different visitors per day. Not much, but not a total wasteland. Related to this number is another one. More than half of the people responding in the survey have never ever heard about openSUSE Connect. So it sounds like we should speak about it more…

Now something regarding the feedback. Most people think that it is a good idea and that it either is already useful or it can become quite useful. But even though feedback was positive, lot of people made various suggestions how to improve it. So what can be done to make it better? Most of the feedback was centred around following two topics.

Social aspects

One frequently mentioned topic was social aspect of the Connect. It is social network, where you can’t post status messages and where it is not easy to follow what are people up to. So it’s kinda antisocial social network. There were people asking for adding ability to share what are they going – add status messages, chat and stuff they know from Facebook of Google+. On the other hand there were people who complained that they don’t want to have another social network to maintain. And the third opinion which I think is something between was to provide some easier integration with already existing social networks like Facebook, Twitter or Google+. That I would say sounds the most reasonable solution.

More polishing

This was mentioned with most of the sites aspects. openSUSE Connect is a good thing, it contains many great ideas, but somehow they are not polished enough. As connect itself. People complained that UI could be nicer and more user-friendly. That widgets miss some finishing touches. So what is needed in this aspect? Probably some designers to step in and fix UI ;-) But apart from that, some widgets could use even some coding touches. So if you don’t like how is something done, feel free to submit patch ;-)

Conclusion?

People didn’t know about openSUSE Connect and there are things to be polished. We had some good ideas and we implemented them when we started with Connect. But there is still quite some work left before Connect will be perfect. Work that can be picked up by anybody as openSUSE Connect is open source, written in PHP and we even have a documentation mentioning among other things how to work on it. We can off course just let it live as it is and use it for membership and elections for which it works well. But looks like my survey got people at least a little bit interested and for example victorhck submitted logo proposal for openSUSE Connect! So maybe we will get some other contributors as well ;-) And let’s see how will I spend my next Hackweek :-D

Permanent link to this article: http://michal.hrusecky.net/2012/11/opensuse-connect-survey-results/

Nov 05

openSUSE Connect Survey

You might remember that in our team (openSUSE Boosters), we created openSUSE Connect some time ago. It was meant as replacement for users.opensuse.org that nobody knew about and nobody used. We hoped that it will attract more users and that it will be more user friendly way, how to manage personal data. Apart from that, we wanted to include more interesting widgets so it can become your landing page for all your efforts in openSUSE project. With that regards we created bugzilla widget, fate widget, build status widget and some more. We hoped that it would make difference and help people and that they will enjoy using the new site. During this summer my GSoC student created amazing Karma widget as well to make it more fun. And as Connect has been some time already in function, it’s now time to collect some feedback. Did it work? Do you like it? Or did it become just a wasteland? Do you think such a site make sense?

I’m not promising anything right now, but it would be nice to know, what our users think about it and whether it could make sense to put some effort in it and how much and where to concentrate it ;-) So please, fill in this little survey and let me know your opinion. I’ll publish results later ;-)

Permanent link to this article: http://michal.hrusecky.net/2012/11/opensuse-connect-survey/

Sep 05

FrOSCon 2012

Almost two weeks ago, during the weekend, I was in Sankt Augustin to attend FrOSCon. Originally I didn’t planned to go as it is quite far from Prague and I was freshly back from vacation (and therefore quite without money). But I was asked by Sirko to give there a talk about Open Build Service and to participate in cross-distribution packaging workshop. Hard to refuse such an invitation. As the money was the only issue that was keeping me from participating, I decided to ask openSUSE Travel Support committee whether they would be willing to sponsor me. It was my first experience, but it turned out great and thanks to them, I was able to go to the event, speak about great things we have at openSUSE and have a lot of fun! My big thanks to them!

Now let’s get back to FrOSCon. It is annual event in Sankt Augustin, little bit to south from Collogne. I also spoke beforehand with Jan and since I was going there because of talk and workshop, my plan was to spend rest of my time during conference helping out with booth. So let’s start with booth. Jans brought computer with openSUSE 12.2 to show to people and plenty of DVDs, stickers and posters. I brought my plush Geeko, but unfortunately first day he decided that he will rather stay at hotel and while I was leaving my room to go to the bus station, he left my backpack and stayed at the hotel. He was found by friendly hotel stuff and awaited my return on reception desk. And I believe he regretted staying behind later as during the second day, he made a lot of friends on the conference as you can see on the photo.

How was the event? Did I managed to attend any talks? Thanks to other guys and girl we had at booth, I was able to attend the talk that I was the most interested in – talk about Vivaldi.

Vivaldi

What have I learned? Well, reasoning about Vivaldi was that there is no free and open source mobile platform. Although Google Androids is in fact open source, it is developed behind closed doors and when you get your cell, it is full of binary blobs. So Vivaldi is meant to be fully open source platform, developed in the free ecosystem with everything open source so you can mingle with it.

Part of the Vivaldi is of course KDE Plasma. I’m not a KDE user for quite some time and haven’t really paid much attention to what Plasma can actually do, but looked quite impressive. Especially Plasma quick. Example that was shown was that you can write application once and depending on whether it is run on desktop or on tablet, it’s interface will change. And you don’t have to do anything! One of the points of Vivaldi was actually to be able to seamlessly move between your devices without having to experience too different environments.

What else was there interesting regarding Vivaldi? Well, we heard about their troubles with Chinese HW vendor, who didn’t get what GPL means and was hard to get from him sources for kernel and after that fix all errors in them. And we heard that they are building on top of Mer which actually used/uses Open Build Service!

Rest of the event

In the afternoon I had a talk about obs. You can see my students on the picture. I spoke about obs, showed some advantages and showed them the interface. As usual, you can find slides from my talk on github, fork them and use them for your own presentation. Or if you want, you can just download the pdf. There were some questions and people were quite interested in such a small group. Usually on big events with big audience, quite some people show up, listen, but almost nobody really cares. These people had to go to the workshop room and they were interested and talked to me back. After obs talk, I invited them to the packaging workshop we had afterwards with colleague from Mageia and Fedora. There was smaller audience but as there were three of us and two of them actually spoke German, we divided quickly into small groups.

What else did we do? There was a social event, where we got some sausages and local beer. According to local customs, beer is served in tiny (0.2l) glasses. I also met there a Gentoo guy who was carrying Larry the cow!

Next day, I stayed almost all the time at our booth. But at some point I saw Michael “Monty” Widenius approaching Fedora guys so I joined the discussion as it looked interesting. I found out, that Fedora doesn’t ship MariaDB yet and that they had some small troubles getting it in. So I offered our .spec files as we were build MariaDB in obs for Fedora some time already. We talked about the solutions, what’s going on in MySQL word and it was a nice talk.

So overall, I had a great time on FrOSCon. Another thanks to Travel Support Program for supporting me and Sirko for inviting me. And the last note, when I got back home and got to bus, first thing that welcomed me in Prague was kernel panic message on the information panel in the bus. Just a nice ending of a great trip.

Permanent link to this article: http://michal.hrusecky.net/2012/09/froscon-2012/

Older posts «

» Newer posts