Tag: Percona Server

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

Duration

7 hours (usually 1 day including breaks)

Requirements

Working knowledge of MongoDB

Overview

Percona Server for MongoDB is a free, enhanced, fully compatible, open source, drop-in replacement for MongoDB 3.2 Community Edition with enterprise-grade features. It requires no changes to MongoDB applications or code.

Audience

This course is suitable for sysadmins and engineers seeking to switch to Percona Server from preexisting MongoDB instances, or deploy and administrate new Percona Server for MongoDB instances.

After completing this course, delegates will:

• understand Percona Server’s structure and deployment mechanisms
• be able to carry out installation / production environment / architecture tasks and configuration
• be able to assess code quality, perform debugging, monitoring
• be able to implement advanced production like replication, performance tuning and logging

Course Outline

Getting Started

• Installing Percona Server for MongoDB

Percona FT Storage Engine

• Switching Storage Engines
• Configuring PerconaFT

External Authentication

• Overview
• External Authentication Commands
• Environment Setup and Configuration

Percona TokuBackup

• Architectural Overview
• Making a Backup
• Checking Backup Progress
• Controlling Backup Rate
• Restoring From Backup
• Creating New Replicas
• Sharding

Auditing