without looking at MySQL Jean- Franois Gagn (System Engineer) - PowerPoint PPT Presentation

Oct 20, 2022 •672 likes •953 views

Monitoring B.com without looking at MySQL Jean- Franois Gagn (System Engineer) jeanfrancois.gagne@booking.com Booking.com Based in Amsterdam since 1996 Online Hotel and Accommodation (Travel) Agent (OTA): +1.220.000 properties in

Monitoring B.com without looking at MySQL Jean- François Gagné (System Engineer) jeanfrancois.gagne@booking.com
Booking.com ● Based in Amsterdam since 1996 ● Online Hotel and Accommodation (Travel) Agent (OTA): ● +1.220.000 properties in 227 countries ● +1.200.000 room nights reserved daily ● +40 languages (website and customer service) ● +13.000 people working in 187 offices worldwide ● Part of the Priceline Group ● And we use MySQL: ● Thousands (1000s) of servers, ~90% replicating 2
Yearly Cycle
Anomalies
Want to know more… ● We are hiring ! ● MySQL Engineer / DBA ● System Administrator ● System Engineer ● Site Reliability Engineer ● Developer / Designer ● Technical Team Lead ● Product Owner ● Data Scientist ● And many more… ● https://workingatbooking.com/
Other Booking.com talks ● MySQL Parallel Replication: all the 5.7 (and some of the 8.0) details ● Jean- François Gagné - 27 April - 11:00 AM @ Room 210 ● How B.com Avoids and Deals with MySQL/MariaDB Replication Lag ● Eric Herman - 27 April - 12:50 PM @ Ballroom E 26
Thanks Jean- François Gagné jeanfrancois.gagne@booking.com

Download Presentation

Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

MySQL Replication Update MySQL 5.5 (GA) & MySQL 5.6.2 (Dev. Milestone) Lars Thalmann

<Insert Picture Here> MySQL Replication Update MySQL 5.5 (GA) & MySQL 5.6.2 (Dev. Milestone) Lars Thalmann Development Director MySQL Replication, Backup & Connectors O'Reilly MySQL Users Conference, April 2011 MySQL Releases

456 views • 42 slides

MySQL Proxy Making MySQL more flexible Jan Kneschke jan@mysql.com MySQL Proxy proxy-servers

MySQL Proxy Making MySQL more flexible Jan Kneschke jan@mysql.com MySQL Proxy proxy-servers forward requests to backends and can transform, handle or block them released under the GPL see http://forge.mysql.com/wiki/MySQL_Proxy

945 views • 27 slides

PHP and MySQL Dr. E. Benoist Winter Term 2006-2007 PHP and MySQL 1 PHP and MySQL Introduction

Berner Fachhochschule - HTI PHP and MySQL Dr. E. Benoist Winter Term 2006-2007 PHP and MySQL 1 PHP and MySQL Introduction Basics of MySQL Create a Table See the content of a DB Tables: Change rows and Insert data Select

637 views • 53 slides

MySQL Proxy meets: binlogs Jan Kneschke MySQL Enterprise Tools mailto: jan@mysql.com What is

MySQL Proxy meets: binlogs Jan Kneschke MySQL Enterprise Tools mailto: jan@mysql.com What is MySQL Proxy Started Feb 2007 Current: MySQL Proxy 0.7.0 Source available on launchpad.net $ bzr branch lp:mysql-proxy Foundation of

308 views • 17 slides

MySQL Group Replication & MySQL InnoDB Cluster Production Ready? Kenny Gryp MySQL Practice

MySQL Group Replication & MySQL InnoDB Cluster Production Ready? Kenny Gryp MySQL Practice Manager Table of Contents Group Replication MySQL Shell (AdminAPI) MySQL Group Replication MySQL Router Best Practices Limitations Production?

993 views • 72 slides

Forecasting MySQL Scalability Baron Schwartz O'Reilly MySQL Conference & Expo 2011

Forecasting MySQL Scalability Baron Schwartz O'Reilly MySQL Conference & Expo 2011 Consulting Support Training Development For MySQL Percona Server Replaces MySQL Faster Queries More Consistent More Measurable More

670 views • 41 slides

PHP + MySQL MySQL on the command line is great and all well not its not really that great

PHP + MySQL MySQL on the command line is great and all well not its not really that great Using MySQL in PHP is somewhat similar to the command line: Set up a connection to a MySQL database Issue a bunch of commands to the

944 views • 43 slides

SQL & MySQL Jeff Siarto - TC 361 Whats the Difference? MySQL is a database SQL is

SQL & MySQL Jeff Siarto - TC 361 Whats the Difference? MySQL is a database SQL is a language to interact with the database SQL is used with other databases: Access, Oracle, Portage SQL, MS SQL, etc... MySQL Open source

391 views • 7 slides

Percona MySQL About Me Qunar.com DB Director

Percona MySQL About Me Qunar.com DB Director MySQL Inception MySQL ACMUG Oracle MySQL ACE Director What do we need to do for MySQL in

320 views • 20 slides

MySQL Cluster und MySQL Proxy Alles Online Diese Slides gibt es auch unter:

MySQL Cluster und MySQL Proxy Alles Online Diese Slides gibt es auch unter: http://rt.fm/s4p Agenda (Don't) Panic Web- und MySQL-Server MySQL Master-Master Cluster MySQL Proxy und Cluster MySQL

