Loading video player...
Step-by-step guide for MySQL Monitoring using Prometheus + Grafana π§ β modeled after your PostgreSQL version and optimized for Ubuntu 24.04 LTS. It includes π― clear steps, π§© architecture, π» commands, π¨ alerts, and π§ practical examples! # π§ MySQL 8.x Monitoring Setup using Prometheus + Grafana on Ubuntu 24.04 LTS ## π§© Architecture Overview | Role π₯οΈ | IP π | Components βοΈ | | ------------------------ | ----------------- | ------------------------------- | | ποΈ MySQL Server | 192.168.136.128 | MySQL Database + MySQL Exporter | | π Monitoring Server | 192.168.136.129 | Prometheus + Grafana | Default Password: admin@123 # β Final Checklist | Component | Server | IP | Port | | -------------------- | ------- | --------------- | ---- | | ποΈ MySQL + Exporter | Server1 | 192.168.136.128 | 9104 | | π‘ Prometheus | Server2 | 192.168.136.129 | 9090 | | π Grafana | Server2 | 192.168.136.129 | 3000 | # π§ Final Architecture Diagram +------------------+ +------------------+ +------------------+ | ποΈ MySQL Server | --- | π‘ Prometheus | ---| π Grafana Dashboard | | 192.168.136.128 | | 192.168.136.129 | | 192.168.136.129 | | mysqld_exporter | | Metrics Scraper | | Visualization & Alerts | +------------------+ +------------------+ +------------------+ ## π End Result After setup, youβll get: β Real-time metrics (CPU %, RAM, I/O, TPS, Queries/sec) β Beautiful dashboards in Grafana πΌοΈ β Alerts on threshold breaches π¨ β Central monitoring hub for your MySQL servers πͺ -------------------------------------------------------------------- ## β οΈ Disclaimer / ΰ€ ΰ€Έΰ₯ΰ€΅ΰ₯ΰ€ΰ€°ΰ€£ 1οΈβ£ All trademarks, logos, and names belong to their respective owners. 2οΈβ£ This video is made only for educational & informational purposes under Fair Use (Section 107, Copyright Act 1976). 3οΈβ£ No copyright infringement intended. 4οΈβ£ For any copyright concerns, email π© inchirags@gmail.com β action will be taken promptly. ## π Social Links π₯ YouTube: https://www.youtube.com/@ChiragTutorial π· Instagram: https://www.instagram.com/chirag_._mahto πΌ LinkedIn: https://linkedin.com/in/chittrmahto π Facebook: https://www.facebook.com/chittrmahto π¬ WhatsApp Channel: https://whatsapp.com/channel/0029VbBgm16002T93KB16U12 π¬ Telegram Channel: https://t.me/+GAATbmOU4z1mMDY9 π Note: Follow the process exactly as shown in the video. πΎ DM me for paid PDF/Document β π© inchirags@gmail.com β¨ Share this tutorial with your friends & colleagues! π¬ Drop your questions in the YouTube comments β Iβll reply personally. π Subscribe for FREE tutorial and Certification Tutorials! π₯ Donβt forget to π LIKE, π SHARE, π COMMENT, & π SUBSCRIBE to @ChiragTutorial π― Thanks & Regards, π« Chitt Ranjan Mahto β βCHIRAGβ π« π https://www.chirags.in #chiragtutorial #chirag #chittranjanmahto #chiragmahto #mysqlmonitoring #prometheusgrafana #mysqldashboard #mysqlperformance #mysqltutorial #mysqlsetup #prometheussetup #grafanasetup #mysqlgrafana #mysqlha #devopstutorial