A picture is worth a thousand words ..

In addition to my post http://schimpf.es/android-clients-for-mysql/ I made some screenshots of all the existing MySQL clients available in android. Sometimes it is alot easier to decide for or against an application viewing some simple screenshots.

Connect2Mysql

[nggallery id=3]

ProSQL

[nggallery id=4]

MysqlManager

[nggallery id=5]

Mysql now

[nggallery id=8]

VCROX

[nggallery id=9]

If you want to read more about these MySQL clients, please read my post.

We're looking forward to spreading the MySQL, MariaDB & Cloud message further in Finland this year!

Talouselämä, the largest Finnish business publication today published their list of the Top 20 Startup companies in Finland. The selection was made from approximately 100 applications from companies based in Finland. 

read more

Libdrizzle is getting better and better with every release, and to reflect this we have two announcements to make.

First of all, Libdrizzle 5.1.2 has been released.  This release has several major bug fixes and performance enhancements.  Changes are as follows:

• Non-blocking Windows connections are now more stable
• Improvements to Windows building
• Unix Socket connections are now more stable
• Memory allocation/freeing cleanups (for performance and ease of code)
• Network packet buffer now much more flexible
• Many performance improvements (the bundled drizzle_binlogs tool is now around 10x faster on my i7 laptop)
• Several other minor bug fixes

API chages:

• drizzle_query_str() has been removed, drizzle_query() with a 0 byte length parameter now does the same thing.

As always you can …

I’m pleased to announce the initial list of keynote speakers for the Percona Live MySQL Conference & Expo, April 22-25 in Santa Clara, California. The conference promises great content with over 90 speakers in more than 110 sessions, 15 tutorials, and multiple keynotes. The MySQL Community Awards 2013 are also now accepting nominations. And do not miss your chance to save by taking advantage of the Super Saver registration rates which are only available for a few more days!

Keynote Speakers

This year the Percona Live MySQL Conference is pleased to welcome Matt Aslett of 451 Research who will present the keynote “MySQL, YourSQL, NoSQL, NewSQL – the State of the MySQL Ecosystem”. You can help Matt with his presentation by participating in 451 Research’s …

FOSDEM 2013

The Free and Open source Software Developers’ European Meeting (FOSDEM) is a two-day event organized by volunteers to promote the widespread use of Free and Open Source software. As in previous years, there is a dedicated stream of MySQL Sessions. On Saturday (2nd Feb) evening there’s a MySQL community dinner and then we’ve a packed program from 9:15 through 17:30 on Sunday (3rd Feb).

FOSDEM 2013 is a free event and there’s no requirement to pre-register – just get yourself along to Brussels.

This year I’ll be making a presentation introducing MySQL Cluster. Several of my colleagues from …

Last couple of months I've got several questions regarding migrating from normal MySQL (InnoDB or MyISAM) to MySQL Cluster. Migration from normal MySQL to MySQL Cluster can not be done the usual way by "just" changing ENGINE from MyISAM or InnoDB to NDBCluster, the reason for this is because MySQL Cluster is not a traditional Storage engine in MySQL.
If you are new to MySQL Cluster and want to know more, please follow links bellow to get started with MySQL Cluster:

• Compare InnoDB and MySQL Cluster, go here.
• MySQL Cluster Evaluation Guide, go here.

Now to the interesting part - how to actually migrate from normal MySQL to MySQL Cluster?
The normal way to migrate from …

I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair.

Specifically, about the care we have to take because replication is asynchronous.  This means the slave  may not have current data at all times, so an application must choose to query the slave or the master dynamically.  As much as possible, we’d like to automate this choice so that application developers can be the most productive.

Please join me for this webinar by registering here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php

The post Webinar on …

Do you still need the sources? Found them here: http://contrib.spip.net/IMG/c/myisam_suggest.c

Maybe I’ll upload them on github somewhen.

For the past few days, I have been upgrading a few servers. We are going from Percona’s patched MySQL 5.1 to MariaDB 5.5 (the subquery optimization is excellent, and we have lots of subqueries). Our process involves upgrading a slave first, and letting it replicate for a while, and if everything’s good, update more slaves, then the master.

This has served us well in the past. And now that we are checking data integrity between masters and slaves with pt-table-checksum, the process involves checking before we start that there is data integrity. This is easy, as we checksum twice daily and have a Nagios alert if there are any discrepancies. After the upgrade, we checksum again, to be sure no data has been changed/corrupted in the process of doing a mysqldump export and import.*

Much to my surprise, after importing the data on one of our …

MySQL Marinate has started strong and it is not too late for you to join!

Join the MySQL Marinate self study group. We are only in week two and you can easily catch up with the rest of the class.

162 signed up for this FREE virtual self-study course from the Boston MySQL Users Group. Each week the group covers a chapter and does the homework. The homework from the first two weeks was pretty light and, if you get stuck, the participants are very helpful.