|
This week, we continue our discussion about MySQL and its forks. We discuss the Percona server and MariaDB.
Percona Live comes to Washington, DC on Wednesday, January 11th, 2012 at the Walter E. Washington Convention Center. There is a 50% discount for students, faculty and staff of educational organizations, and a 35% discount for government employees. http://www.percona.com/live/dc-2012/
Percona Server
Percona software
This week we talk with Giuseppe Maxia (pronouncing his name correctly!) about new features in Tungsten replicator, and go over a lot of news.
News:
There was a lot of news this week! There were three really big announcements at Oracle OpenWorld that relate to the MySQL community:
Oracle released a NoSQL database. http://www.oracle.com/technetwork/database/nosqldb/overview/index.html
It’s an ACID-compliant key-value data store, with a Java API for put, delete and get operations and includes replication. The data partitioning and distribution is automatic and based on a hash function.
Percona Live MySQL Conference and Expo event page, and Baron's announcement of the conference.
Dates to keep in mind:
September 1st - call for speakers opens
November 1st - call for speakers closes
Tuesday April 10th - Thursday April 12th
This week we interview Doron Levari, CEO and co-founder of ScaleBase. ScaleBase transparently scales your database, so you can have many shards without having to code sharding in your application. The sharding is completely transparent to the application. This can be combined with regular replication to have automatic use of a standby if a shard's primary database fails.
This week we talk about what's new in MySQL 5.6 and the return of labs.mysql.com. We also feature people's reactions to the 5.6 announcement and a special song by Solomon Chang (lyrics below).
Show notes:
If you want to see it for youreslf, there is a video from the O'Reilly Conference of Tomas Ulin's Keynote, "State of the Dolphin".
Olav Sandstå's blog post on index condition pushdown optimization.
This week, Giuseppe Maxia joins us as a special guest and we complete our 2-part series on what we always put in our configuration files, and why.
Part 1 in the series.
strings man page
MySQL manual page about defaults-group-suffix
Giuseppe's article about the hidden options file trick
Logging:
log_error
Nick Pisarro, aka @highenergybeams, suggested we do a podcast about the MySQL defaults we recommend always having, as MySQL's pre-configured option files are not particularly helpful. So we have put together a 2-part podcast on the options that we change.
About the Configuration File
Location and precedence of configuration files for Windows, Unix and Mac OS X:
http://dev.mysql.com/doc/refman/5.5/en/option-files.html
Note: We use the term "directive" to refer to the groups of options that begin with [groupname]. Upon reading the manual page again, we realized that the term is actually "option group". (Sheeri takes complete blame for this -- "directive" is actually the term for what !includedir and !include are...)
Eric Day and Patrick Galbraith spoke on Drizzle, Gearman and Narada at the July 2009 Boston MySQL User Group. This is part 1 of the video, which is about an hour long and is about Drizzle.
"We will explain what the Drizzle project is, what we aim to accomplish, and an overview of where we are at."
The slides can be downloaded from http://www.oddments.org/notes/DrizzleGearmanBoston2009.pdf
The User Group calendar item for this event is http://www.meetup.com/mysqlbos/calendar/10607736/
Video for the presentation at the 2009 MySQL Camp:
Chasing Bottlenecks
by Morgan Tocker
Description:
The best way to performance tune a system is to find out what your bottlenecks are, and attacking those first. In the first part of this session, I'll be looking at some of the issues faced with common database workloads. From there, I'll then be showing how you can get more information out of MySQL and your Operating System to find out about your workload. This session is designed for beginner to intermediate MySQL users.
Giuseppe Maxia spoke at the May 2009 Boston MySQL User Group about MySQL 5.4 and what it can do, the new performance features, etc.
Video for the presentation at the 2009 MySQL Camp:
Top 10 MySQL Pet Peeves and How to Workaround Them
Jeremy Zawodny
Watch it online here:
Download the 106 Mb .mov file at <
Video for the presentation at the 2009 MySQL Conference:
Beginner's Guide to Website Performance with MySQL and memcached
Adam Donnison (Sun Microsystems)
The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7009
Video from the 2009 MySQL Conference presentation:
If You Love It, Break It: Testing MySQL with the Random Query Generator Philip Stoev (Sun Microsystems)
The description is at:
http://www.mysqlconf.com/mysql2009/public/schedule/detail/6363
Download the presentation slides (ppt).
Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.
The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.
From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:
We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.
Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.
The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.
From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:
We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.
At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.
The slides are available at http://www.technocation.org/files/doc/2009_01_Partitioning.pdf. The video is embedded at the bottom of this post, and is also available at youtube at http://www.youtube.com/watch?v=zvN9XI-FraI.