After 10 Years, MySQL Still the Right Choice for ScienceLogic's "Best Network Monitoring System on the Planet"
By Rebecca Hansen on Oct 31, 2013
- 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.
- 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