Those who regularly read this blog knows how much I am excited about Percona Live London each year. Now, it is time for me to take part in the organization of this event as a member of the committee and chairman of the conference.

I am really proud to join the committee this year and very happy to share this role with Ivan, Ben, David, Todd and Kenny.

You can imagine that I am honored that Percona has made me this beautiful gift.
Now, we face the challenges!

I am also very pleased to introduce myself as a member of this committee as an employee of Dailymotion. ‘Cause Dailymotion offers me an incredible chance to do my job with passion and fun, like never before.

When I started this blog I wanted to do it as honestly as possible and as humbly as possible.
And I wanted to keep the …

As a first step to developing your websites with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Applications training course where you will learn to:

• Describe the LAMP architecture
• Use the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL
• Use SQL query commands to retrieve data from the MYSQL database
• Change table data using the SQL Data Manipulation Language (DML) commands
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Use session handling to authenticate and monitor user identities
…

Being a fanboy of Spider for a long time. Hoping to see in shipped with MySQL. Now Im glad to see Spider shipping with MariaDB 10.0.4. It is not activated/installed per default, so as it is a SE plugin just do a

mysql> INSTALL PLUGIN spider SONAME 'ha_spider.so';

As Spider provides some funcitions and does some accounting in his own tables you also have got to

# cat /usr/share/mysql/install</em>spider.sql| mysql -u root

There you go. There is an older (german) presentation about Spider from me.
Frederic did on too :)

Let the Spider begin \o/

Sometimes, we need to search specific data available in compressed MySQL backup files. Tools are avaiable to perform normal operation on compressed files, using the powerful Linux Z commands. It's not possible to uncompress n number of huge files. Even after uncompression, the file size goes beyond 100+ GB.

Senario 1: Searching months of compressed mysql backup files for a specific data.

[root@centos4 data]# zgrep -i innodb category.sql.gz
) ENGINE=InnoDB AUTO_INCREMENT=165124728 DEFAULT CHARSET=binary;
[root@centos4 data]#
[root@centos4 data]# zegrep -i innodb category.sql.gz
) ENGINE=InnoDB AUTO_INCREMENT=165124728 DEFAULT CHARSET=binary;
[root@centos4 data]#

Senario 2: Viewing master log file and log position in a compressed file.

[root@centos4 data]# ls -ltrh
total 22M
-rw-r--r--. 1 root root 22M Jan  2  2013 category.sql.gz
[root@centos4 data]# zcat category.sql.gz | less …

ConFoo is currently looking for web professionals with deep understanding of PHP, Java, Ruby, Python, DotNet, HTML5, Databases, Cloud Computing, Security and Mobile development to share their skills and experience at the next ConFoo. Submit your proposals between August 26th and September 22nd.

ConFoo is a conference for developers that has built a reputation as a prime destination for exploring new technologies, diving deeper into familiar topics, and experiencing the best of community and culture.

• ConFoo 2014 will be hosted on February 26-28 in Montreal, at the Hilton Bonaventure Hotel.
• We take good care of our speakers by covering most expenses including travel, accommodation, lunch, full conference ticket, etc.
• Presentations are 35min + 10min for questions, …

Percona Server version 5.1.71-14.9

Percona is glad to announce the release of Percona Server 5.1.71-14.9 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.71, including all the bug fixes in it, Percona Server 5.1.71-14.9 is now the current stable release in the 5.1 series. All of Percona‘s software is …

Percona Server version 5.5.33-31.1

Percona is glad to announce the release of Percona Server 5.5.33-31.1 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.33, including all the bug fixes in it, Percona Server 5.5.33-31.1 is now the current stable release in the 5.5 series. All of Percona‘s software is …

Ask ten DBAs for a definition of ‘Big Data’ and you well get more than ten replies. And the majority of those replies will lead you to Hadoop. Hadoop has been the most prominent of the big data frameworks in the open source world. Over 80% of the Hadoop instances in the world are feed their data from MySQL1. But Hadoop is made up of many parts, some confusing and many that do not play nicely with each other. It is analogous to being given a pile of automotive parts from different models and tyring to come up with a car at the end of the day. So what if you do if you are wanting to copy some of your relational data into Hadoop and want to avoid the equivilent of scraped knuckles? The answer is Bigtop and what follows is a way to get a one node does all system running so you can experiement with Hadoop, Map/Reduce, Hive, and all the other parts.

Bigtop is an Apache Project self …

Time flies and MySQL Connect is just around the corner...Schedule Builder was launched last week to help you build your own schedule, selecting and pre-enrolling in sessions you plan to attend.

You can check out the program in our content catalog as well as via a new Focus on MySQL Connect document listing all sessions with time and location. If you’d like to expand your InnoDB knowledge, below are the sessions specifically focused on InnoDB …

We’ve all been through downtime at some point and deplore the lost work and productivity that comes with it. And the only thing worse than server downtime is having to report that downtime to frustrated customers who are depending on your service for their business.

Yesterday, AWS server issues meant downtime for highly trafficked sites Instagram, Vine, Airbnb, and IFTTTA. According to AWS’s health dashboard, the company’s North Virginia data center may be to blame.

The fact is, any cloud system is subject to outages, from Yahoo Mail to Microsoft BPOS and VMware; however, outages aren’t and shouldn’t be business as normal.

While we never wish for anyone to experience downtime, when stories like AWS hit the …