Sharding a database

Philadelphia.pm, NY.pm, AmsterdamX.pm

20 minutes

Beginner

English 

When an organization grows, the database(s) it may reach a point
where it will be reaching one or more of its resource limits. Action
will be needed, and one of the solutions is to use a sharded setup;
that is, having several databases with identical structure, and
data residing in one (or subset) of the databases.

At Booking.com, we have several sharded databases. In this talk,
we will look how we transformed a highly volatile database to a
sharded setup, without its users noticing and how Perl helped us
to achieve this. 

Attended by:
Aaron Crane (‎arc‎)
Iaroslav Poliakov
Tina Müller (‎tinita‎)
Victor Normal User For Tests
Tom Hukins
Curtis Poe (‎Ovid‎)
Jose Luis Perez Diez (‎jluis‎)
Patrick Mevzek
Lee Johnson
Vidar Tyldum (‎tyldum‎)
Jason Clifford
Ali Zia
Gabor Szabo (‎szabgab‎)
Anthony Lucas (‎hor|zon‎)
osfameron
Jose Luis Martinez Torres (‎JLMARTIN‎)
Kerstin Puschke (‎titanoboa‎)
Laurent Dami (‎dami‎)
Marco Pessotto (‎melmothx‎)
H. Daniel Cesario (‎dcesario‎)
Victor Manuel Rivas Santos (‎Victor‎)
Michael Kröll (‎pepl‎)
Radyslav Liaskovskyi (‎Radislav‎)
Bartosz Jakubski (‎migo‎)
Martin Kjeldsen (‎baest‎)
Michael Jemmeson (‎michael‎)
Ivan Dmitriev
Andreea Hosu (‎Andreea‎)
Matt Koscica (‎atomicstack‎)
FErki
Choroba
Lars Thegler (‎tagg‎)
Andrew Solomon (‎illy‎)
Todd Rinaldo (‎toddr‎)
Rish
Stephen Hall (‎predix‎)
Tudor Constantin
Anatoly Grishaev
Oriol Soriano Vila (‎Uree‎)
Paolo Sinigaglia (‎psini‎)
Michał Kotuła
István Almási (‎ialmasi‎)
Dmitry Karasik (‎McFist‎)
Olivier Duclos (‎odc‎)
Mike Chamberlain
Michal Jurosz (‎mj41‎)
Bart Wiegmans (‎brrt‎)
Kenta Sato (‎karupanerura‎)
Roland Schmitz (‎roli‎)
Michael Scoltock (‎mscolly‎)
Alberto Simões (‎ambs‎)
James E Keenan (‎kid51‎)
Mateu Hunter (‎mateu‎)
Cal
Nicoleta Maniu
Eleatzar Colomer (‎eleatzar‎)
Anca Davidel
Maria Hedberg
Dave Sherohman (‎dsheroh‎)
Alex Fernandez (‎alexfdz‎)
Stevan Little (‎stevan‎)
Nicholas Clark
Ivan Kruglov
Brian Kelly
Rui Patinha (‎rfp‎)
John Lightsey (‎J.D.‎)
Jason Carty
Jason Tang (‎jason‎)
Nigel Gregoire
Nikolaos-Digenis Karagiannis (‎Digenis‎)
Pavel Scherbinin (‎Dzirtik‎)
Alberte Thegler
Plesco Natalia (‎natasha‎)
Mike Eve
Jean Forget
Jussi Kinnula (‎Spot‎)
Anatoliy Dmytriyev (‎tolid‎)
Mihai Pop
Mark Nettlingham
Joeri de Bruin (‎dapperedodo‎)
Martin Cermak
Nuno Carvalho (‎smash‎)
Michal Josef Špaček (‎skim‎)
Jozef Kutej (‎jozef‎)