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
Version selection
- 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
Percona Access Privilege access system
- Permissions overview Percona Server
- Permissions Provided by Percona
- Connecting to the server Percona - steps
- Access control, Stage 1: Connection verification
- Access control, Stage 2: Request verification
- Reasons for rejecting calls
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
- BinaryLog
- Slow Query Log
- Log File Maintenance and Rotation
Percona Query Cache
- The concept of query cache
- Testing the query cache using SELECT
- Configuring the query cache
- Checking the buffer status
Installation and launch of the Percona XtraDB Cluster
14 Hours
Testimonials (5)
The training can use relevant examples in your work.
Aisha - Iziko Museums
Course - MySQL 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 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 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
Exercises, balance between theory and practice