OurSQL Episode 26: Zombies!

This week, we revive the podcast and talk about MySQL 5.5 features.

We wondered: Is enterprise backup still using myisamhotcopy for myisam tables?

From MySQL Product Manager Mike Frank, who is in charge of MySQL Enterprise Backup:
"As of today, there is a new mysqlbackup.exe that replaces the perl script innobackup and the myisamhotcopy from InnoDB Hot Backup. This is needed so we can do proper streaming and other media manager integration. Perl doesn't lend itself to that and is a problem on Windows in general as well. We kept the arguments compatible so it is easy to move over and the innobackup perl script is still included -- only for the sake of making transition more seamless."

MySQL 5.5 release is GA - http://dev.mysql.com/tech-resources/interviews/thomas-ulin-mysql-55.html

InnoDB improvements
Multiple InnoDB buffer pools - http://dev.mysql.com/doc/innodb/1.1/en/innodb-multiple-buffer-pools.html

InnoDB I/O improvements (innodb_io_capacity, innodb_io_read_threads, innodb_io_write_threads) - http://dev.mysql.com/doc/refman/5.5/en/innodb-io-changes.html

InnoDB speed improvements due to mutex removals - part of Thomas Anderson‘s Oracle OpenWorld presentation “Performance and Scalability Enhancements in MySQL 5.5”. Slides can be downloaded from http://downloads.mysql.com/presentations/mysql-sunday/InnoDB_Enhancement...

InnoDB recovery improvements - These improvements fixed two existing issues. First, the issue of an available memory check eating up too much CPU during recovery and the second was algorithm changes to how InnoDB inserts into the flush_list during recovery (adding an additional datastruct during recovery). http://blogs.innodb.com/wp/2010/04/innodb-performance-recovery/

Replication improvements

Replication server filtering - IGNORE_SERVER_IDS=(123,456) in CHANGE MASTER - p10-12 of http://forge.mysql.com/w/images/2/2f/090507.NewReplicationFeatures.pdf

Semi-synchronous replication - http://dev.mysql.com/doc/refman/5.5/en/replication-semisync.html

Other MySQL 5.5 features/notes
Pluggable authentication - http://dev.mysql.com/doc/refman/5.5/en/pluggable-authentication.html

Proxy users (mostly used to give permissions to externally authorized users) - http://dev.mysql.com/doc/refman/5.5/en/proxy-users.html

Performance_schema - http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html

Partitioning improvements - http://dev.mysql.com/doc/refman/5.5/en/partitioning-columns.html

Individual log flushing - http://dev.mysql.com/doc/refman/5.5/en/flush.html

Audit plugin - http://dev.mysql.com/doc/refman/5.5/en/writing-audit-plugins.html - again, like external auth plugin, not too excited, let’s see what plugins ppl write first.

Deprecated things that are now removed - http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html#id2463830

Misc links
http://bit.ly/ey6F8C Boston MySQL User group Dec 12th 2010 presentation (video + slides) from Bill Papp about MySQL Cluster, including the new features in version 7.1

How to Upgrade to MySQL 5.5 by Gerry Narvaja - http://mmatemate.blogspot.com/2010/12/mysql-55-upgrading-from-previous.html

“All the things” cartoon - It’s called “This is Why I’ll Never Be an Adult” http://hyperboleandahalf.blogspot.com/2010/06/this-is-why-ill-never-be-a...

Send us feedback
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast