The next keynote is from Marten Mickos, now with Eucalyptus systems, previously CEO of MySQL AB. He talked about making LAMP a Cloud. No surprises there: Eucalyptus is the leading open-source cloud computing platforms for on-premise use.

We were treated with a brief history of MySQL, the first MySQL conference in 2003, Eucalyptus, and how the two tie together. It is true that MySQL has been the most common database platform in the cloud. Certainly, the other big databases are lagging when it comes to adoption and deployment in the cloud. One comment from Marten that resonates with us at Pythian and others in the MySQL services business – Oracle definitely needs to build out the partner ecosystem around MySQL.

There were some good insights from Marten on how the database and software paradigm has evolved from scale-up to scale-out, from closed-source to open-source, and from distributions to “Stacks” (eg LAMP) to APIs and …

The second day of the Percona Live MySQL Conference and Expo is off to a great start! We’re excited here in Santa Clara to share the news that we’re teaming up with hastexo to further enhance expert high-availability knowledge for our professional services customers.

This means hastexo will assist in the development and improvement of Enterprise HA for MySQL® and MariaDB®, while customers of the product can tap into hastexo’s expertise and development of the Linux high availability stack for MariaDB and MySQL database support.

Teaming up with hastexo enables us to continue to deliver rock-solid high availability solutions for the MariaDB and MySQL databases. Just for you.

hastexo’s high availability expertise is accessible to SkySQL Enterprise HA customers today.

We will be onsite at the …

A key feature of our new TokuDB v6.0 release, which I have been blogging about this week, is compression. Compression is always on in TokuDB, and the compression we’ve achieved in the past has been quite good. See a previous post on the 18x compression achieved by TokuDB v5.0 on one benchmark. In our latest release, we’ve updated the way compression works and got 50% improvement on compression.

I decided to present numbers on the same set of data as the old post, so see that post for experimental details.

But first, what are the changes? TokuDB compresses large blocks of data — on the order of MB, rather than the 16KB that InnoDB uses — …

Here it is finally: The MySQL conference 2012 starts with the Keynote Sessions.

The first keynote speech was by Peter Zaitsev, founder of Percona and a very smart guy, and by Baron Schwartz (Percona), another very smart guy, the brain behind a number of toolkits for MySQL. They’re talking about the MySQL Evolution – what I alluded to in my first post regarding this conference – the ways in which MySQL has grown, evolved, scaled and continues to make new inroads into new applications and industries.

From Peter: “What is most important hasn’t changed – MySQL is still a great piece of technology and it is evolving very rapidly.” (Love that quote!) Also “MySQL is also buzzword compatible: NoSQL, BigData.”

From Baron: He talked about his own personal journey from closed-source, proprietory to open-source, and the …

Wednesday, April 11Building a Multi-master, Multi-region Database Infrastructure in Amazon EC2 by Edward Archibald, 11:00 am -11:50 am in Ballroom HBe a Data Management Hero with Good Backups! by Robert Hodges, 1:00 pm - 1:50 pm in Ballroom DOne to Many: The Story of Sharding at Box by Tamar Bercovici and Florian Jourda, 1:00 pm - 1:50 pm in Ballroom GBuild simple and complex replication clusters

With all of the new news coming out right now, it can be easy to miss or overlook some of the new features.

While there’s been a lot of talk about MySQL 5.6 Replication, I specifically wanted to mention the new ‘mysqlfailover’ and ‘mysqlrpladmin’ utilities.

These are two new MySQL replication utilities (results of the new Global Transaction Identifiers (GTIDs) in MySQL 5.6).

Let me quote the MySQL 5.6 Replication article for both of these utilities:

mysqlfailover

“Provides continuous monitoring of the replication topology, enabling failover to a slave in the event of an outage on the master.

The default behavior is to promote the most up-to-date slave, based on …

It is that time of the year, again: Percona Live is the name of this years MySQL conference in the Santa Clara Hyatt Regency.

Booking.com is there, and we are hiring, looking specifically for Admins and DBAs, but we also have Developer positions open.

Meet Nicolai and Sheila at the booth, if you have any questions.

Whilst I am not a fan of Juniper Network Connect in the last few years I have had to connect to several networks that use it.  The biggest problem with it is that it is a combination of Java and a 32bit C library which will not work when executed with a 64bit version of Java.
There are other ways of connecting such as the Mad Scientist script but if you use things like two-factor authentication this will not work.  So I brought together things I have learnt from web postings about getting it to work in Ubuntu and have created these steps.  They work in Fedora 17 and should work in 16 too:
Step 1We need to install OpenJDK Java, we also need xterm for the root password during installation:

sudo yum install java-1.7.0-openjdk.i686 java-1.7.0-openjdk.x86_64 icedtea-web xterm

Step 2Now we need to tell Java to execute the Juniper …

I must admint I was greatly impressed by the Oracle activity on MySQL yesterday. I cannot say I didn’t see it was coming, but most certainly the magnitude of what happened, the flood of announcements, was a bit overwhelming. Looking at the list of improvements, I started wondering what can it actually mean to the MySQL ecosystem.

Several years ago MySQL was forked into several different projects driven by groups of passionates as well as commercial businesses. Many considered the pace of MySQL evolution to be insufficient, while some didn’t agree with the direction or was complaining on the quality.

These were not unfounded. Rather than on the software itself, MySQL AB was focusing more on preparing itself for public offering, which eventually didn’t happen. It sold out to Sun. However, instead of …

Note: this article was originally published on http://blogs.innodb.com on April 11, 2012 by Vasil Dimov.

After introducing InnoDB persistent statistics in MySQL 5.6, in this April Labs release we have dressed it up in a nice UI and refactored the internals a bit to make the code more elegant and straight-forward.

The persistent stats are now controlled globally and can also be overridden at table level, should any table require a different behavior.

Global

The server global flag –innodb-stats-persistent (boolean) now controls whether all InnoDB tables use persistent statistics or not. Keep in mind that if a table is using persistent stats then its statistics will not be updated automatically and you are responsible for …