Apr 14

Help me polish MySQL in openSUSE 12.2

"We can do it!" by workerIf you are following news regarding openSUSE and MySQL, you probably already know, that we have both MySQL and MariaDB in openSUSE to allow users to choose what they want to use. And if these two options are not enough, we’ve got server:database repository with newest and greatest development versions of both and MySQL Cluster on to of that. I think all this is great and awesome, that we have all of that.

Now to the not so great part. Unfortunately I’m bare human, I have to eat, sleep and I have some work, some bugs that takes a lot more time that I expected, some school duties to take care of and of course openSUSE Conference to organize! So as a result of all that, I can’t polish MySQL and MariaDB as much I would love to. And on top of that, I’m not expert in MySQL configuration. Part of that is that it just works and I never had any server where MySQL was slowing things down. But there is plenty of skilled MySQL administrators out there in community! So I’m calling out for help. You skilled MySQL admins probably have a lot of interesting tweaks you are applying to default configuration file. So take a look at them and think what could be useful for everybody, not just in your specific use-case. And either send me snippet with short explanation in the comments, or create .cnf file add it to the flavor directory and send me pull request on github! I’ll keep credits and your explanation of the snippet inside, so people will know, who came with this cool option and what does it do ;-)

Oh, and don’t get discouraged if I don’t include it right away, it may take me some time to get to it, but I’ll appreciate every suggestion ;-)

Permanent link to this article: http://michal.hrusecky.net/2012/04/help-me-polish-mysql-in-opensuse-12-2/

Feb 28

Some news about MySQL in obs

MariaDB logoIf you follow MySQL community at least as much as I do (browsing trough the planet from time to time), you know that some exciting milestones were reached both in Oracles MySQL and in MariaDB. And as I love bleeding edge software, you can try all these exciting things prepackaged in openSUSE ;-)

Oracles MySQL

Let’s start with news from guys at Oracle. Recently they released new MySQL Cluster 7.2. Yes 7.2 is GA now. And you can find a lot of exiting info online about how fast it is! If you don’t believe benchmarks done by others, try it by yourself! We have it in server:database repository for all supported openSUSE versions, SLE and few other rpm based distributions. Just add the repository and install package mysql-cluster_72. Pretty easy, isn’t it? ;-) So if you have MySQL cluster and want to take advantage of the latest improvements, give it a try ;-)

MariaDB

Now a some information regarding MariaDB. Folks at Monty Program were not sleeping either. They released release candidate of MariaDB 5.3, progressing towards GA and yesterday they released first alpha of MariaDB 5.5.20 – merge between their 5.3 and MySQL 5.5. Everything is packaged and ready for you to try in server:database ;-) But let’s speak a little bit more about MariaDB…

MariaDB 5.3 series

MariaDB 5.3 is currently in version 5.3.4 and is considered release candidate. It is around for quite some time already. It contains many improvements and people are doing benchmarks and are excited about changes. And it’s getting closer and closer towards GA. I asked on #mariadb channel and was told that GA is probably just a few weeks away. So here comes what I plan to do. openSUSE already contains MariaDB and we have MySQL Community Server as default. Therefore I’ll put MariaDB 5.3 into openSUSE 12.2 (next planned release). I’m running it for quite some time on this server and I haven’t lost any data. Looks quite stable and if somebody think that is still too new and untested, he can always use MySQL Community Server. If you have any objections, comments are lower on this page ;-)

MariaDB 5.5

Other think I would like to speak about a little bit is MariaDB 5.5.20. First alpha was released yesterday. What is so interesting about this release? It is merge of MySQL 5.5 and MariaDB 5.3 so it should contain goodies from both words! Ok, some things from MySQL 5.6 are still missing, but anyway, sounds promising. Although I have really low traffic website I switched today in the morning to this version, just to test that everything works fine and to encounter possible troubles sooner. If you want to try it, just add server:database repository and install package mariadb_55. That’s all and you can start testing new version and reporting bugs (preferably directly upstream ;-) )

Permanent link to this article: http://michal.hrusecky.net/2012/02/some-news-about-mysql-in-obs/

