Showing entries 1 to 10 of 75
10 Older Entries »
Displaying posts with tag: MONyog (reset)
The wish list for secure and effective monitoring of MySQL servers

 All you need for monitoring MySQL servers

Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target …

[Read more]
The wish list for secure and effective monitoring of MySQL servers

All you need for monitoring MySQL servers. Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server execution information while minimizing the impact on server performance. There is a trade-off between the time you can save by using Performance Schema and the load it adds to the server. It can optimize server performance and save time when used in an efficient manner.

You can also target queries that …

[Read more]
New Query Analysis Features in MONyog

While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease.

The latest update of MONyog brings new easier ways to find problem SQL in Real-Time, Wayback Machine and sniffer based Query Analyser using Performance Schema. Here is what’s new:

Query Execution Status and Full Table Scan Count
View success/failure status of every query executed and also the number of ‘full table scans’ for queries in a single glance.

The latest update also has an option to switch between Performance Schema and Processlist in Real-Time making it easy for you to enable/disable Performance Schema or Processlist.

Get the latest update now to enjoy these features.Existing customers can download MONyog 6.52 from Customer Area. To evaluate MONyog 6.52, please …

[Read more]
New Query Analysis Features in MONyog

While looking to optimize your MySQL, you are needing to spot slow/bad queries at a glance and get deep insights about them with ease.

The latest update of MONyog brings new easier ways to find problem SQL in Real-Time, Wayback Machine and sniffer based Query Analyser using Performance Schema. Here is what’s new:

Query Execution Status and Full Table Scan Count
View success/failure status of every query executed and also the number of ‘full table scans’ for queries in a single glance.

The latest update also has an option to switch between Performance Schema and Processlist in Real-Time making it easy for you to enable/disable Performance Schema or Processlist.

Get the latest update now to enjoy these features.Existing customers can download MONyog 6.52 from Customer Area. To evaluate MONyog 6.52, please …

[Read more]
Monitoring your Amazon Aurora Databases using MONyog

We’re excited to announce the general availability of MONyog for Amazon Aurora. Amazon Web Services’ (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open source databases. Designed to provide up to 5x improved performance than MySQL at a price that’s one-tenth of any commercial RDBMS, Aurora definitely looks promising.

Aurora is fault-tolerant by design, since it replicates data into three locations, making it highly available. To monitor your Aurora databases, you can always rely on MONyog to do the job for you.

Aurora doesn’t allow to install anything on your Aurora database. Since MONyog is built on an agent-less architecture, it can connect to Aurora without any hassle.

Connecting to Aurora
Enter the DNS address of your …

[Read more]
Monitoring your Amazon Aurora Databases using MONyog

We’re excited to announce the general availability of MONyog for Amazon Aurora. Amazon Web Services’ (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open source databases. Designed to provide up to 5x improved performance than MySQL at a price that’s one-tenth of any commercial RDBMS, Aurora definitely looks promising.

Aurora is fault-tolerant by design, since it replicates data into three locations, making it highly available. To monitor your Aurora databases, you can always rely on MONyog to do the job for you.

Aurora doesn’t allow to install anything on your Aurora database. Since MONyog is built on an agent-less architecture, it can connect to Aurora without any hassle.

Connecting to Aurora
Enter the DNS address of your …

[Read more]
Monitoring High Availability on Galera Clusters for MySQL using MONyog

For every online business, there are millions of transactions happening every second including crucial revenue bearing transactions. Therefore downtime, both planned and unplanned has a cost attached to it and results in lost revenue every second. As the technology improved to meet this demand, the importance of High Availability (HA) became the focus point.

The introduction of Galera Cluster for MySQL bought true Multimaster Cluster thanks to its synchronous replication. In this article, we’ll show how using MONyog in tandem with Galera provides a simple and best-in-class High Availability solution for MySQL users.

How to register a Galera Cluster Node in MONyog

  1. Enter the Hostname, port and credentials in “MySQL settings”, test the connection and save it.
  2. Enable “Galera” group from “Customize” > “Manage monitor groups”
  3. In Monitors page, select the “Galera” group and …
[Read more]
Introducing actionable charts in MONyog MySQL Monitor

While MONyog MySQL Monitor is being embraced by DBAs and DevOps around the world, we are constantly adding more features to make MONyog the most complete MySQL monitoring tool.

MONyog ships 40+ MySQL and system metric charts. It also lets you add custom charts. With the latest update, we have made Charts more powerful by adding few important features to help you find problem queries with ease.

Here’s a 1 minute video to walk you through the new features.

Existing customers can download MONyog 6.33 from Customer Area. To evaluate MONyog 6.33, please download a 14-day trial.

We are really excited about this update and we hope you like the new features. Please feel free to share your feedback.

Cheers,
Team MONyog

The post …

[Read more]
Rockstar DBA: An Interview with Manojit Paul


This article is a part of our Rockstar DBA initiative, a platform for thought leaders to share their knowledge and make a positive contribution towards the database management community.

Manojit Paul, with more than 19 years of professional DBA experience in enterprise database solutions, especially Sybase product set and database infrastructure is our first Rockstar DBA.

Let’s hear from Manojit about how he manages MySQL databases, why he loves MONyog, his advice to young DBA’s and more.

How do you manage your MySQL databases?
We presently have 9 MySQL servers in production trading environment, all being managed via a host of automated scripts which I’ve created and manual intervention when issues are reported. We deploy MONyog for managing 5 of these critical MySQL instances. …

[Read more]
Webinar – Monitoring MySQL and MariaDB databases with MONyog. Register now

Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free

Update: Congratulations to Vandana Sharma on …

[Read more]
Showing entries 1 to 10 of 75
10 Older Entries »