You are already familiar with MySQL and MariaDB databases and are now facing the challenge of running a no-nonsense MySQL database. Then this is the right course for you.
 

O-MySQLADV

Duration

5 days

target group

  • MySQL application developers
  • MySQL and MariaDB database administrators
  • System administrators responsible for databases

contents

Running MySQL and MariaDB (1 Day)

  • Installation and Configuration
  • Backup and Restore Using mysqldump and xtrabackup
  • Point-in-Time Recovery (PiTR)
  • Security

MySQL and MariaDB High Availability (2 Days)

  • Overview of the MySQL Architecture
  • MySQL Architectures
  • Master/Slave Replication
  • Master/Master Replication
  • Virtual IP
  • Read/Write Distribution
  • Active/Active Clustering with Galera Cluster
  • Load Balancing

MySQL und MariaDB Performance Tuning (2 Days)

  • General Performance Issues
  • Hardware and Performance
  • Operating System (Linux)
  • MySQL Database Configuration (my.cnf)
  • Schema Tuning
  • Indexing
  • SQL Query Tuning
  • Profiling

Requirements

You know the basics of MySQL and have already gained initial experience with MySQL and MariaDB. SQL is no longer a closed book for you. You are also familiar with the Linux console and master the main UNIX commands.

TRAINING PROGRAM:

fromdual_training_modules

PlaceDateLanguageprice 
Zürich / CH
27.11. - 01.12.2017
DE4.450,00 CHF
Frankfurt / DE
27.11. - 01.12.2017
DE2.450,00 EUR
Inhouse on demand!inquiry
  •    Guaranteed to take place
  •    The course will definitely take place if you make a booking
  •    There are no free places left on this course. If you still book it, we will place you on the waiting list.

  • This course is held in another country. Due to the different tax conditions, you will have to book it in a separate booking process. We apologize for any inconvenience.
back to trainings
0 items in cart

Request an inhouse training

Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

  • Solution Manager Trivadis Training
  • Phone: +49 89 9927 5931
  • Email: bernd.roessler@trivadis.com
  • “I'll be glad to advise you on topics such as individual coaching, workshops, project support, and online training courses.”

    Your Bernd Rössler

Arrange a training consultation now