← Back to all posts

How to Gain a Bird's-Eye View of Stressing Issues Across 100s of MySQL DB Instances

April 11, 2024
•
Rapydo HQ

When scaling databases in the cloud, using native tools provided by cloud vendors often makes it challenging to obtain a comprehensive view of the stress points affecting our databases in a unified manner, as these tools are specifically designed for single database instances

‍

Products like RDS Performance Insights are typically centered on a particular database. They provide a detailed analysis of performance metrics, but when attempting to obtain a broader overview and highlight critical issues, these tools fall short.

‍

Rapydo Scout offers a unique perspective by enabling visibility into both your managed and unmanaged databases through a single interface, allowing you to delve into the most pressing performance issues across your database fleet.

Rapydo Scout Master Dashboard

‍

‍

‍

  1. Queries View: This section displays highlights of your queries across multiple databases. You gain top insights & drill down into significant aspects such as:
  • Locks: Achieve visibility into all transaction/metadata locks across your databases, providing a detailed understanding of each instance:
This grid shows a detailed description of each lock, and what is the impact on other waiting queries
This grid shows a detailed description of each lock, and what is the impact on other waiting queries
These are more columns in the same locks grid.
These are more columns in the same locks grid.
Continued
Continued
  • Slowest Queries: Identify the slowest queries across all your databases, noting the DB Identifier Column:
This grid shows the slowest queries across all your databases ordered by MAX Time
This grid shows the slowest queries across all your databases ordered by MAX Time
  • Repetitive Queries: Discover the most frequently executed queries across your entire database fleet:
See the most repetitive queries across all your databases
See the most repetitive queries across all your databases

‍

2. Servers View: Here, you can correlate your CPU & IO metrics with the status of your connections across hundreds of DB instances:

See a clear correlation between CPU Utilization & Connections Usage
See a clear correlation between CPU Utilization & Connections Usage
  1. Rapydo Recommendations: This feature offers actionable insights from Rapydo Cortex across your entire database fleet. Utilizing Rapydo Recommendations allows you to identify optimization opportunities, such as caching tables or queries and throttling queries with significant time differences between their minimum and maximum execution times. These recommendations are presented instantaneously, as they are generated directly from your MySQL Performance Schema. In the future roadmap for Rapydo Scout, we plan to introduce recommendations for Query Optimization via Large Language Models, which will be tailored based on your DB Schema and the specific queries:
See the tables with the best R/W Ratio for Caching
See the tables with the best R/W Ratio for Caching

‍

See queries with large gap between Min/Max runtime, for detection of high parallelism in order to leverage Rapydo Queueing capabilities
See queries with large gap between Min/Max runtime, for detection of high parallelism in order to leverage Rapydo Queueing capabilities

‍

‍

‍

‍

In summary, Rapydo Scout provides visibility into hundreds or even thousands of databases on a single screen, enabling you to pinpoint the most significant issues across your database fleet.Connecting to Rapydo Scout takes no more than 10 minutes. Feel free to reach out to us and schedule a demo.

‍

‍

More from the blog

MySQL 5.7 vs. MySQL 8.0: New Features, Migration Planning, and Pre-Migration Checks

April 18, 2024
•
Alon Kafry

This article compares MySQL 5.7 and MySQL 8.0, emphasizing the significant improvements in MySQL 8.0, particularly in database optimization, SQL language extensions, and administrative features. Key reasons to upgrade include enhanced query capabilities, support from cloud providers, and keeping up with current technology. MySQL 8.0 introduces window functions and common table expressions (CTEs), which simplify complex SQL operations and improve the readability and maintenance of code. It also features JSON table functions and better index management, including descending and invisible indexes, which enhance performance and flexibility in database management. The article highlights the importance of meticulous migration planning, suggesting starting the planning process at least a year in advance and involving thorough testing phases. It stresses the necessity of understanding changes in the optimizer and compatibility issues, particularly with third-party tools and applications. Security enhancements, performance considerations, and data backup strategies are also discussed as essential components of a successful upgrade. Finally, the article outlines a comprehensive approach for testing production-level traffic in a controlled environment to ensure stability and performance post-migration.

Keep reading

Unveiling Rapydo

March 28, 2024
•
Matan Nataf

Rapydo Emerges from Stealth: Revolutionizing Database Operations for a Cloud-Native World In today's rapidly evolving tech landscape, the role of in-house Database Administrators (DBAs) has significantly shifted towards managed services like Amazon RDS, introducing a new era of efficiency and scalability. However, this transition hasn't been without its challenges. The friction between development and operations teams has not only slowed down innovation but also incurred high infrastructure costs, signaling a pressing need for a transformative solution. Enter Rapydo, ready to make its mark as we step out of stealth mode.

Keep reading

SQL table partitioning

October 17, 2023
•
Eran Shaked

Using table partitioning, developers can split up large tables into smaller, manageable pieces. A database’s performance and scalability can be improved when users only have access to the data they need, not the whole table.

Keep reading

Block queries from running on your database

April 5, 2023
•
Eran Shaked

As an engineer, you want to make sure that your database is running smoothly, with no unexpected outages or lags in response-time. One of the best ways to do this is to make sure that only the queries you expect to run are being executed.

Keep reading

Uncover the power of database log analysis

December 28, 2022
•
Eran Shaked

Logs.They’re not exactly the most exciting things to deal with, and it’s easy to just ignore them and hope for the best. But here’s the thing: logs are actually super useful and can save you a ton of headaches in the long run.

Keep reading