The following presentation was given at the Oracle Technology Network (OTN) Latin America 2015 tour events in Uruguay, Argentina, Chile and Peru.
In this presentation I talk about the various versions and means of installing and upgrading MySQL including:
- MySQL version history from 3.23 to 5.7.8
- Historical installation options
- Recommended use of Oracle yum repository for current version
- The installation and upgrade process, and errors that occur
- Compatibility changes between MySQL 5.5 and MySQL 5.6 including
- Reserved words (and their true impact)
- Legacy TIMESTAMP usage
- FULLTEXT indexes
- The query optimizer
- Clear text password warnings and security improvements
- Important configuration differences
- Other recommendations
- The use of replication