Prerequisites

Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands.

Audience

• Cloud Administrators
• Database Administrators
• Database Designers
• Web Administrators

Topics

• Install and configure MySQL Server on AWS EC2
  • Installation of MySQL 5.7 25 minutes
  • Upgrade MySQL on Running servers
  • Tips to Upgrade and what you should know before upgrade to major/minor version
• key components of the MySQL architecture
  • Explain how MySQL processes, stores, and transmits data
  • view/Manage Connected users
  • view system database objects (schema, tables, view, storage procedures, users, etc)
• Manage user accounts and secure your server
  • Create and manage users and roles
  • MySQL Basic security best practices
  • Protect your data from common security risks
• Configuration Best practices
  • Overview of MySQL log files (error log, slow query, general query)
  • MySQL Key Variables overview for performance improvement
• Query optimizations
  • Identify and optimize poorly performing queries
  • Troubleshoot server slowdowns and other common problems
• Transaction and locking
  • Understand Transaction Isolation levels
  • Overview of table and row level locking
  • Overview of Deadlock and how to prevent
• Backup and recover MySQL database
  • Physical Backup Method
  • logical Backup Method
  • Point in Time Recovery Techniques
• Simple High Availability and scalability solutions
  • Configure Simple Master/Slave replication
  • Configure Master/Master replication
• Advance High Availability and scalability Solutions
  • Configure and Administer InnoDB Cluster
  • Configure and Administer NDB Cluster
  • Configure and Administer Galera Cluster
  • Configure Load Balancer (MySQL Router, HA Proxy, Proxy SQL)
• Security
  • Authentication plugins (native, sha256, ldap)
  • Auditing and regulatory compliance log
  • Table Encryption
  • Disk level encryption at rest
  • MySQL secure connection encryption
  • Percona Xtrabackup encryption

Registration

No registration Needed – It’s Free

Location

Online on https://mikaelhoundegnon.wordpress.com/mysql-trainings/

Schedule

TBD