After 10 Years, MySQL Still the Right Choice for ScienceLogic's "Best Network Monitoring System on the Planet"
- by Rebecca Hansen
ScienceLogic has a pretty fantastic network monitoring appliance. So good in fact that InfoWorld gave it their "2013 Best Network Monitoring System on the Planet" award. Inside their "ultraflexible, ultrascalable, carrier-grade" enterprise appliance, ScienceLogic relies on MySQL and has since their start in 2003. Check out some of the things they've been able to do with MySQL and their reasons for continuing to use MySQL in these highlights from our new MySQL ScienceLogic case study.
Science Logic's larger customers use their appliance to monitor and manage 20,000+ devices, each of which generates a steady stream of data and a workload that is 85% write. On a large system, the MySQL database:
Averages 8,000 queries every second or about 1 billion queries a day
Can reach 175,000 tables and up to 20 million rows in a single table
Is 2 terabytes on average and up to 6 terabytes
"We told our customers they could add more and more devices. With MySQL, we haven't had any problems. When our customers have problems, we get calls. Not getting calls is a huge benefit." Matt Luebke, ScienceLogic Chief Software Architect.?
ScienceLogic was approached by a number of Big Data / NoSQL vendors, but decided against using a NoSQL-only solution. Said Matt, "There are times when you really need SQL. NoSQL can't show me the top 10 users of CPU, or show me the bottom ten consumer of hard disk. That's why we weren't interested in changing and why we are very interested in MySQL 5.6. It's great that it can do relational and key-value using memcached."
The ScienceLogic team is very cautious about putting only very stable technology into their product, and according to Matt, MySQL has been very stable: "We've been using MySQL for 10 years and we have never had any reliability problems. Ever."
ScienceLogic now uses SSDs for their write-intensive appliance and that change alone has helped them achieve a 5x performance increase.
Learn more>>
ScienceLogic MySQL Case Study
MySQL 5.6 InnoDB Compression options for better SSD performance
Tuning MySQL 5.6 for Great Product Performance - on demand webinar
Developer and DBA Guide to MySQL 5.6 white paper
Guide to MySQL and NoSQL: The Best of Both Worlds white paper