Published by Alex Slotnick on Feb 11, 2017 7:42:00 PM

Shopify Eliminates High Latency Queries From Redis and MySQL

As intuitive and streamlined as ecommerce technology might seem from the user's perspective, it involves so much data that engineering ingenuity and smart database management must constantly deliver in order to keep up. At organizations like Shopify—responsible for the easy and reliable transactions at top brands around the world—that excellence of performance involves deep monitoring of their MySQL core and their Redis caching infrastructure, plus insightful query profiling, packet captures, and the admittance of developers to platforms that measure database performance.

Read More
Published by Alex Slotnick on Dec 31, 2016 10:58:49 AM

2016: VividCortex's Exciting Year in Review

As New Year's festivities start up around the world, VividCortex has many reasons to join the celebration. We're exhilarated and grateful to think back on how far we've come over the past 12 months. This has been a year of non-stop progress for our team and in what we've seen VividCortex's users accomplish.

Read More
Published by Anna Navatsyk on Jun 29, 2015 7:51:00 AM

Success Story: VividCortex Improves Reliability at DC Energy

DC Energy is a trader in the commodities markets that relies heavily on MySQL. Since trading is time-sensitive, database management and minimal system downtime is a high priority. Prior to deploying VividCortex, DC Energy used query logs and custom tools, scripts and metrics to find and resolve problems. Internal tools did not provide a way to quickly review and assess the enormous amount of data available, and gaining insight into performance was time consuming.

Read More
Published by Anna Navatsyk on Mar 12, 2015 8:14:00 AM

Case Study: VividCortex Improves Time to Market for NetProspex

NetProspex is a B2B platform that enhances lead generation by separating the information that matters and enabling marketers to better segment and target their audience. Managing the massive amount of incoming data is cumbersome for one DBA.

In the past, NetProspex used tools like Nagios and MySQL Enterprise Monitor (MEM), but both fell short of the company’s monitoring needs. Hiring another DBA was both difficult and expensive, so Josh Prunier, DBA at NetProspex, began evaluating alternative solutions. VividCortex’s MySQL-specific query intelligence was better suited.

VividCortex made an immediate positive impact on Josh’s workload and overall operations by improving insight into query and server behavior and reducing overhead costs. The ability to compare and analyze queries allows Josh to proactively examine queries that are not written efficiently and take actions such as tweaking an index or the query syntax. The deep detail exposed via VividCortex’s TCP traffic capture and advanced statistical analysis immediately surfaces “bad” queries that are taking a long time, using a lot of IO resources or not using indexes.

According to Josh, “VividCortex is a database performance monitoring solution for enterprise systems. It makes a DBA’s and developers’ job easier.”

VividCortex has resulted in faster deploys to improve time-to-market, reduced resource costs and generally reduced headaches for DBAs and developers, making everyone happier.

The full case study is available for download here. If you think this level of analysis could benefit your company, learn more or start your free trial today!

Read More
Published by Anna Navatsyk on Feb 18, 2015 8:11:00 AM

Case Study: VividCortex Helps WebAssign Prepare for High Volume Season

WebAssign develops higher education online instructional tools for faculty and students, and more than one million students at over 2,300 educational institutions use WebAssign each year. Last year, WebAssign experienced a large outage that impacted their ability to provide timely online grading and assessments; they took this opportunity to look for new tools that would improve insights into their database activities and ensure service level requirements.

“MEM for MySQL wasn’t able to provide per-query metrics or fault diagnosis, which is a level of detail that we value,” said Valerie Parham, DBA, WebAssign. “Instead, releases would appear fine, but then a problem would pop up and we’d have to do a hot-fix so it didn’t turn into an outage, which placed undue stress on everyone.”

WebAssign looked at a number of solutions, including Percona Cloud Tools, but none offered the same level of full query insight and predictive capability of VividCortex. “VividCortex is a monitoring system that gives us full insight into our database - at the system level, the query level, and the database performance level,” said Parham. “Plus, it’s very usable even by non-technical people.” The level of detail is unmatched by other tools and enables smooth problem identification and resolution.

This season, WebAssign was well prepared because they were able to detect and fix problems well in advance.

The full case study is available for download here. If you think this level of analysis could benefit your company, start your free trial today!

Read More
Published by Anna Navatsyk on Jan 29, 2015 8:01:00 AM

Case Study: VividCortex Gives Dyn Predictive Smarts and Analysis

Dyn delivers Internet Performance solutions to optimize clients’ Internet properties. Data is their business, so it is crucial their systems are running effectively. Prior to VividCortex, Dyn used a variety of tools including Graphite, Cacti and Munin to analyze health and performance. Despite custom reports and graphs, Dyn was left with data that lacked predictive smarts and was difficult to interpret.

Dyn evaluated other products like Anemometer, Percona Toolkit, MONyog and New Relic but ultimately chose VividCortex for its depth and consolidation of insight. Features such as “compare queries” present a clear perception of change, a feature not common in competitor’s tools. VividCortex analyzes latency across disc IO, the network and query performance to easily pinpoint the source of problems.

Tim Chadwick, Principal Engineer of Infrastructure says it best: “At this point, it is considered a must have, and everyone on the team uses it to see the effects of system changes. Beyond that, the functional interface makes it easy to share findings across departments and communicate needs effectively.”

The full case study is available for download here. If you think this level of analysis could benefit your company, start your free trial today! You will have immediate access to our app and support team, who is, in the words of Tim, “incredibly helpful and responsive.”

Read More
Published by Anna Navatsyk on Jan 20, 2015 8:09:00 AM

Case Study: VividCortex Helps PayLease Manage Massive Amounts of Data

PayLease is the leading online payment processor for property managers and HOAs. The company serves thousands of property management clients across the United States and was seeking a solution to help them better manage their massive amount of data and minimize slow periods.

Before VividCortex, they had to sort through nearly 10 gigabytes of data each time there was an issue, a cumbersome process that often proved ineffective. PayLease also wanted a tool that would better equip them to prevent future issues. They needed a predictive solution to flag issues that could become high priority down the road.

PayLease chose VividCortex because of the intuitive interface, level of granularity and functionality. They saw the difference immediately. Todd Newell, the Database Engineer, “I look at top queries on a daily basis. I recognize what is there, what should be there, and am able to quickly pull something out that is garnering way too many resources and re-architect it. The top queries view shows which queries were running, each version of those queries, the number of executions, and the amount of resources consumed. On an investigation level, this is extremely helpful.”

Now, they are able to recognize problems at the time of code release and immediately act. The granular detail of VividCortex allows them to see specific queries having issues and eases the pain of diagnosis. What typically took 3 – 4 hours and yielded uncertain results now renders actionable results immediately. The usability of the interface allows them to share this information with team member and management to prevents future issues and make their needs known. Beyond that, PayLease is no longer having to store and search through slow query logs, reducing their query storage from between 35 GB and 100 GB per day to less than 1 GB.

The full case study is available for download here. If you think this level of analysis could benefit your company, start your free trial today! As Kevin Palmer, Senior Systems and Software Engineer at PayLease stated, “It has features I never knew I needed like the ability to compare queries over time. It is becoming more and more integral in preventing and finding issues.”

To view the archives of case studies, visit here.

Read More
Published by Kyle Redinger on Oct 2, 2013 9:41:00 AM

Making You Happy: Live Customer Stories

We just soft-launched to a handful of early customers yesterday and things are looking pretty good. We’re starting to achieve our goals of making our users very happy. It’s not marketing talk. One of our customers just mentioned the following to us:

Read More

Recent Posts

Posts by Topic

see all