Buongiorno is known in the worldwide mobile ecosystem for developing and managing paid applications and content that help consumers get greater enjoyment from their mobile devices.

Buongiorno’s strategic goal is to deliver directly to consumers around the world a broad portfolio of content & services on all their personal devices, exploiting social and location based propositions, and letting telecom operators be in control of the billing. With direct connections to more than 130 telecom operators in 25 countries, over 10 years’ experience and a team of 600 professionals, Buongiorno makes the mobile internet experience happen for consumers globally. Buongiorno’s web apps brands include Gamifive, MuchGossip, Fingerbooks, Appsfuel HTML5 Marketplace, Winga, Play.me and the mobile payments solution Cashlog.

…

Working as a Percona Support Engineer, every day we are seeing lots of issues related to MySQL replication. One very common issue is slave lagging. There are many reasons for slave lag but one common reason is that queries are taking more time on slave then master. How to check and log those long-running queries?  From MySQL 5.1, log-slow-slave-statements variable was introduced, which you can enable on slave and log slow queries. But what if you want to log slow queries on slave in earlier versions like MySQL 5.0?  There is a good solution/workaround: pt-query-digest. How? …

A MariaDB Howto authored by: Erkan Yanar.

This is a Howto about installing MariaDB Galera Cluster on Debian/Ubuntu. Because a lot of people were having problems installing MariaDB Galera Cluster, elenst from #maria on freenode forced me to write this Howto

Installing MariaDB Galera Cluster is in fact quite easy and actually kind of boring in the end. This Howto is written for (and tested on) on Debian 7.1 (Wheezy) and Ubuntu 12.04 (Precise).

What we need

In our setup we assume 3 nodes (node01, node02, node03) with one interface each. We assume following IP addresses: 172.16.8.5, 172.16.8.6, and 172.16.8.4. We need three packages installed on all nodes:

• rsync
• galera
• mariadb-galera-server

As Galera does not ship with the distribution repositories, go for the …

The Percona Live MySQL Conference 2014 is less than two weeks away, running April 1-4, and excitement is building for the great lineup of speakers, events, and networking opportunities it offers. This year’s conference also features the first-ever Open Source Appreciation Day, which takes place on March 31, 2014, and includes two separate events, CentOS Dojo Santa Clara and OpenStack Today, highlighting these two key technologies. A new keynote address about the OpenStack ecosystem by Boris Renski, a member of the OpenStack Board of Directors, has also been added. …

When I presented JSON UDF functions at MySQL Connect last year attendees asked me to implement few features. I quickly wrote their wishes in my notepad. I also created feature requests at bugs.mysql.com  when I was home.

During following months I fixed bugs in the functions and implemented feature requests, including those which I got from MySQL Connect. I started from most important and affecting users, such as wrong results bugs of features for which I got more than one request.

But today all such requests finished and I am working on bug #70580  This feature request says: "Add function JSON_COUNT which will go through the JSON document and count number of childs of the root element." Well, I wrote it myself, but I don't exactly remember if the user wanted to know depth of the JSON …

We announced yesterday that the call for proposals for MySQL Connect @ OpenWorld 2014 is now open!

Part of Oracle OpenWorld 2014, MySQL Connect @ OpenWorld will be held September 29 - October 2 in San Francisco.

We encourage MySQL customers, partners and community members to submit proposals to present best practices, case studies and insights you’ve gained working with MySQL. Proposals can be submitted for conference sessions, Birds-of-a-Feather sessions and tutorials.

MySQL Connect @ OpenWorld will feature five tracks:

• Performance and Scalability
• High Availability and Replication
• Cloud and Big Data
• Database Administration and DevOps
• Architecture and Application …

Having noticed the release of PHP 5.5.10 last week while I was speaking at UTOUG, I checked the deprecated mysqli functions web page. There weren’t any deprecated by 5.5. Unfortuantely, there were six mysqli functions deprecated in 5.3 and removed in 5.4. Unfortunately, many of my posted code examples use 5.2 or 5.3 where they would have worked. The deprecated mysqli functions are:

• mysqli_bind_param
• mysqli_bind_result
• mysqli_client_encoding
• mysqli_fetch
• mysqli_param_count …

MySQL Fabric is a new framework that adds High Availability (HA) and/or scaling-out for MySQL. MySQL Fabric achieves scale-out by managing the sharding of table data between multiple MySQL Servers and then having Fabric-aware connectors route queries and transactions to the correct locations – scaling-out will be the subject of a future post and the rest of this article is focused on using MySQL Fabric for HA. It starts with an introduction to HA and how MySQL Fabric delivers it before going on to work through a full example of configuring a HA farm of MySQL Servers together with the code that the application developer needs to write in order to exploit it. Note that at the time of writing, MySQL Fabric is not yet GA but is available as a public alpha.

…

Do you have an idea for improving MySQL? Or do you see a problem in the code you think you can fix? Do you want to see your contribution becoming a part of the MySQL Server codebase?

MySQL Engineering gives you the opportunity of having your code considered for inclusion in one of our upcoming releases.

How to contribute?

These are the steps to follow:

1. Make sure you have signed the Oracle Contributor Agreement (OCA).
2. File a bug report at http://bugs.mysql.com
3. Attach your code to the “contributor” tab in the bug report.

That is all.  At the time of writing, around 100 people have signed up as contributors to MySQL.

What happens then?

The bug system will automatically …

Two weeks ago we released an Alpha release of Percona Server with TokuDB. Right now I am on a final stage of evaluation of TokuDB for using in our project Percona Cloud Tools and it looks promising.

What is the most attractive in TokuDB? For me it is compression, but not just compression: TokuDB provides great performance over compressed data.

In my synthetic tests I saw a compression ratio of 10:1 (TokuDB LZMA to InnoDB uncompressed), in the real production data it is less, 6:1, but still impressive.

In our servers we have 4 x SSD Crucial M500 960GB combined in RAID5, which give 2877.0 GB of usable space. With TokuDB we should be able to pack around 15TB of raw data. Of course we can try InnoDB compression, …