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.


Raghavendra Prabhu
Software Engineer, Distributed Systems, Yelp, Yelp
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 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. Speaking experience ============== He has spoken previously at PLMCE ('13, '14 and '15), FOSDEM ('13), LinuxConfAu ('14 and '15), Fossetcon ('14), ('14), Highload++ ('14) and SCALE 13x ('15). Slides (and details) can be reviewed at Previous recorded talks: ================== Playlist: Slides: Presented paper at IEEE conferences: ======================== i) SOMGPU: Self Organizing Maps on a Graphical Processing Unit for Pattern Classification: Published at IEEE Congress on Evolutionary Computation (CEC) which was part of IEEE World Congress on Computational Intelligence (WCCI) 2008. ii) GNeuron: Parallel Neural Networks with GPU: Presented at 14th International IEEE Conference on High Performance Computing (HiPC) 2007. Social/Contact: =========== Mail :, Twitter : randomsurfer Linkedin : Github : ronin13 Launchpad : raghavendra-prabhu : rdprabhu IRC : tlonim Blog : : Lanyrd : For more, you can contact him at GPG: D72BE977