Solving the Challenges of Big Databases with MySQL

When you’re using MySQL for big data (more than ten times as large as main memory), these challenges often arise: loading data fast; maintaining indexes under insertions deletions, and updates; adding and removing columns online; adding indexes online; preventing slave lag; and compressing data effectively.

This session shows why some of these challenges are difficult to solve with storage engines based on B-trees, how Fractal Tree® data structures work, and why they can help solve these problems. Tokutek sells a transaction-safe Fractal Tree storage engine for MySQL, but the presentation is primarily about the underlying technology. It includes a discussion of both the theoretical and practical aspects of Fractal Tree indexes.

I have the privilege of being able to give this talk at both conferences, so please stop by my presentation at …

On Friday last week, after the intensive days of the conference, Ars Technica wrote and published a nice article about MariaDB including many of the messages we had been delivering during the conference, http://arstechnica.com/business/news/2012/04/mysql-founders-latest-mariadb-release-takes-enterprise-features-open-source.ars.

MariaDB seals

Last year, when it became clear that O’Reilly wasn’t going to arrange the MySQL user conference in the future, there was a lot of discussion on who should arrange it. In the end Percona was pretty fast informing everyone that they had booked the convention center in Santa Clara to arrange the conference this year. Now with the …

The SkySQL booth ready for the stampede of visitors that stopped by each day.

We hope it was as productive and fun for all of you as it was for us at SkySQL! We started out the week at Percona Live, which was an excellent conference. Thanks to the Percona folks for making this a great get-together for the MySQL community. Excellent job, guys!

We welcomed two new partners, hastexo and PalominoDB, which means our customers will see even better MySQL service and support with SkySQL. And many of our current …

I wanted to extend thanks as others have also about the excellent annual MySQL Conference, now a Percona Live event. This was easily the best run, attended and energetic event in at least the past 3 years. With over a 1000 attendees a well stocked exhibitors hall (and good involvement in the hall), and good talks; there was just a great community vibe. To Terry, Kortney and all Percona staff involved, well done. The event ran on time, I personally did not see or hear of any issues. The only complaint was from many that wanted to attend multiple talks at the same time, another indication of the quality of speakers for the event.

Thank you to those that attended my two sessions on Explaining the MySQL Explain and MySQL Idiosyncrasies that BITE. …

Hi everybody,

I’m sure you’re all listening about what is happening at the MySQL annual conference (no ? really ?)
So, you can find bellow all the slides from the MySQL Conference & Expo 2012 :

Source : https://www.box.com/perconalive2012

Find some videos  : http://www.percona.tv/2012/04

Related Posts :

• My slides of MySQL Meetup Viadeo / LeMUG Paris
• [UPDATED] Why you should go to Percona Live (London) ?
• …

Master/slave replication is an important tool that gets used in many ways: distributing read loads among many slaves for performance, using a slave for backups so the master can handle live load, geographically distributed disaster recovery, etc. The Achilles’ Heal of slave performance is that slave workloads are single-threaded. The master can have many clients inserting, updating, querying, whereas the slave has only one insertion client: the master. InnoDB single-client performance is much slower than its multi-client performance, which means that the bottleneck in a master/slave system is often the rate at which a slave can keep up.

If the master has an average transactions per second (tps) that is higher than what the slave can handle, the slave will fall further and further behind. If the slaves are being used to distribute read workload, for example, the results they produce will fall further out of date. If a slave is used to …

PC World has written a post with this title(*) about the upcoming MySQL Connect conference and references the Percona Live conference and an official Percona comment. As this is not syndicated in Planet MySQL I encourage you to read the full article.

This is the MySQL conference to get technical presentations by the many great Oracle/MySQL technical staff who will not be in attendance at Percona Live. There will also be a strong community presence in speaking at Oracle Connect in September. While Oracle was organizing a dedicated MySQL event in April for the community with all vendors including Percona to replace the conference dropped by long term partner O’Reilly (kudos …

Great speaker line up at SkySQL & MariaDB: Solutions Day for the MySQL Database and Percona Live MySQL Conference & Expo

If you haven’t yet registeredfor next week’sSkySQL & MariaDB: Solutions Day for the MySQL Database, do it today so you don’t miss any of these important discussions about MariaDB, MySQL & related technologies:

• Opening keynote from Monty Widenius and David Axmark

• SkySQL, MySQL, MariaDB & the Cloud, withUlf Sandberg, Kaj Arnö, and Ivan Zoratti of SkySQL

• Automating master failover and …

Let’s be clear from the get-go: contrary to what this picture and the title of this post may suggest, we are not giving Oliver - SkySQL’s honorary mascot - away next week! He was very good, though, to pose for this picture to help us better illustrate the size of this inflatable seal! We’ll let your imagination decide what else this photo represents. Or better yet, join us in Santa Clara, next week, at what’s looking to be a pretty exciting gathering of MySQL-aficionados!

That’s right, the SkySQL & MariaDB: Solutions Day for the MySQL Database and Percona Live MySQL Conference & Expo events are just around the corner!

So what’s the deal with the Consulting Lounge?

Well, next Friday (April 13th), at the SkySQL and MariaDB …

I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will moderate the Diamond Keynote Panel entitled “Future Perfect: The Road Ahead for MySQL” which will feature a panel of MySQL industry leaders, including: Sundar Raghavan, director product management at Amazon; Paul Mikesell, CEO of Clustrix; a representative from HP; and, a representative from McAfee. The Diamond Sponsor Keynote Panel will take place at 9:30 a.m. on Thursday, April 12th and provide insight into the future of MySQL technology, adoption, and the ecosystem landscape. I am also very pleased to introduce two new sponsors including McAfee which recently joined as a Diamond Sponsor and AOL which …