Michal Hrušecký

Do you also feel that Hackweek is nearby? So many people will be working together on so many interesting stuff. And when you are working in large groups around the world, sometimes you need to talk about code snippets. And then you use something like pastebin.com. But there are many similar services on the web. And I already encounter on openSUSE IRC people using for example fpaste.org. So why don't we have some paste thing to show that we are the openSUSE guys and girls? My guess is that nobody cared enough to create other one then opensuse.pastebin.com. But I was part of the Umbrella team, so I want to have everything nicely integrated... So here I come with openSUSE Paste.

It is basically Open Source software called Stikked. I just downloaded it, configured it and make it fit to our Bento theme. Currently it is hosted on my webserver only, but I'll try to get some nice opensuse.org name for it. I'll also publish source code adapted to Bento theme once I figure out how to create a repository on gitorious.org

Just one nice tip at the end. If you want to use it frequently, add following to your .profile

SUSEPASTE='curl -v -F "code=<-" -F "name=`whoami`" '
SUSEPASTE="$SUSEPASTE -F \"submit=submit\" -F \"lang=text\" "
SUSEPASTE="$SUSEPASTE http://paste.michal.hrusecky.net "
SUSEPASTE="$SUSEPASTE 2>&1 | grep Location "
alias susepaste="$SUSEPASTE"

Then you can use it like this:

$ dmesg | susepaste
< Location: http://paste.michal.hrusecky.net/index.php/view/33355419

So try it, play with it, and any comments are welcome (and once I publish the code, contributions too)

openSUSE Paste

UPDATE: Public git repository with sources available on http://gitorious.org/opensuse/paste

Original title was 'MySQL dropped from openSUSE!!!'. I wanted to have some shocking title, but I changed it as I don't really want to scare you so much But it is partially true, there is no mysql package in openSUSE anymore. But of course we DID NOT really dropped MySQL. In fact, we now have more MySQL in openSUSE then we ever had! Do I got your attention? Read on

What and why?

What really happened is that I renamed original MySQL package. Now it is called mysql-community-server. If you take a look at SUN/Oracle web, they call it like this for a long time, so it makes a little sense... As a result, there is no real package called mysql in openSUSE anymore. But mysql-community-server provides mysql so even if you try to install mysql, it will work. This change also have one funny consequence. Do you remember package mysql-client? Now it's called mysql-community-server-client

Why such a change? I haven't done something like this just because such a little difference in the naming of packages. No, I had some other plans as well. Reason to rename original MySQL package was to provide some space for other possible mysql providers. And we have them in 11.3! These other providers are MariaDB and MySQL Cluster. So now you can choose which MySQL do you want And as all of them provides the same symbol, namely mysql, you can use whichever you want to satisfy dependencies. But the default one is still mysql-community-server. So if you don't need anything special, nearly nothing changed for you.

Alternatives

So let's take a brief look at what MySQL Community Server alternatives do we now have in openSUSE...

MariaDB

MariaDB is a backward compatible, drop-in replacement branch of the MySQL Database Server. That means that differences in the user interface are minimal. You probably wouldn't even notice on the first sight if they get replaced. So what are the differences? The best way is to read official page about differences:

http://askmonty.org/wiki/MariaDB_versus_MySQL

Basically MariaDB incorporates many community provided patches out there and some more bleeding edge storage engines. If you want to try it, you can simply type

zypper in mariadb

And zypper will take care of conflicts and replace your MySQL with Maria. If you want to get back to MySQL, it's similarly simple, just use

zypper in mysql-community-server

MySQL Cluster

Other MySQL alternative is MySQL Cluster. This should provide real clustering support for MySQL. And it is also distributed and maintained by Oracle. If you are interested in HA, you have many servers, you might be interested in this. For more information check official web (we included version 7.0 in 11.3):

http://www.mysql.com/products/database/cluster/

If you want to try it, you can simply type

zypper in mysql-cluster

And zypper will take care of conflicts and replace your ordinary MySQL with MySQL Cluster. If you want to get back to MySQL, it's similarly simple, just use

zypper in mysql-community-server

For those who didn't know, last week there was an event called LinuxExpo in Prague. And we off course went there with the Czech part of openSUSE Boosters team to talk about openSUSE. Other colleagues also helped with running openSUSE booth. And some of our community members we standing around talking to people as well.

We had our HP TouchSmart machine with us (same one as we had on FOSDEM), but this time we had only one of them. But to make things more attractive for visitors, we took steering wheel with pedals with us and we had Torcs preinstalled. So people wasn't only touching our desktop and playing with camera, but also racing.

