Learn how the Senior Database Administrator at Sysnet Global Solutions optimized the MariaDB database performance.
Sysnet Global Solutions provide services that improve security at acquiring organisations operating in the payment card industry. Services include cybersecurity and compliance solutions that help the acquiring organisations to reduce risk. Their cybersecurity solutions and extraordinary services and support also empower the acquirers’ customers to be secure and compliant.
Monitoring MariaDB Databases
Sysnet Global Solutions manage a number of MariaDB database servers that require monitoring in off-shore locations. The prime challenge faced by the company was to find a cost-effective monitoring tool that will help them optimize MariaDB database performance. Before opting for Monyog, Dermot Brereton evaluated a number of open-source tools such as Cacti and Percona Monitoring and Management that could help them ease the task of monitoring and finding issues. The rich features and the ease to install/use the tool made Monyog the perfect match to the company’s suite of IT monitoring products.
Robust tool for Monitoring MariaDB
Dermot found most of the Monyog features extremely useful, meeting his server monitoring needs. Query Analyzer helped identify poorly performing SQL and provided the ability to help tune the performance. Alerting and monitoring InnoDB deadlocks in real-time helped to stay ahead of problems when data concurrency issues occur. Dermot also found the Server Config feature to be extremely helpful in identifying variables that are set differently across database hosts. He also feels the agentless monitoring helps his organisation to provide a “big picture” view of the entire IT stack both on-premise and in the cloud.
As Dermot puts it,
“In my view, our organisation now has a cost-effective, agent-less and robust tool for monitoring and managing the MariaDB estate.”
Conclusion
Dermot’s experience of the tool to date is that it has largely delivered in terms of expectation and he has found the interaction experience to be very positive.
Dermot says, “ The team was of great assistance during the evaluation process by organising online demonstrations and answering queries to ensure customer satisfaction at each step.’’
