Percona Server for MySQL Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best Other programming courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

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

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MySQL
  • Server
  • Access

Course programme

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

See related categories

Percona Server for MySQL Training Course

Price on request

The best Other programming courses

See all

See all