Search

Search

MySQL High Availability & Performance Tuning Best Practices

MySQL High Availability & Performance Tuning Best Practices

Main Speaker:


Haim Tzadok

Guest Speaker:

Tracks:

Data

Seminar Catgories:

Database Performance

Course ID:

18602

Date:

28.11.2018

Time:

Daily seminar
9:00-16:30

Add to Calendar 28.11.2018 09:00 28.11.2018 16:30 Asia/Jerusalem MySQL High Availability & Performance Tuning Best Practices

MySQL powers many of the world’s largest and fastest-growing organizations. Companies including Facebook, Google and Adobe rely on MySQL to save both time and money powering their high-volume websites, business-critical systems and packaged software.

In this seminar, you will learn practical, safe and efficient ways to optimize the MySQL database performance. Participants will gain tips and tricks and best practices to optimally architect the MySQL database, find bottlenecks and learn how to properly configure the database appropriately for achieving extreme performance results.

This seminar is intended for experienced MySQL database administrators who are looking to design and optimize a database server for maximum performance and scalability.

*The guest’s lecture will be conducted in English

 

Overview

MySQL powers many of the world’s largest and fastest-growing organizations. Companies including Facebook, Google and Adobe rely on MySQL to save both time and money powering their high-volume websites, business-critical systems and packaged software.

In this seminar, you will learn practical, safe and efficient ways to optimize the MySQL database performance. Participants will gain tips and tricks and best practices to optimally architect the MySQL database, find bottlenecks and learn how to properly configure the database appropriately for achieving extreme performance results.

This seminar is intended for experienced MySQL database administrators who are looking to design and optimize a database server for maximum performance and scalability.

*The guest’s lecture will be conducted in English

 

Course Contents

  • Speedy MySQL introduction
  • Performance Tuning Basics Terms
  • MySQL Thread Handling and Memory Usage
  • Basic Server Parameters – my.cnf file
  • InnoDB/Xtradb Storage Engine Tuning
  • Facebook MyRocks Engine
  • Schema Design Considerations and Performance – Indexes Data-Types and stored procedure
  • MySQL Queries Performance – the explain
  • The Performance Schema
  • Scaling horizontally and vertically – Sharding Replication and Partition
  • JSON and Document-store
  • MySQL Server Tuning
  • MySQL 8.0 New Features


Contact