Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Percona Server Installation
- Choosing version
- Downloading installer (YUM, RPM)
- Installation on Linux machine
Percona Server Files and Scripts
- Percona/MySQL Programs
- Percona Server
- Percona Client
- GUI Tools
Percona Server Configuration
- The Server SQL Mode
- Server System Variables
- Dynamic System Variables
- Server Status Variables
- Shutdown Process
Percona Security Issues
- Securing Percona Server Against Attacks
- Security-Related Options
- Security Issues with LOAD DATA LOCAL
Percona Access Privilege System
- Percona Privilege System Overview
- Privileges Provided by Percona
- Connecting to the Percona Server - Stages
- Access Control, Stage 1: Connection Verification
- Access Control, Stage 2: Request Verification
- Access Denied Errors
Percona User Account Management
- Users and Passwords
- Creating New Users
- Deleting User Accounts
- Limiting User Resources
- Changing Passwords
Percona Database Maintenance
- Backup and Recovery – dump vs. XtraBackup
- Point-in-Time Recovery
- Maintenance and Crash Recovery
- Getting Table Information
Percona Log Files
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 Query Cache with SELECT
- Configuring Query Cache
- Checking Query Cache Status and Maintenance
Installing and starting Percona XtraDB Cluster
Testimonials
all topics are interesting
- Stolt Tankers BV
The exercises done during the training.
Melvin Joseph Manalo - Stolt Tankers BV
The training exceeded my expectations on what I was hoping to learn.
Ian Matthews - Cision
Partea de exercitii ne-a ajutat sa aprofundam mai lectiile prezentate.
Dragos - Tudor Constantin, Siemens
Mi-a placut ca s-a bazat pe partea practica si au fost date toate detaliile si explicatiile necesare .
Alixandru Ionut - Tudor Constantin, Siemens
Mi-a placut foarte mult ca a fost un curs aplicat cu foarte multe exemple si exercitii. A fost un curs interactiv fara prea multa teorie ceea pentru mine a fost perfect.
Vlad - Tudor Constantin, Siemens
Disponibilitatea trainerului de a explica si a clarifica toate informatiile prezentate
Tudor Constantin, Siemens
the practical nature of it
Anca Daescu, Ness
it was an excelent opportunity to add knowledges and to strenghten the old ones.
Titus - Anca Daescu, Ness
the training pace, the patience, the structured information, the logical flow of the training, the breaks (just right), checking each time for any questions/concerns. Extremely p[professional.
Mihai - Anca Daescu, Ness
the fact that he explained step by step how he thought about the method used to write the query
Vasile - Anca Daescu, Ness
the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers
Angela - Anca Daescu, Ness
The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.
Matei - Anca Daescu, Ness
tonality, rhythm, good structure
Mihalache Dana - Anca Daescu, Ness
He was very friendly and he created a very good environment.
- European Commision, Joint Research Centre
Jochen ! He was great ! . Upbeat, able to divert on to another subject, and very knowledgeable indeed.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
I liked the pace of the excercises. They were first explained and then we could do them ourselves. I liked the fact that the trainer would wait for everyone before moving on to the next subject. I also liked the way he explained every question we had, going into detail and even modifying the course documentation to better suit our needs.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
The trainer explained everything with a lot o detail, and it was always engaging us.
Florian Lipianu - Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
It was structured very well and documented information. I really liked the trainer enthusiasm.
Oana Bunea - Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
The style of the trainee!
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
A lot of practical examples.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
A lot of practical examples.
Stefan Turcu - Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
knowledge of the trainer
mohamed labib - Mahmoud Abdallah Mohamed Hussein, e-finance
Still didn't finished the content
Mahmoud Abdallah Mohamed Hussein, e-finance
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
I like the way it combined the theorethical parts with the excercises. I also appreciated the extra explanations and the way the trainer answered our questions.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
Johan, is the best trainer I met till now.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
The interactive way to apply what we just learned.
Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
Was well organized Instructor ability to explain concepts, in a manner that is easy to understand
Oana Bunea - Popa Ionut-Claudiu, SERVICIUL DE TELECOMUNICATII SPECIALE
les explications
daniel Moroani - Cyrille Manente , Direction Générale de la Gendarmerie Nationale
- précision des scripts et documents
Cyrille Manente , Direction Générale de la Gendarmerie Nationale
Was carefully tailored to our needs, very responsive to live questions and situations, gave us lots of practice repeating what we were learning.
Colin Walker - PM Renke, Drax
Thought the labs worked really well
PM Renke, Draxpower
all exercise
Palawan Pawnshop - Palawan Express Pera Padala
Hands-on exercises
Palawan Pawnshop - Palawan Express Pera Padala
Small, highly focused group allowed us all to stay involved directly with the instructor the whole time which becomes less tenable as group size grows.
Leading Edge Marketing Inc
I mostly enjoyed the knowledge about replication database.
Suparman - Universitas Terbuka
The trainer has extensive knowledge of IT.
Iwan Susanto - Universitas Terbuka
Trainer was accommodative. And actually quite encouraging for me to take up the course.
Grace Goh - DBS Bank Ltd
Related Courses
MySQL Database Administration
14 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
MariaDB Database Administration
14 hours
SQL in MySQL
14 hours
MySQL Administration
28 hours
MySQL / Galera
21 hours
ProxySQL
14 hours
Python in Data Science
35 hours
MySQL Developer
21 hours