Course Outline
Percona/My server installationSQL
Version selection
- Installer download (YUM,RPM) Install on system Linux
Server files and scripts Percona
- Percona Programs / MySQL Percona Server Percona Client GUI Tools
Server Configuration Percona
- Server Mode SQL Server System Variables Dynamic System Variables Server Status Variables Shutdown process
Security Issues Percona Server
- Securing the server Percona against attacks Security related options Security considerations with LOAD DATA LOCAL
Percona Access Privilege system
- Privileges Overview Percona Server Privileges Provided by Percona Connecting to Server Percona - Steps Access Control, Step 1: Connection Verification Access Control, Step 2: Request Verification Reasons for Rejecting Connections
User account management Percona
- Users and passwords Creating new users Deleting user accounts Limiting user permissions Changing passwords
Database maintenance Percona
- Backup and Recovery - DUMP vs. XtraBackup Database replication Maintenance and troubleshooting Information about tables
Log Files Percona
Error Log
- General Query Log
- Update Log
- Binary Log
- Slow Query Log
- Log File Maintenance and Rotation
Percona Query Cache
- Query cache concept Testing the query cache with SELECT Configuring the query cache Checking cache status
Installation and start of the Percona XtraDB Cluster
Testimonials (8)
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
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
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL Database 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 !