Taxonomy upgrade extras: innodb

In this weeks MySQL workshop we were discussing, beside other things, about the innodb_file_per_table parameter and its advantages of enabling it. In addition there was a discussion if the InnoDB system tablespace file can be shrinked once it has been grown very large or not. We all know the answer: The InnoDB system tablespace file does never shrink again.

But why should it not be possible? Other databases like for example Oracle can shrink or even get rid of tablespace files... After some philosophising about it we came to the conclusion that we should give it a try if this is possible with InnoDB as well.

The scenario we considered was the following: You inherit a MySQL database with InnoDB tables but innodb_file_per_table was set to 0. So all the tables are located in the InnoDB …

Percona is glad to announce the release of Percona Server 5.5.28-29.2 on December 7th, 2012 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.5.28, including all the bug fixes in it, Percona Server 5.5.28-29.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details of the release can be found in the 5.5.28-29.2 milestone at Launchpad.

New Features:

• Multiple …

Percona Live UK took place this week. It was the second year in a row and once again a great conference. Thank you Percona for bringing the show to Europe, it means a lot for the European MySQL community - many people who don't visit the Santa Clara conference were present in London. It's kind of funny, I even meet more Finnish MySQL users in London than I do at home!

I gave 2 talks. Slides are now posted on Slideshare:

read more

Fetching data from a database to then get it into an Excel spreadsheet to do analysis, reporting, transforming, sharing, etc. is a very common task among users. This task can be accomplished in several different ways and with different tools getting the same result; but users may find the process rather complicated, too technical and lengthy. With MySQL for Excel the task of importing data from a MySQL database to an Excel spreadsheet becomes an easy one and accessible to all types of users.  Here is a quick guide describing how to import data to Excel using MySQL for Excel.

I have been a member of Oracle since April 2011. I am forever grateful to Oracle and the MySQL Team for allowing me to join and work on their behalf.  Oracle has been very supportive of MySQL and I look forward to their continued advancements with MySQL.  I have also traveled all over the United States meeting and talking with members of the MySQL community and it has been wonderful.  Thank you to everyone who stopped by and talked or attended, not only my sessions, but all of the MySQL sessions at conferences.

I do enjoy supporting MySQL and I will be continue to blog and speak at events whenever I am able too. I will however be moving on. Since people will ask, I am going to be joining the "independently spirited and fiercely unconventional" …

It’s always sunny in the database arena, even if the data is engulfed in the clouds. Innovation rays keep databases illuminating and bloggers make hay in this sunshine and this Log Buffer Edition sift through all those blog post and brings you Log Buffer #298. Oracle: When Michael Abbey writes it, it stays written. His...

Recently there have been discussions on several vulnerabilities in MySQL and closely related projects such as MariaDB and Percona Server. Usually we have inherited security fixes from MySQL when we have updated Percona Server to be based off a new Oracle MySQL release. In this case however, Oracle has been incredibly quiet.

We’ve been examining how these affect current Percona Server versions and will shortly be making security releases and more information available (we wish to ensure what we say is correct in regards to Percona Server).

As seems to often be the case, we already had a release in the pipeline – Percona Server 5.5.28-29.2 which contains many bug fixes that affect users (see our release notes). We’re going to still release 5.5.28-29.2 and shortly after we’ll make 5.5.28-29.3 available …

I just realized that I didn’t hear a tremendous amount of feedback about Oracle’s MySQL Connect conference. Were you there? If so, how did you like it?

Further Reading:

• Schedule for MySQL-and-beyond conference is live
• I’m going to the upcoming MySQL Camp
• Why is MySQL more popular than PostgreSQL?
• Like it or not, it is the MySQL Conference and Expo
• …

Tungsten Replicator is a popular replacement for MySQL replication. It has now become a mature and robust product, with an easy-to-use installer. While installing a simple master/slave topology was made as easy as it could possibly be since version 2.0.3, installing complex topologies was still a matter for advanced users only.

Not any more! Continuent has released a package of cookbook

As a follow up to the previous post about logstash, here are a couple of related init scripts for anyone implementing the OpenSource Log Analytics setup that is explained over at divisionbyzero. These have been tested on CentOS 6.3 and are based on generic RC functions from Redhat so they will work with Redhat, CentOS, Fedora, Scientific Linux, etc.

• Init script for ElasticSearch: located in the repo by clicking here – servicewrapper required
• Init script for Kibana: …