January 24, 2018

Education

Get trained by MySQL Experts

We are pioneers in delivering enterprise-class MySQL training services addressing architecture, internals, performance, scalability, reliability and high availability. We deliver training through GoToWebinar , Our trainers are experienced in delivering 100% hands-on workshops addressing real world challenges in MySQL, MariaDB and Percona Server database infrastructure operations.  Our workshop and topics are 100% vendor neutral so we create maximum value for our customers using MySQL, MariaDB and Percona Server .

MinervaSQL Advanced MySQL Operations and Troubleshooting

This workshop is definitely not for beginners but if you are already a MySQL DBA / Database Architect / Database Engineer / DBA Manager / Web-Scale Technical Architect / DevOps. Architect / CTO it will really benefit you in understanding and building an web-scale database application which will be optimal, scalable, highly available and reliable.  This will be 100% hands-on program with Q&A, You can re-run my scripts and demos to reproduce problems in your sandbox database. You can have any MySQL / MariaDB / Percona Server release installed for this workshop (but no more MySQL 5.1 please 😉). If you want print out of the PDF with slides please tell me in advance, I can ship that for you but you agree that you will not redistribute these documents to anyone else ! I request you to Download GotoWebinar software (to avoid the web-only version). Please confirm GotoWebinar is working on your computer. I will send you GotoWebinar link 2 days before seminar start, please attend seminar via the GotoWebinar link. Several people sharing the GotoWebinar link is not allowed, Each attendee must purchase a seat .

  • Presenter(s) – Shiv Iyer
  • Duration – 60 hours (15 half days / 4 hours daily)
  • Time – 0800 – 1200 PST
  • Fees – US $3,000.00
  • Multiple payment options available – wire / PayPal / cheque / cash
  • Confirm GoToWebinar is successfully installed and working on your computer

The schedule of every half-day is following (Pacific Time):

  • 08:00 – 09:30 – Session 1
  • 09:30 – 10:00 – Q&A + Break
  • 10:00 – 11:30 – Session 2
  • 11:30 – 12:00 – Q&A + extra demos

If some questions take longer to answer (with a demo), We may postpone these until the end of the day – to “extra demos” session.

In attending our classes, you agree to have read and understood these points:

  • All online training will be conducted online in a virtual class, delivered through Citrix’ gotowebinar.com service
  • The attendee is expected to have his/her own means of accessing the online virtual class
  • The training has been optimized for online delivery. Sufficient time is allotted for questions and answers.
  • Each attendee must purchase a seat – paying for one seat and having several people share the GotoWebinar session is not allowed.
  • Training handouts will be distributed in PDF format and in attending this training, you agree that you will not redistribute these handouts to anyone else.
  • You can cancel your attendance and get a full (100%) refund up to a week before the seminar starts, assuming that you haven’t requested & received previous training sessions videos. Note: Once any training material (PDFs or video recordings of previous sessions) are sent out to you, there is no refund.
  • Training recordings will be distributed as downloadable MP4 videos. Each attendee will get a version of digitally watermarked videos with his/her name on it. These videos are yours to keep, but you must agreeto not redistribute these videos to anyone else.
  • Neither MinervaSQL nor any of its trainers (Shiv Iyer) are liable for any damage caused, directly or indirectly, by following (or not following) the advice in the training material or advice given during the training sessions and any follow-ups. While we advise to only use known-to-be safe techniques and will warn you about any potentially-unsafe techniques, the ultimate responsibility of assessing risk and avoiding any damage to your IT systems always lies in you, the attendee.
  • Attendees can ask questions any time during the training (through the chat interface during the lecture and via a normal voice discussion during breaks and Q&A session).
  • For technical questions about the contents and delivery of the class, please send email to shiv@minervasql.com