Feb 27

KDE 4.8 release party

Minulý pátek se v Praze odehrála KDE 4.8 release party. Chvilku nám trvalo ji zorganizovat, ale nakonec přecijen proběhla. Pro ty, se co nemohli osobně dostavit, malé ohlédnutí se (s fotkami, ale už bez dortu, ten už není).

Loading...

I když se party odehrávala v Praze, kupodivu byla většina přednášek v angličtině a angličtinu bylo slyšet i mez přednáškami. Jakto? Většina našich přednášejících neuměla česky (alespoň prozatím ne). Theo, který party organizoval a zařizoval vše důležité, dokázal na party přilákat i známé zahraniční hosty. Do prahy přijel na party Cornelius Schumacher a Jos Poortvliet. Pokud se zajímate o KDE, určitě jste obě jména už slyšeli. Jos měl přednášku o patnácti novinkách v KDE (oslavující 15 let vývoje KDE) v pěti minutách. Nakonec přednáška trvala minut osum. Proč je dálka přednášky důležitá? Obecenstvo si mohlo tipnout, jak dlouho bude přednáška trvat a tři nejlepší tipy vyhráli plyšového geeka. Cornelius zase mluvil o historii KDE a jak se vyvynulo z projektu pár lidí v celosvětovou komunitu obsahující mnoho a mnoho lidí. Kromě návštěvníků ze zahraničí měl přednášku i Theo (tu jsem bohužel zmeškal jelikož jsem jezdil nahoru a dolu výtahem pro návštěvníky) a Tomáš Chvátal, který mluvil o překladech a o integraci LibreOffice do KDE.

Po přednáškách se Cornelius ujal krájení dortu a každý z návštěvníků mohl dostat kousek. Závěr párty byl tedy ve znamení pojídání KDE dortu, pití openSUSE piva a povídání si o opensource. Party se podle mně vyvedla, alespoň já jsem se dobře bavil i když KDE nepoužívám. Děkuji všem kdo se zúčastnili a těším se na příští setkání, které bude vlastně už tento víkend.

PS: Pokud si chcete KDE 4.8 sami vyzkoušet, nějaká média lze nalézt v SUSE Studiu nebo si můžete počkat na oficiální vydání Gentoo médií později tento týden.

Permanent link to this article: http://michal.hrusecky.net/2012/02/kde-4-8-release-party-cz/

Feb 27

KDE 4.8 Release party

Last week on Friday we had a KDE 4.8 release party in Prague. It took us some time to organize everything, but in the end everything went well. For those of you who missed the party, little overview (and some photos, sorry, no cake left).

Loading...

Even though it was a Prague release party, we spoke quite a lot in English as well. Why? Well most of our speakers don’t speak Czech (yet). Theo was one organizing the talks and inviting speakers and doing all important stuff around the party and he managed to get here Cornelius Schumacher and Jos Poortvliet to come. Both of them has a long history with KDE, so they were giving great talks. For example Jos spoke about 15 new KDE features in 5 minutes and Cornelius about how KDE evolved over the time from small project done by few people to the current state where many people from all over the world works on it. Talk by Jos was also important from other reaseon. People could bet how long will it take and three closest to the actual time have won plush geekos! In the end five minutes talk lasted eight minutes. Apart from famous foreign visitors, we had talks by Tomáš Chvátal about translations and LibreOffice KDE integration and Theo also had a talk which I unfortunatelly missed because I was fetching party attendees in the reception and getting them up through the lift.

After the talks, Cornelius started cutting the cake and serving it to all attendees and we talked and enjoyed the KDE cake and openSUSE beer and talked… I would say, party was great and even though I’m not a KDE user, I enjoyed it! Many thanks to everybody who participated and I’m looking forward to next open source event which happens to be this weekend :-D

PS: If you like to get your hands on KDE 4.8 Live media, you can find some in SUSE Studio or wait for official Gentoo Live media that will be released later this week.

Permanent link to this article: http://michal.hrusecky.net/2012/02/kde-4-8-release-party/

