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 (9)
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
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
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 !