Pythian Group

Log Buffer Editions are marching along, and this Log Buffer #268 is once again all about Oracle, MySQL, and SQLServer plus some peeks at some of other glittering database technologies like PostgreSQL and DB2. Sit back and enjoy.

Read the rest of this entry . . .

The journey to the Hotel in Santa Clara took me something like 16 hours. It was long, arduous and at times despairing, but was it worth it? Absolutely! I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our Pythian MySQL team; Marco Tusa, Raj Thukral, and Singer Wang. We all ran into former colleagues at the conference, caught up with old friends and made some new friends. The conference this year was buzzing with enthusiasm, learning, and creativity. I’m delighted to say it delivered everything I anticipated and more.
Read the rest of this entry . . .

Read the rest of this entry . . .

Day 1 is the fist official day of the Percona Live MySQL Conference; the day began with two mini-keynotes by Peter Zaitev and Baron Schwarz of Percona talking about the history of MySQL and how he got started in the open source movement respectively. Very nostalgic and I’m sure it brought a tear to a few people’s eyes.

Following the dynamic duo was full keynotes by followed by Mårten Mickos (Eucalyptus Systems) speaking on “Making LAMP a Cloud” and Brian Aker (HP) on “The New MySQL Cloud Ecosystem”. To be honest I found the full keynotes to be quite disappointing. For me the keynotes speeches should be about a topic that is visionary or notable in some way. What I got from the keynotes were:  MySQL is good, MySQL is growing, let me show you my product around MySQL, and buy/use my product. For me, they felt far more like glorified sales pitches. Remember back to the last conference I attended, SXSW Interactive, the keynotes by Ray Kurzweil and Jennifer Pahlka were about their vision of the future and the innovative work they have done respectively. Kurzweil spoke on how technology will enable us to expand our intelligence without limits and achieve digital immortality. Pahlka’s work on the non-profit Code For America, similar to the Peace Corps or Teach for America, brings technology innovators employing opens source, crowd source, and other technologies to promote openness, participation, and efficiency in municipal governments
Read the rest of this entry . . .

MySQL Cluster Performance Tuning

——————————————-

In this session we will look at different tuning aspects of MySQL Cluster.

As well as going through performance tuning basics in MySQL Cluster, we will look closely at the new parameters and status variables of MySQL Cluster 7.2 to determine issues with e.g disk data performance and query (join) performance.

This was the last session I attend, and for me is alway a great pleasure to be at Johan presentations, two reasons from many:

- he is probably the best cluster expert (in service delivery)

- he knows a lot of distinctiveness and insight that no one else knows

————————————————————————–
Read the rest of this entry . . .

Using and benchmarking Galera in different architectures

———————————————————-

What I was interested most during the second day was again, synchronous replication and Replication solutions provide from Continuent.

The first I attend in the day was the Galera one, done Henrik and Alexey.

The presentation was going to talk about:

“We will present results from benchmarking a MySQL Galera cluster under various workloads and also compare them to how other MySQL high-availability approaches perform. We will also go through the different ways you can setup Galera, some of its architectures are unique among MySQL clustering solutions.
Read the rest of this entry . . .

Boost Your Replication Throughput with Parallel Apply, Prefetch, and Batching

——————————————————

Slave lag is the bane master/slave replication. This talk will explain why slave lag occurs and show you three important ways that Tungsten Replicator can banish it for MySQL slaves. Parallel apply uses multiple threads to execute slave transactions. Prefetch uses parallel threads to read ahead of the slave position and fetch pages that will be needed by the slave. Batching uses CSV files to load row updates in extremely large transactions that bypass SQL completely. We will explain each technique, show you how to use it, and provide performance numbers that illustrate the gain you can expect. We will round the talk out with a discussion of non-Tungsten tools that offer similar benefits. With these techniques in hand, you’ll be well-prepared to attack any replication performance problem.

The talk taken by Robert Hodges with Stephane Giron, was as expected very interesting, and give to the audience a good insight abut how to implement Replicator efficiently.
Read the rest of this entry . . .

It seems like yesterday that the blogs appeared. Over the years they have proved to be of much value for the technical and not-so-technical masses. The big boom in this social media outlet has enabled unprecedented sharing of ideas for the database professionals. The nature of databases and the blogging is to always be changing, but Log Buffer Edition stays, and here is the Log Buffer #267.

Read the rest of this entry . . .

In about 4 hours, at 2PM PDT, I’ll be giving my talk “Security Around MySQL” at Ballroom A at the Percona Live MySQL Conference 2012. It’s a summary and guide of practical and easy-to-implement security tips around MySQL and the application. These tips were all gleamed from my years at start-ups (some which I worked at and some which I founded) and from experience at Pythian.

The details are here:  http://www.percona.com/live/mysql-conference-2012/sessions/security-around-mysql.