Monty turns his attention to the East. The value of JBoss to Red Hat. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Monty Widenius predicted that the EU will clear Oracle-Sun “any moment”, turning his attention to Russia and China.

# Meanwhile the release candidate of MariaDB 5.1 is now …

This Thursday (1/21) we will be hosting a webinar where we go over the new features in Connector/Net 6.2.  You can get more information and register for the webinar here.

It’s worth noting that if you’re using MySQL 5.0/5.1, with SSL enabled, and you’re using yaSSL as opposed to OpenSSL, you’re vulnerable to CVE-2009-4484. Its a buffer overflow, that works over TCP, via the MySQL port, 3306. Lenz furnished us with some information, and the patch is available. You’ll see this rocking when MySQL 5.1.43 gets released.

It affects Debian (presumably, it will also affect Ubuntu). Red Hat/CentOS is spared, because instead of using yaSSL, OpenSSL is used.

MariaDB …

This Thursday (1/21) we will be hosting a webinar where we go over the new features in Connector/Net 6.2.  You can get more information and register for the webinar here.

So you get MySQL or other applications using too much memory on the box or OS behaving funny and using more memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad is it ? Should you count it same as normal Disk IO as the box is having or is it worse than that ?

Swapping is going to impact your performance more than just normal IO and here are 3 reasons why. If you know more please let me know, for my taste these 3 are bad enough so I have not been looking for more.

Cache in the Swap File will multiply IO compared to just having less cache. What happens when page in cache is replaced which is swapped out itself ? First you have to find space to swap in the page (we're speaking about memory pressure right?) which means swapping out some page. This would normally happen in background but still it has to be done. When the pages is …

The performance schema changes are now in the ‘mysql-next-mr’ tree. This means the feature is irrevocably part of the next milestone.

Documentation:

http://dev.mysql.com/doc/performance-schema/en/

Blog postings in order of appearance:

http://blogs.mysql.com/peterg/2009/02/05/mysql-performance-schema/

http://blogs.mysql.com/peterg/2009/02/06/mysql-performance-schema-2/>

http://blogs.mysql.com/peterg/2009/02/09/mysql-performance-schema-3/
…

I appreciate opportunity Jos van Dongen from Tholis Consulting gave me. He granted me access to servers with 8 attached Intel X-25M 80GB MLC cards. The cards attached to 2 Adaptec 5805 raid controllers, with 4 cards per controller.

The cost of setup is 8 x 260$ (X-25M) + 2x500$ (Adaptec 5805) = ~3000$.
Available space varies in depends on raid setup from 300GB to 600GB.

The logical comparison is to compare results with FusionIO 320GB MLC card, so I will copy results from FusionIO 320GB MLC benchmarks.

For benchmarks I used sysbench fileio benchmark.
All raw results are available on Percona benchmarks wiki, there I will highlight most interesting …

After a discussion with my colleague Stephane Varoqui we decided to see how Gearman and the NDBAPI could be used together. The result of the POC was a Gearman worker and a couple of clients (clients and workers use Google Protocol Buffers as the protocol). The worker can:

• set/get/delete records on a single table in MySQL Cluster using the primary key
• set/get/delete "any" type. It is not possible to dynamically add types but this is done at compile time.
  
• supports the following SQL data types: (UNSIGNED) INTEGER, (UNSIGNED) BIGINT, CHAR, VARCHAR/VARBINARY
• support the following Google Protocol Buffer …

The big number of Ubuntu bugs can sometimes be overwhelming. Providing high quality bugs can help in getting the bugs triaged and fixed faster. This is where Apport comes into the game – a tool used to automatically generate crash reports for debugging. Apport can be extended via hooks to provide specific information on a per package basis. For example the Ubuntu Server team added hooks for MySQL during the Karmic release cycle. Relevant logs as well as configuration information are automatically added to every bug reported against the mysql package.

If you have ideas about adding apport hooks for other server related packages let the Ubuntu Server team know. Add it to the wiki page, look up how to write apport …

　一昨日に開催された hbstudy #7 にバックアップの話を聞きに行ってきました。Amanda を中心にした話で、とても勉強になりました。が、設定がめんどくさそうだなぁ、とも。自分の需要にはあわない感じでした。

　勉強会が終わったあとで、自作のバックアップスクリプト blockdiff に関する話を何人かの方とさせていただいたのですが、思いのほか反応が良かったので、あらためて紹介したいと思います。

　blockdiff は、一言でいうと、パーティションやデータベースのデータファイルの差分バックアップツールです。rsnapshot に似ていますが、rsnapshot …