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
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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
