Duration
14 hours (usually 2 days including breaks)
Overview
Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.
- Cloud ready
Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes - SaaS deployable
Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies - Vertical scalability and server consolidation
Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware - Query, object and user level instrumentation
Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host - Enterprise ready
Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition
Course Outline
Percona Server Installation
- Choosing version
- Downloading installer (YUM, RPM)
- Installation on Linux machine
Percona Server Files and Scripts
- Percona/MySQL Programs
- Percona Server
- Percona Client
- GUI Tools
Percona Server Configuration
- The Server SQL Mode
- Server System Variables
- Dynamic System Variables
- Server Status Variables
- Shutdown Process
Percona Security Issues
- Securing Percona Server Against Attacks
- Security-Related Options
- Security Issues with LOAD DATA LOCAL
Percona Access Privilege System
- Percona Privilege System Overview
- Privileges Provided by Percona
- Connecting to the Percona Server – Stages
- Access Control, Stage 1: Connection Verification
- Access Control, Stage 2: Request Verification
- Access Denied Errors
Percona User Account Management
- Users and Passwords
- Creating New Users
- Deleting User Accounts
- Limiting User Resources
- Changing Passwords
Percona Database Maintenance
- Backup and Recovery – dump vs. XtraBackup
- Point-in-Time Recovery
- Maintenance and Crash Recovery
- Getting Table Information
Percona Log Files
Error Log
- General Query Log
- Update Log
- Binary Log
- Slow Query Log
- Log File Maintenance and Rotation
Percona Query Cache
- The Concept of Query Cache
- Testing Query Cache with SELECT
- Configuring Query Cache
- Checking Query Cache Status and Maintenance