Slide 1
Slide 1 text
MySQL as a Layered Service:
How to Use ProxySQL to
Control Traffic and Scale Out
René Cannaò
26th September 2017 - Dublin
Slide 2
Slide 2 text
2
Why?
• Performance
• Efficiency
• Manageability
• Usability
• Availability
Slide 3
Slide 3 text
3
Why?
Vendors create products more efficient and performing
New vendors, new storage engines, new algorithms
New features
Improved or new HA solutions
Slide 4
Slide 4 text
4
Something is missing
APPLICATIONS
DATABASES
Slide 5
Slide 5 text
Main motivations
empower the DBAs
Improves manageability
understand and improve performance
High performance and High Availability
create a proxy layer to shield the database
Slide 6
Slide 6 text
ProxySQL Features (short list)
High Availability and Scalability
seamless failover
firewall
query throttling
query timeout
query mirroring
runtime reconfiguration
Scheduler
Support for Galera/PXC and Group
Replication
on-the-fly rewrite of queries
caching reads outside the database
connection pooling and multiplexing
complex query routing and r/w split
load balancing
real time statistics
monitoring
Data masking
Multiple instances on same ports
Native Clustering
Slide 7
Slide 7 text
7
Database as a Service (layered)
APPLICATIONS
DATABASES + MANAGER(s)
DAAS – REVERSE PROXY
Slide 8
Slide 8 text
What ProxySQL is not?
It is not a replication manager
Slide 9
Slide 9 text
9
Database as a Service: not only MySQL
APPLICATIONS
MySQL
DAAS – REVERSE PROXY
ClickHouse SQLite ?? ??
Slide 10
Slide 10 text
Try it!
Source code on GitHub:
https://github.com/sysown/proxysql/
Forum:
https://groups.google.com/forum/#!forum/proxysql
Tutorials on:
http://www.proxysql.com
Slide 11
Slide 11 text
What is ProxySQL?
The MySQL data stargate