LT: Xtrabackup and FTWRL

-
24 April 5:30pm - 8:30pm @ Community Networking Welcome Reception

Lightning Talk: This talk will ponder over implications of using Xtrabackup with FTWRL (Flush Tables With Read Lock). More importantly, it will discuss using --no-lock with it which obviates FTWRL. Not using the locking has its own caveats - no DDL and InnoDB only. The mechanism of backup without locking will also be discussed (in obtaining binlog co-ordinates through crash recovery). Possible solutions to the aforementioned caveats will also be considered.

Speakers

Raghavendra Prabhu
Software Engineer, Distributed Systems, Yelp, Yelp
Biography: 
Raghavendra Prabhu works as a Software Engineer in Distributed Systems team at Yelp. Prior to that he was the Product Lead of Galera-based Percona XtraDB Cluster (PXC) at Percona. He also works on Xtrabackup and Percona Server intermittently. He joined Percona in the fall of 2011. Before joining, he worked at Yahoo! SDC, Bangalore for 3 years as Systems Engineer, primarily dealing with databases (MySQL and Yahoo Sherpa/PNUTS) and configuration management. Raghavendra's main interests include databases, virtualization and containers, distributed systems, operating systems including linux kernel. He also likes to contribute and has contributed code upstream to several FOSS projects — for more details on that visit http://wnohang.net/code. In his spare time, he likes to read books, technical papers/literature, listen to music, hack on software, nature hiking, and exploring in general while on vacations. You may also often find him on IRC channels on freenode and/or oftc.

Slides