1.83k views • 31 slides

More on gdb for MySQL DBAs or Using gdb to study MySQL internals and as a last resort Valerii

More on gdb for MySQL DBAs or Using gdb to study MySQL internals and as a last resort Valerii Kravchuk, MySQL Support Engineer vkravchuk@gmail.com Who am I? Valerii (aka Valeriy ) Kravchuk : MySQL Support Engineer in MySQL AB, Sun and

376 views • 20 slides

Reducing Risk When Upgrading Your MySQL Environment Kenny Gryp MySQL Practice Manager My

Reducing Risk When Upgrading Your MySQL Environment Kenny Gryp MySQL Practice Manager My Experience as MySQL Consultant On Upgrading MySQL it's quite complex... Kenny Gryp MySQL Practice Manager Table of Contents The Ocial Documentation

1.13k views • 77 slides

MySQL X Protocol Talking to MySQL Directly over the Wire Simon J Mudd

MySQL X Protocol Talking to MySQL Directly over the Wire Simon J Mudd <simon.mudd@booking.com> Percona Live Europe Amsterdam 5 th October 2016 Content What is MySQL X protocol How does it work Building Drivers

793 views • 60 slides

Geographic Features in MySQL Tibor Korocz Percona What do I try to answer today? - Can MySQL

Geographic Features in MySQL Tibor Korocz Percona What do I try to answer today? - Can MySQL 8 help us with the common usecases? - Distance Calculation. - What is near by me? - Does MySQL 8 give us better options/solutions for these

1.14k views • 52 slides

Performance Guide for MySQL Cluster Mikael Ronstrm, Ph.D Senior MySQL Architect Sun

Performance Guide for MySQL Cluster Mikael Ronstrm, Ph.D Senior MySQL Architect Sun Microsystems MySQL Cluster Application Application Application MySQL Client MySQL Client MySQL Client Application Application MySQL MySQL MySQL

737 views • 50 slides

MySQL @Twitter: No More Forkin - Migrating to MySQL Community Version Twitter, Inc. MySQL

Twitter, Inc. MySQL @Twitter: No More Forkin - Migrating to MySQL Community Version Twitter, Inc. MySQL @Twitter Background Migration Process Migration Challenges Post-Deployment Challenges Future Plans Q&A

703 views • 44 slides

Power Recall (or learn) that Power is a measure of: _____________________________________

1 2 Power Recall (or learn) that Power is a measure of: _____________________________________ EE 109 Unit 10 - Pulse Width In an electronic circuit, P = ______________ Power = Current & Voltage (each may be ______________

831 views • 4 slides

Intro slides from Emily C G As C O V I D - 1 9 Methodology and P U L S E S U RV E Y S

Intro slides from Emily C G As C O V I D - 1 9 Methodology and P U L S E S U RV E Y S sample Methodology and sample Results collected between Consumer survey ran bi-weekly 04.07.20 16.08.20 Results collected: w/c 13th July,

455 views • 43 slides

Structure testing and RF tests stands Jan Kovermann CERN On behalf of the CLIC structure test

Structure testing and RF tests stands Jan Kovermann CERN On behalf of the CLIC structure test team Layout of the CERN x-band test stand (X-box 1) Clockwise from top-left: Modulator Pulse compressor DUT + connections

310 views • 16 slides

2018 National Small Business Compliance Pulse Survey: Small Businesses Weigh In on Top Employment

2018 National Small Business Compliance Pulse Survey: Small Businesses Weigh In on Top Employment Law Concerns and Challenges July 2018 Jaime Lizotte Carl Hendrickson HR Solutions Manager, President, ComplyRight, Inc. Market Measurement,

615 views • 36 slides

M u l t i - C h a n n e l N o i s e / E c h o R e d u c t i o n i

M u l t i - C h a n n e l N o i s e / E c h o R e d u c t i o n i n P u l s e A u d i o o n E m b e d d e d L i n u x K a r l F r e i b e r g e r , S t e f a n H u b

384 views • 15 slides

Microsystems D i g i t i z i n g Yo u r W o r l d S e a m l e s s l y ADCs for Autonomous

Seamless Microsystems D i g i t i z i n g Yo u r W o r l d S e a m l e s s l y ADCs for Autonomous Driving Augustine Kuo VP Engineering Seamless Microsystems Seamless Microsystems Background LiDAR and RADAR in Wireless and Consumer cars

423 views • 20 slides

The new NIST reference for Randomness Beacons Lu s Brand ao Joint work with: John

The new NIST reference for Randomness Beacons Lu s Brand ao Joint work with: John Kelsey, Ren e Peralta, Harold Booth National Institute of Standards and Technology (Gaithersburg MD, USA) 1 1 1 1 0 1 1 0 1 1 0 1 0 0 0

1.42k views • 121 slides

THE MAGNETIC HEARTBEAT OF THE SUN Diagnosing Pulses in the Solar MgII Index Using Wavelet

THE MAGNETIC HEARTBEAT OF THE SUN Diagnosing Pulses in the Solar MgII Index Using Wavelet Analysis Lindsay Rand Carleton College Northfield, MN Odele Coddington and Martin Snow Laboratory of Atmospheric Space Physics Boulder, CO Solar

503 views • 25 slides