際際滷

際際滷Share a Scribd company logo

Xtrabackup and FTWRL

Raghavendra Prabhu
Raghavendra Prabhu

The document discusses Xtrabackup and FTWRL (Flush Tables With Read Lock). It describes how Xtrabackup works by taking consistent backups without locking tables for long durations. It also explains how FTWRL is used to get a consistent snapshot of databases during backups and replication. The document notes that while locking has benefits, alternatives like no-lock backups are being explored to avoid issues with DDL statements and non-transactional operations during backups. It concludes by inviting questions from the audience.

1 of 7
Download to read offline
Xtrabackup and FTWRL Xtrabackup and FTWRL Percona Live MySQL Conference and Expo 2013 Raghavendra Prabhu raghavendra.prabhu@percona.com Percona 24th April, 2013 Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Outline Xtrabackup and FTWRL Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Xtrabackup What and Why How it works Others based on similar principle Comparison Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Locking FTWRL Nice Backronym of Flush Tables with Read Lock Duration: How it matters Necessity Why with InnoDB Replication co-ordinates Avoidable Galera Work in progress wsrep_recover Where is it used Backups PXC/Galera SST Anywhere you may want to Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Not Locking no-lock: In a world without doors, why you need locks Bene鍖ts Caveats DDL Non-transactional FRMs Redo-logging of ibd creation Only InnoDB Possible solutions MDL locking Consistent snapshots with Galera Bitmap based backups Transactional DDL in future? Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Conclusion Any questions Raghavendra Prabhu Percona Xtrabackup FTWRL
Xtrabackup and FTWRL Me Raghavendra Prabhu http://wnohang.net/about Software Engineer at Percona and Product Lead of PXC https://launchpad.net/percona-xtradb-cluster 際際滷s downloadable at http://goo.gl/jsult Raghavendra Prabhu Percona Xtrabackup FTWRL

More Related Content

Xtrabackup and FTWRL

  • 1. Xtrabackup and FTWRL Xtrabackup and FTWRL Percona Live MySQL Conference and Expo 2013 Raghavendra Prabhu raghavendra.prabhu@percona.com Percona 24th April, 2013 Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 2. Xtrabackup and FTWRL Outline Xtrabackup and FTWRL Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 3. Xtrabackup and FTWRL Xtrabackup What and Why How it works Others based on similar principle Comparison Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 4. Xtrabackup and FTWRL Locking FTWRL Nice Backronym of Flush Tables with Read Lock Duration: How it matters Necessity Why with InnoDB Replication co-ordinates Avoidable Galera Work in progress wsrep_recover Where is it used Backups PXC/Galera SST Anywhere you may want to Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 5. Xtrabackup and FTWRL Not Locking no-lock: In a world without doors, why you need locks Bene鍖ts Caveats DDL Non-transactional FRMs Redo-logging of ibd creation Only InnoDB Possible solutions MDL locking Consistent snapshots with Galera Bitmap based backups Transactional DDL in future? Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 6. Xtrabackup and FTWRL Conclusion Any questions Raghavendra Prabhu Percona Xtrabackup FTWRL
  • 7. Xtrabackup and FTWRL Me Raghavendra Prabhu http://wnohang.net/about Software Engineer at Percona and Product Lead of PXC https://launchpad.net/percona-xtradb-cluster 際際滷s downloadable at http://goo.gl/jsult Raghavendra Prabhu Percona Xtrabackup FTWRL