Feb 26

openSUSE on Android (chroot only)

"We can do it!" by workerYou all probably heard about Ubuntu for Android, right? Ubuntu is very good in the marketing and they can do a lot of locomotion around everything. So what if you have Android, want to use Linux distribution and Ubuntu isn’t your cup of tee? You can use openSUSE of course! Let me show you how…

Requirements

What do you need? Obviously some device with Android. And as our main focus in openSUSE is on newer devices, you’ll need armv7 one. How do you know whether your device is new enough? For start, my old Nexus One is armv7. So if you have something newer (not counting cheap no-names), you are probably good to go. If you want to know for sure, open up the terminal on your android device and run cat /proc/cpuinfo. If it shows Processor : ARMv7, you are good to go!
Now a little bit of requirements on Android system itself. You’ll need root on your device and you’ll need decent enough busybox. Both of that is usually part of unofficial ROMs. There might be some differences and some troubles, but let’s deal with them when times come.

Separate partition installation

I would say that best way to install openSUSE is to repartition your SD card. If your are not wiling to do so, I’ll describe how to run it from file some other time… Or you can start from my previous post, replace the older script with the new one and adjust it ;-)
So let’s start repartitioning. I would suggest to take your card out of your device, put it into card reader and repartition it in your computer, where you can use nice tools like gparted. Create one ext4 partition that will hold your root. I would recommend to create it as your second partition. Some programs (like recovery programs) expects first partition to be FAT, so you’ll into some troubles otherwise. Create your partition as big as you want, but my recommendation would be at least 1G. Depending on what do you plan on doing, it can be more.
So I hope that you created partition successfully by yourselves, now it’s time to get openSUSE for your device. Where do you get that? On our download servers! Yes, we’ve got images and tarballs prepared for some devices. What you want to get is file starting with LimeJeOS-openSUSE-Factory-ARM-rootfs.armv7l and ending with -tbz.tar.bz2. Why not put whole link and make it easier for you? These images gets rebuild automatically, so the part that I left out changes over the time as you get newer and newer versions ;-) But don’t worry, you can use zypper to upgrade too ;-)
Lets put it on the card. Tarball you just downloaded actually contains another tarball and checksum. I know, not fun, but no big deal either. So get to the inner tarball, mount second partition of of your sdcard and unpack the inner tarball to it. Unpack it as a root! This can be important as as ordinary user you might not have the rights to create some files and some rights might get dropped in the process. This may result in not working system. So do the unpacking as a root. Just a hint how to do it in command line (might need some paths adjustements according to your system):

tar -C /mnt/sdcard-ext2 -xjf /home/user/download/Lime*.tbz

In the end, you should see some directories like bin and etc directly on this partition. If you do so, you are almost ready!
Now the hard part, take this script and adjust it! Don’t worry, I don’t want you to learn shell scripting, so adjusting will be pretty easy. There are only two or three lines for users to fiddle with. For partition setup, you need to change just one of them. The following one:

DEVICE="/dev/block/mmcblk1p2"

This line says where your openSUSE partition is. How to check whether it is set correctly? If you followed my advice, it will be last partition you’ve got on your device. So try running ls -1 /dev/block/mmcblk* | tail -n 1. If your busybox can’t handle that, use ls -1 /dev/block/mmcblk* and look for the last device in alphabetical order. Once you make sure the device is set correctly, you are ready to go and you can run the script in the terminal. It will put you inside openSUSE basic chroot. You can look around, there is not much of software in the beginning, but you can use zypper to install everything you need ;-)
I hope you’ll enjoy openSUSE on your mobile phone, if you want to just take a look at the script, feel free to do so. As always, if you have no idea what are you doing, you can damage your device and I take no responsibility for any damage. But if you run into some troubles, drop by on our IRC channel #opensuse-arm on Freenode and there are people willing to help. You can find me there as well, my nick is |miska|. Oh, and one last think, root and user password is linux ;-)

Permanent link to this article: http://michal.hrusecky.net/2012/02/opensuse-on-android/

Older posts «