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
Installing and starting Percona XtraDB Cluster
Testimonials (9)
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database Administration
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
The trainer explained everything with a lot o detail, and it was always engaging us.
Florian Lipianu - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Database Administration
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
Was well organized Instructor ability to explain concepts, in a manner that is easy to understand
Oana Bunea - SERVICIUL DE TELECOMUNICATII SPECIALE
Course - MariaDB Galera Cluster Administration
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin - Drax
Course - MySQL Administration
I really like the Exercises and balance between theory and practice
Damian Kajewski - Glosel Sp. z o. o. Sp. k.
Course - Advanced MariaDB for High Availability and Performance
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Course - Python in Data Science
The quality of training and wealth of experience !