FAULT TOLERANCE WITH PROXYSQL, MRM AND CONSUL ABOUT ME NARCS - - PowerPoint PPT Presentation

▶

Sep 23, 2023 360 likes •543 views

SLIDE 1

FAULT TOLERANCE

WITH PROXYSQL, MRM AND CONSUL

SLIDE 2

ABOUT ME

NARCÍS PILLAO

Systems Engineer letgo.com | edreams.com | palominodb | emagister.com

SLIDE 3

BEHIND THE SCENES

75M Downloads | 200M listings | 3B chats in 2,5 years !

SLIDE 4

AGENDA

Motivations
Describe the components
Architecture
Demo
Q/A

SLIDE 5

MOTIVATIONS

SLIDE 6

MOTIVATIONS

Automatic and repeatable process to reduce

downtime when the master goes down

Query digest
Filter unexpected queries as ORM nightmares
Auto scalable design thanks to Consul and Puppet
Choose open source and emerging solutions

SLIDE 7

DESCRIBING THE COMPONENTS

SLIDE 8

REPLICATION MANAGER (MRM)

Open source solution (MySQL, Percona and MariaDB)
Manual or automatic failover options
Topology: Master and many slaves (ignore server
ption)
Multiple MRM nodes managed by arbitrator
ProxySQL integration ( just released )
GH: https://github.com/signal18/replication-manager

SLIDE 9

PROXYSQL

Query digest
Query filtering
Query rewrite
Query routing
Maintenance operations
https://github.com/sysown/proxysql

SLIDE 10

CONSUL

Service discovery tool
Maintenance action feature
Introduce new ProxySQL nodes via its DNS
Monitoring checks

SLIDE 11

ARCHITECTURE

SLIDE 12

Replication Manager

SLIDE 13

ARCHITECTURE

SLIDE 14

ProxySQL and Consul

SLIDE 15

ARCHITECTURE

SLIDE 16

DEMO

https://github.com/narcisbcn/fault_tolerant_db

SLIDE 17

QUESTIONS?

SLIDE 18

THANK YOU !

Github: narcisbcn Twitter: @narcisbcn