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
Product Lead, Percona XtraDB Cluster, Percona
Biography: 
Raghavendra Prabhu is 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. Speaking experience ============== He has spoken previously at PLMCE ('13 and '14), FOSDEM ('13), LinuxConfAu ('14), Fossetcon ('14), RICON.io ('14) and Highload++ ('14). Slides (and details) can be reviewed at http://www.slideshare.net/slidunder. Previous recorded talks: ================== LinuxConfAu 2014: https://www.youtube.com/watch?v=YSFLMtXpBn8 https://www.youtube.com/watch?v=GJJo9kO3CiQ RICON.io 2014: https://www.youtube.com/watch?v=xRD6A8TY_Uw 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. http://dx.doi.org/10.1109/CEC.2008.4630920 ii) GNeuron: Parallel Neural Networks with GPU: Presented at 14th International IEEE Conference on High Performance Computing (HiPC) 2007. http://hipc.org/hipc2007/posters/GNeuron.pdf Social/Contact: =========== Mail : raghavendra.prabhu@percona.com, raghavendra.d.prabhu@gmail.com Twitter : randomsurfer Linkedin : linkedin.com/in/rdprabhu Github : ronin13 Launchpad : raghavendra-prabhu Keybase.io : rdprabhu IRC : tlonim Blog : https://blog.wnohang.net About.me : http://about.me/raghavendra.prabhu Lanyrd : http://lanyrd.com/profile/raghavendraprabhu For more, you can contact him at http://wnohang.net/contact. GPG: D72BE977

Slides