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

To obtain normalized queries you can use common MySQL monitoring tools like VividCortex, Monyog or PMM. It is also possible to use the MySQL general query log feature to capture raw queries and then normalize

To obtain normalized queries you can use common MySQL monitoring tools like VividCortex, Monyog or PMM. It is also possible to use the MySQL general query log feature to capture raw queries and then normalize

To obtain normalized queries you can use common MySQL monitoring tools like VividCortex, Monyog or PMM. It is also possible to use the MySQL general query log feature to capture raw queries and then normalize

To obtain normalized queries you can use common MySQL monitoring tools like VividCortex, Monyog or PMM. It is also possible to use the MySQL general query log feature to capture raw queries and then normalize

To obtain normalized queries you can use common MySQL monitoring tools like VividCortex, Monyog or PMM. It is also possible to use the MySQL general query log feature to capture raw queries and then normalize