Course Outline

Percona/My server installationSQL

Version selection

  • Installer download (YUM,RPM) Install on system Linux

Server files and scripts Percona

  • Percona Programs / MySQL Percona Server Percona Client GUI Tools

Server Configuration Percona

  • Server Mode SQL Server System Variables Dynamic System Variables Server Status Variables Shutdown process

Security Issues Percona Server

  • Securing the server Percona against attacks Security related options Security considerations with LOAD DATA LOCAL

Percona Access Privilege system

  • Privileges Overview Percona Server Privileges Provided by Percona Connecting to Server Percona - Steps Access Control, Step 1: Connection Verification Access Control, Step 2: Request Verification Reasons for Rejecting Connections

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
  • Binary Log
  • Slow Query Log
  • Log File Maintenance and Rotation

Percona Query Cache

  • Query cache concept Testing the query cache with SELECT Configuring the query cache Checking cache status

Installation and start of the Percona XtraDB Cluster

  14 Hours
 

Testimonials (8)

Related Courses

Related Categories