Percona Server for MySQL Training Course

Course Code

prcmysql

Duration

14 hours (usually 2 days including breaks)

Overview

Percona Server for MySQL is optimized for cloud computing, NoSQL access, containers and modern hardware such as SSD and Flash storage.

  • Cloud ready
    Dramatically reduces downtime on servers with slow disks and large memory, such as 4XL EC2 servers on EBS volumes

  • SaaS deployable
    Increases flexibility for architectures such as co-located databases with hundreds of thousands of tables and heterogeneous backup and retention policies

  • Vertical scalability and server consolidation
    Scales to over 48 CPU cores, with the ability to achieve hundreds of thousands of I/O operations per second on high-end solid-state hardware

  • Query, object and user level instrumentation
    Detailed query logging with per-query statistics about locking, I/O, and query plan, as well as performance and access counters per-table, per-index, per-user, and per-host

  • Enterprise ready
    Percona Server for MySQL includes advanced, full-enabled external authentication, audit logging and threadpool scalability features that are only available in Oracle’s commercial MySQL Enterprise Edition

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

★★★★★
★★★★★

Related Categories

Some of our clients

is growing fast!

We are looking to expand our presence in the UAE!

As a Business Development Manager you will:

  • expand business in the UAE
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!