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 [...]

Darpan Dinker (VP of Engineering at Schooner) presented a talk on "MySQL Replication Pros-Cons: Which replication mechanism to choose and why" at Percona Live conference last week. The presentation focused on

• Achieving Higher Performance
• Uptime
• Reliability
• And Simplicity for Real-World Use Cases. 

Presentation slides can be viewed in the link below
http://www.slideshare.net/darpandinker/schoonersql-perconalive2012

Today I tried to make incremental backups of a MariaDB instance in a MySQL sandbox with Percona XtraBackup.
I used the recently released XtraBackup 2.0. And of course there is documentation about making incremental backups. 

MySQL sandbox makes it easy to run many different MySQL versions on one machine. It does this by changing the port number, data directory, UNIX socket location and a whole lot more.

So I first started with a full backup and after that I used that backup as a base for the incremental backups. To do that I had to specify the port number which is 5522 and the username and password for the msandbox account. As MySQL uses a UNIX socket instead …

There is a nice demo of  MySQL Bug 13510739 on Eric Romang's blog

I've published this blog to make this content available on planet.mysql.com.

[...] comparison apparently has approach and design flaws, [...]

[...] A comparison of Redis, Memcached, Tokyo Tyrant, and MySQL can be found here: http://www.ruturaj.net/redis-memcached-tokyo-tyrant-and-mysql-comparision/ [...]

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. …

The MySQL UC this past week was the best in years.   Percona did an outstanding job of organizing the main Percona Live event that ran Tuesday through Thursday.  About 1000 people attended, which is up from the 800 or so at the O'Reilly-run conference in 2011.  There were also excellent follow-on events on Friday for MariaDB/SkySQL, Drizzle, and Sphinx.

What made this conference different was the renewed energy around MySQL and the number of companies using it.  

1. Big web properties like Facebook, Twitter, Google, and Craigslist continue to anchor the …

It is the day after the conference ended and I feel great. Two days of percona live and a day of skysql, drizzle and sphynx presentations were just awesome. I can say that IMHO it is one of the best MySQL conferences since I started attending four years ago. Well done Percona.

There were some great tracks by very very smart people and I have started compiling my list of things to build/setup to make my own deployment better, faster and easier to manage. Full track list can be found: http://www.percona.com/live/mysql-conference-2012/

I should also thank SkySQL and MariaDB for the free days of sessions I attended yesterday, organized and delivered by these two community focussed companies.

This week, I had the pleasure of speaking at the Percona Live MySQL Conference & Expo. This was the first year it was not the O'Reilly MySQL Conference & Expo, and also the first time Oracle was not involved in any way. And what can I say, Terry Erisman and his team at Percona have put together an awe-inspiring conference.

read more