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

★★★★★
★★★★★

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From 18300AED

Private Remote

From 11700AED (3)

Public Classroom

Location Date Course Price [Remote/Classroom]
Dubai2019-02-13 09:30:0011700AED / 17600AED
Dubai2019-04-08 09:30:0011700AED / 17600AED
Dubai2019-05-29 09:30:0011700AED / 17600AED
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

CourseVenueCourse DateCourse Price [Remote / Classroom]
Transact SQL AdvancedDubaiWed, 2018-12-19 09:305792AED / 9842AED
Agile Software TestingBCB, DubaiWed, 2018-12-19 09:3011583AED / 17483AED
Introduction to Data Visualization with Tidyverse and RDubaiSun, 2019-02-03 09:306615AED / 10665AED
Marketing Analytics using RDubaiMon, 2019-03-04 09:3019845AED / 27595AED
Deep Learning for Finance (with Python)DubaiSun, 2019-06-16 09:3029400AED / 39000AED

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

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!