Bonus: Using PMM for ClickHouse Monitoring • docker run -d -p 9116:9116 f1yegor/clickhouse-exporter -scrape_uri=http://myhost:8123/ • pmm-admin config –server pmm.your-domain.com • pmm-admin add linux:metrics linux:metrics • pmm-admin add external:service clickhouse --interval 10s --service-port=9116 © 2018 Percona. 40 Use Advanced Data Exploration Dashboard © 2018 Percona. 41 Import Grafana Dashboard

Built-in Failover © 2018 Percona. 37 Advanced MySQL Replication Topologies © 2018 Percona. 38 PMM Dashboard for Replication © 2018 Percona. 39 MySQL Group Replication © 2018 Percona. 40 MySQL 7 Performance Improvements http://bit.ly/2qGCr0T and http://bit.ly/2pzvAIW © 2018 Percona. 46 PMM Dashboard for PXC © 2018 Percona. 47 MySQL Cluster Mostly In Memory Storage Synchronous Replication PXC node 1 PXC node 2 PXC node 3 5 7 ProxySQL ProxySQL ProxySQL © 2018 Percona. 58 ProxySQL at PMM © 2018 Percona. 59 Cloud Only Options •Amazon RDS •Amazon Aurora •Google Cloud SQL •Azure Database