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

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

Securing customer data (PII) in MySQL Alexander Rubin VirtualHealth PRIVILEGED + CONFIDENTIAL

Securing customer data (PII) in MySQL Alexander Rubin VirtualHealth PRIVILEGED + CONFIDENTIAL About me Working with MySQL for 10-15 years Started at MySQL AB 2006 Sun Microsystems, Oracle (MySQL Consulting) Percona since 2014

1.13k views • 44 slides

Why MySQL Replication Fails, and How to Get it Back September, 26, 2017 Sveta Smirnova Sveta

Why MySQL Replication Fails, and How to Get it Back September, 26, 2017 Sveta Smirnova Sveta Smirnova MySQL Support engineer Author of MySQL Troubleshooting JSON UDF functions FILTER clause for MySQL Speaker Percona

1.4k views • 139 slides

Managing MySQL at Scale Pradeep Nayak & Junyi (Luke) Lu Production Engineers - MySQL Infra

Managing MySQL at Scale Pradeep Nayak & Junyi (Luke) Lu Production Engineers - MySQL Infra Agenda 1 Terminology 2 Lifecycle of a MySQL instance 3 How do we migrate MySQL instance 4 How do we migrate shard 5 Balancing 6 Testing

919 views • 50 slides

An API for Reading the MySQL Binary Log Lars Thalmann Mats Kindahl Development Director, MySQL

<Insert Picture Here> An API for Reading the MySQL Binary Log Lars Thalmann Mats Kindahl Development Director, MySQL Lead Software Engineer, MySQL Replication, Backup & Connectors Replication & Utilities The following is

459 views • 42 slides

Deploying MySQL and MongoDB in Kubernetes Alexander Rubin Percona About me Working with

Deploying MySQL and MongoDB in Kubernetes Alexander Rubin Percona About me Working with MySQL for 10-15 years Started at MySQL AB, Sun Microsystems, Oracle (MySQL Consulting) Joined Percona in 2013 2 What is Kubernetes?

734 views • 60 slides

MariaDB MySQL Corrected Michael Monty Widenius About Monty Original author of MySQL

MariaDB MySQL Corrected Michael Monty Widenius About Monty Original author of MySQL Co-Founder of MySQL Ab (with David Axmark and Allan Larsson) Founder of Monty Program Ab Swedish-Finn Purveyor of salmiakkikossu and

707 views • 32 slides

Feed me more: MySQL Memory analysed FOSDEM MySQL Devroom 2013 Raghavendra Prabhu

Introduction MySQL - Buffers and storage engines OS/Tools/Instrumentation Solutions Cases / Examples Future Conclusion Feed me more: MySQL Memory analysed FOSDEM MySQL Devroom 2013 Raghavendra Prabhu raghavendra.prabhu@percona.com Percona

492 views • 20 slides

The M in LAMP: MySQL CSCI 470: Web Science Keith Vertanen Overview MySQL Setup, using

The M in LAMP: MySQL CSCI 470: Web Science Keith Vertanen Overview MySQL Setup, using console Data types Creating users, databases and tables SQL queries INSERT, SELECT, DELETE, WHERE, ORDER BY, GROUP BY, LIKE, LIMIT,

381 views • 22 slides