Topics covered

  • MySQL and InnoDB internals – Troubleshooting MySQL and InnoDB for performance, scalability and reliability
    • Configuring MySQL system variables for performance and troubleshooting
    • Monitoring MySQL using status variables, Performance Schema and Percona Toolkit for performance and reliability
    • Monitoring InnoDB performance
    • Monitoring server logs
  • Performance benchmarking – Benchmarking infrastructure, Linux and MySQL for performance and scalability
    • MySQL benchmarking using Sysbench
    • MySQL load testing using mysqlslap
    • Interpreting benchmarking results to optimally size the MySQL infrastructure
    • Benchmarking MySQL infrastructure using Linux tools
    • Benchmarking MySQL Tables, Indexes and SQL
  • Capacity planning and sizing – Sizing CPU, memory and storage for performance, scalability and reliability
    • Sizing Linux for MySQL performance
    • Configuring My.CNF for performance, scalability and reliability
    • Archiving MySQL data optimally
    • Sizing MySQL Tables and Indexes
    • Sizing MySQL storage infrastructure
    • MySQL partitioning and archiving
    • Sizing MySQL / InnoDB / XtraDB memory structure for performance, scalability and reliability
  • MySQL performance health check, diagnostics and forensics – Proactive performance audit and health check 
    • Monitoring MySQL performance using open / free and proprietary solutions
    • Trending MySQL performance
    • Monitoring and trending application performance
    • Monitoring and interpreting MySQL server logs
    • Using Performance Schema for MySQL performance audit
    • Profiling MySQL
  • Interpreting MySQL performance matrices using Performance Schema
    • Performance Schema architecture and internals
    • Configuring Performance Schema for monitoring MySQL performance
    • Performance Schema objects
    • Useful Performance Schema scripts
    • Troubleshooting MySQL performance using Performance Schema
    • How best you can use SYS schema for MySQL troubleshooting
  • Troubleshooting MySQL performance using Percona Toolkit
    • Installing and configuring Percona Toolkit
    • MySQL DBA activities using Percona Toolkit
    • MySQL performance monitoring using “SLOW_QUERY_LOG” with “PT-QUERY-DIGEST”
    • Monitoring MySQL performance using Percona Toolkit
    • Archiving MySQL data using Percona Toolkit
    • Troubleshooting MySQL Replication using Percona Toolkit
  • MYSQL performance optimization – Full-stack (infrastructure and application)MySQL optimization
    • Tuning My.CNF for performance
    • Optimizing MySQL connection handling and threads
    • Optimizing MySQL application
    • Partitioning MySQL for performance
    • Optimal indexing for MySQL performance
    • Optimizing MySQL Disk I/O for performance
    • Building MySQL replication for performance
  • SQL tuning – SQL optimization on response time and index efficiency
    • Application / SQL forensics in MySQL
    • Profiling SQL for performance in MySQL
    • Optimal indexing and troubleshooting index operations
    • Using slow-query-log for MySQL performance audit and diagnostics (PT-QUERY-DIGEST)
    • SQL best practices for MySQL performance
  • Disk I/O tuning – Optimizing storage for faster SELECT, INSERT, UPDATE and DELETE
    • Architecting MySQL physical architecture
    • Monitor and measure MySQL disk performance
    • Disk I/O performance bottlenecks
    • Best practices for high performance MySQL disk I/O
    • Troubleshooting disk I/O performance in MySQL replication
  • Data archiving and partitioning – Data life cycle management, Partition and archive data for growth
    • Data Life Cycle Management in MySQL
    • Partitioning MySQL for performance and scalability
    • Archiving MySQL data for performance and reliability
  • Scale-out and replication – Scaling MySQL horizontally for performance and reliability
    • MySQL replication architecture and solutions
    • MySQL Synchronous replication
    • MySQL Asynchronous replication
    • MySQL Semi-synchronous replication
    • MySQL multi-source replication
    • MySQL Group Replication
    • MySQL Group Replication troubleshooting
    • MySQL sharding solutions
    • Troubleshooting MySQL replication
  • MySQL clustering solutions
    • MySQL Cluster deployment, configuration and operations
    • InnoDB Cluster deployment, configuration, operations and troubleshooting
    • Percona XtraDB Cluster deployment, operations and troubleshooting
    • MariaDB MaxScale installation, configuration and troubleshooting
    • Galera Cluster deployment and troubleshooting
    • Building clustering solution using DRBD – Pacemaker – COROSYNC – HEARTBEAT
  • High availability and site reliability engineering – Building highly available and reliable MySQL infrastructure operations
    • MySQL high availability solutions
    • MySQL cross-DC replication solutions for high availability and reliability
    • Self-healing MySQL infrastructure operations
    • MySQL auto-failover solutions
    • Building High Availability solution using Percona XtraDB Cluster
    • Building High Availability solution using MariaDB MaxScale
    • Load balancing MySQL using MySQL Router / HAProxy / ProxySQL
    • Building MySQL High Availability solutions using DRBD – Pacemaker – COROSYNC – HEARTBEAT
  • Disaster recovery and SRE
    • MySQL logical backup
    • MySQL Dumper
    • Percona XtraBackup
    • MariaDB Backup
    • MySQL backup to the cloud
    • MySQL SRE
  • Database security
    • MySQL user access control and password management
    • MySQL audit and privacy management
    • Building and operating firewall for MySQL
  • Database upgrades
    • MySQL upgrades and migration
    • Troubleshooting MySQL upgrades and migration

Technology focus – Vendor neutral and independent

  • Linux – Ubuntu, CentOS, Red Hat Linux and Oracle Linux
  • MySQL GA
  • MySQL Enterprise
  • MariaDB
  • MariaDB MaxScale
  • Percona Server
  • Percona XtraDB Cluster
  • MySQL NDB Cluster
  • InnoDB / XtraDB
  • TokuDB
  • MyRocks
  • RocksDB
  • Galera Cluster
  • MHA (Master High Availability Manager and tools for MySQL)
  • Continuent Tungsten
  • HAProxy
  • ProxySQL
  • MySQL Router
  • DRBD – Pacemaker – COROSYNC – HEARTBEAT
  • MySQL Logical Backup, MySQL Enterprise Backup, MySQLDumper, Percona XtraBackup and MariaDB Backup

To register for “MinervaSQL Advanced MySQL Operations and Troubleshooting” workshop please book for an appointment here or send email to contact@minervasql.com