Page: () 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 ... 71 ()

MySQL 5.7 -- Better performance, Stronger Security, But We May Break Some Things


MySQL is the popular and ubiquitous database at the core of may Moodle installation.  MySQL 5.6 has been our most popular release but 5.7 is on the way with improvements in security, performance, and manageability. You can now have a secure by default installation (no anonymous accounts or root accounts with no passwords), password rotation, and pluggable authentication. Tools like MySQL Fabric provide robust highly available server farms or the ability to shard without changing Moodle.  But with these changes there are some things, like a default SQL Mode of STRICT, that may break some tools (like Wordpress).  This session will cover the major changes in MySQL 5.7 and show you how to best use them to your advantage, work arounds for common upgrade issues, and show you where you might get into difficulty with the latest release.

Presented by...

Dave Stokes
MySQL Community Manager

Dave Stokes is a MySQL Community Manager for Oracle. Previously he was the MySQL Certification Manager for MySQL AB and SUN. He has worked for companies ranging alphabetically from the American Heart Association to Xerox and work ranging from Anti-submarine warfare to web developer


User account:
Dave Stokes
Last modified Wednesday, July 22, 2015, 1:14 PM
Presentation slides: PDF document MySQL5.7.pdf
Slides visiblity:
Your educational sector: Other
Roles in which you usually use Moodle: Systems Engineer
T-shirt: Mens - 2XL
Type of presentation: Demonstration / How-to (30 or 45 min)
Relevant to audience from which sectors: K-12
Workplace (Corporate, Govt.)
Armed Forces
Relevant to audience in which roles: Moodle Administrator
Systems Engineer
Course needed: No
Permission: I give permission for my photo, slides and recording to be published in relation to this presentation.
Committment: Should my proposed presentation be accepted, I commit to attend the MoodleMoot to present it.
Page: () 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 ... 71 ()