Training

Basics 105: Backup, Recovery and Provisioning Within Tungsten Clustering

Join us for this training session where we discuss tools for backing up MySQL databases within Tungsten Clustering, and how Tungsten Clustering makes it easy to reprovision databases and recover a cluster. This training is for all engineers using Tungsten Clustering and will explain the tools needed to create a sound backup and recovery strategy, and is also valuable for those who wish to review their current MySQL backup and MySQL recovery procedures.

View the Training Video Read the Training Slides

Agenda

  • Methods and tools for taking a MySQL backup from within a Tungsten cluster
    • mysqldump
    • xtrackbackup
    • Snapshots (lvm or other)
    • File copy
    • tungsten_provision_slave
  • Restoring a MySQL backup from within a Tungsten cluster
  • Verifying the backup contains the last binary log position, and the importance of having this
  • Restoring backups into a cluster
  • Provisioning slaves from an existing datasource

Presenter

Matthew Lang
Customer Success Director – Americas, Continuent

Matthew has over 25 years of experience in database administration, database programming, and system architecture, including the creation of a database replication product that is still in use today. He has designed highly available, scaleable systems that have allowed startups to quickly become enterprise organizations, utilizing a variety of technologies including open source projects, virtualization and cloud.

Interested in Tungsten Clustering? Get in Touch!

Please use the button below to contact our sales team, you will receive a reply within 24 hours.