In this penultimate episode, we talk about what's coming in MySQL 5.7 and MariaDB 10.1. Ear Candy is about a new MySQL 5.7 utility to generate the SSL RSA keys to encrypt MySQL communications, and At the Movies is about MySQL's new features.
MySQL 5.7 in a nutshell
Text Parser Plugins - how fulltext parsing works for MyISAM and InnoDB and when you want to avoid the default fulltext plugin.
Writing Full-Text Parser Plugins
Copying File-Per-Table Tablespaces to Another Server - make sure to read this to learn how to transport InnoDB tablespaces between servers of the same version.
innodb_fill_factor - defines the % of space that each index page will will with data during a sorted index build (creating or rebuilding an index).
generated columns - defined by an expression calculated on the fly.
Table and Tablespace Encryption in MariaDB
Roles in MariaDB - version 10.1 allows a user to have a default role.
SYSTEM_VARIABLES table in INFORMATION_SCHEMA - metadata and help text about system variables
At the movies
In this episode's At the Movies, we present Celebrating MySQL by Oracle's Thomas Ulin. This video from last week's Percona Live conference gives an update of new features in MySQL 5.7 and the new labs versions.
On to Where You Can See Us
Where you can see us
Sheeri will be at the Boston MySQL User Group, which meets the 2nd Monday of the month at MIT in Cambridge.