Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Server installation Percona/MySQL
Select version
- Downloading the installer (YUM,RPM)
- Installation in the system Linux
Server files and scripts Percona
- Programs Percona / MySQL
- Server Percona
- Customer Percona
- GUI Tools
Server configuration Percona
- Server mode SQL
- Server System Variables
- Dynamic system variables
- Server Status Variables
- Closing process
Security Issues Percona Server
- Securing the server Percona against attacks
- Security Options
- Security Issues with LOAD DATA LOCAL
Access system for Percona Access Privilege
- Permissions Overview Percona Server
- Powers Provided by Percona
- Connecting to server Percona - steps
- Access Control, Step 1: Connection Verification
- Access Control, Step 2: Request Verification
- Reasons for rejecting calls
User Account Management Percona
- Users and passwords
- Creating new users
- Deleting user accounts
- Restricting user permissions
- Changing passwords
Database maintenance Percona
- Backup and Recovery - DUMP vs. XtraBackup
- Database replication
- Maintenance and troubleshooting
- Table Information
Log Files Percona
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 the Query Cache with SELECT
- Configuring the query cache
- Checking buffer status
Installing and running the XtraDB Percona Cluster
14 Hours
Testimonials (5)
The quality of training and wealth of experience !
Edvin - Verizon Connect
Course - MySQL Developer
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
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 course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
exercise: setting up HAProxy for load balancing Galera cluster lecture: certification based replication
