課程簡介
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
客戶評論 (9)
培訓可以在您的工作中使用相關示例。
Aisha - Iziko Museums
Course - MySQL Database Administration
機器翻譯
我喜歡這個培訓,因為它是互動的
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
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Course - SQL in MySQL
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
根據我們的需求精心定製,對現場問題和情況反應迅速,給了我們很多重複所學內容的練習。
Colin - Drax
Course - MySQL Administration
機器翻譯
我真的很喜歡練習和理論與實踐之間的平衡
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
培訓師使課程互動的方式
Stefan - Verizon Connect
Course - MySQL Developer
機器翻譯