We also had a presentation with Pavol about how people can use openSUSE Build Service and SUSE Studio in schools to prepare LiveCD for student to make it easy for them to run their school software at home. I used it in similar context already (I'll write something about that later).

So overall, it was nice being there, meeting many people working to make Linux better and get some feedback from our users. And at the end here are few photos that appeared on our hard drive during LinuxExpo.

As for the photos, just few people you might know... There are some people from SUSE Office in Prague. But you can also see non-SUSE people there. You can see Tomáš Matějíček - author of the Slax and even one of the Gentoo developers Other photos can be found on root.cz photo gallery and on Liberix photo gallery.

During last two week I was among the other things investigating how to implement search through all openSUSE web pages. As part of our Umbrella project, we want to make all our webs look unified and search through all of them is a part of this goal. So what I tried and what are my conclusions? Let's see...

Customized Google Search

First idea would be to use Google search. They are offering customized search for anyones web. They are good at searching and we wouldn't need implement anything by ourself. Other upside of this approach is that we wouldn't need any infrastructure for this. They will let us use their machines.

But it has some downsides as well. One minor thing is that it will index all our sites regardless of their content. So wiki pages may come up less relevant then a comment in someones blog. I don't think we really want this.

The major downside as I see it is the agreement. I'm not a lawyer, but I didn't like it. Lets say that request that we have to display some advertisements and Google preferred links is ok. But according to the agreement we can't customize the results as much as we want, we can just provide some theme and they may use it somehow (no details in agreement). Other thing I found quite a disturbing is that they can use our logo and trademarks forever to promote their products. Well, I don't think we mind right now, but forever is a long time. Maybe I just didn't understood the agreement well, but I'm quite sure that we don't want to use it without discussions with some skilled lawyers.

At last but not least, as an Open Source community we should try to go for some Open solution. So I decided to check some Open Source engines available on the internet...

Open Source Solutions

I took a brief look at Xyzse and Swish++. Disadvantages I found were that last versions seemed to be released somewhere in 2008. This doesn't have to be bad, but I think that something more alive may be better. And Other thing I didn't liked was that it seemed like I need to hardcode some search limitations during compilation of the packages (at least it looked like that from installation instruction that required to edit some headers manually).

YaCy

YaCy is a really interesting search engine. It's main innovative idea is that it is decentralized. You just run one peer, connect it to the network and then search across all peers in that network. You don't need any big server, you can make it work with just everybody indexing his own web. Really interesting idea. One small thing I personally didn't like was that it is in Java (I don't really speak Java). It was quite easy to try it as it started it's own web server, but it looked like it wouldn't be easy to customize it. It would be great to use it for my own webpages, but I think we want something else for openSUSE.

Datapark Search Engine

Last search engine I want to speak about is Datapark Search Engine. It is Open Source engine and it is written in C. For storage of the data it can use MySQL, PostgreSQL or SQLite. It can be used as a cgi on web, as an apache module or through it's php bindings. Results page is highly customizable. It's just a HTML template that gets read and filled with results. So it wouldn't be any problem to create Bento theme for it and make it integrated with the rest of our webs.

Other interesting feature is that it allows to tag all servers and create hierarchical category list to make searching on some part of our infrastructure easier. Didn't tried this feature yet, but I think we can use it. We can also add some extra points to the most relevant webs (I think wiki deserves this).

Last very interesting feature is that it can index pretty much anything. It doesn't have to be only web pages. Everybody can write its own plugin that knows how to handle some specialized format. If I want to be able to search among the rpms on the Build Service, I can write easy filter to make it possible. And then during the search for MySQL I wouldn't see only Wiki pages dedicated to the MySQL and related blogposts but also rpms of MySQL itself. Pretty interesting, isn't it? I'm not really sure whether we want this, but we can do it with this search engine

Conclusion

I think we should use Datapark Search Engine. Because it's Open Source, it has categories and tags, it can add extra points to sites we like and it's highly customizable. If I missed something interesting we should evaluate, please let me know. There are many interesting projects out there and I tried only few of them. Although I think I found what I was looking for, any comments are welcome as well as any suggestions...

Few weeks ago I was at FOSDEM.  It was really amazing experience. I meet many interesting people, learned quite some thing and I returned full of enthusiasm. Open Source events are really great.

But all the fun wasn't over even after the FOSDEM. I spent few more days in Bruxelles attending MySQL packagers meeting organized by SUN/Oracle. We spent quite some time talking to each other. We learned what MySQL people are doing and how. And they learned how do we deal with MySQL and what is troubling us. And many good things will come from this.

First but certainly not last of them is about to appear now. One very interesting thing we learned at meeting was MySQL release policy. What openSUSE and Ubuntu and maybe some others are doing is that after release date there is generaly no version updates allowed. We are only fixing serious bugs and security related issues. It takes quite some work. What we learned is that new releases in stable branch of MySQL are in fact maintanance updates. If you update from 5.1.43 to 5.1.44 you wouldn't get any new features. All you will get are bugfixes. And only bugfixes of serious or security related issues. Does it sound familiar? Yes it is the same thing we are doing! So I discussed it with our maintanance team. And we came to the conclusion that we want to give our users all serious fixes. Not only these few selected. And the best way to do it is to use maintanance updates provided by MySQL people themself. I'm not saying that I don't have enough confidence to play with MySQL sources, but I think that MySQL people can do it better

Yes, you are guessing right. What I'm trying to say is that we are going to update MySQL to the latest available version. This means 5.1.44 for openSUSE 11.2 and 5.0.90 for older openSUSE. We will start with 11.2 as version gap is smaller there and if everything will proceed smoothly, we will continue with 11.1 and 11.0. For 11.2 you can help by testing update. Currently 5.1.44 update is prepared for 11.2 in server: database: STABLE and I'm running some final tests. If you want, you can try it too (not recomended on production servers yet) and if you'll find any problems, please report them before it will hit official updates.

Remember, this is just the beginning. I've got some bigger plans regarding MySQL in 11.3