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