Database Archive

What You Need to Know About the MariaDB & Percona Forks of MySQL

Sometimes it feels like you’re bound to hit MySQL eventually, regardless of where you dig on the Internet. It lies beneath the biggest sites, such as Lucent, Facebook, Drupal, WordPress, Google, Joomla and countless other major frameworks, and it’s so huge it has its own letter in the LAMP stack (Linux, Apache, ...Read More

6 Basic Security Concerns for SQL Databases – Part 2

In our first article, we looked at some of the basics of securing databases, examined several examples of major data breaches, and reviewed best practices companies use to prevent hackers from accessing sensitive information. In this article, we are going to look at some advanced database security issues and recommend steps you ...Read More

6 Basic Security Concerns for SQL Databases – Part 1

Consider these scenarios: A low-level IT systems engineer spills soda, which takes down a bank of servers; a warehouse fire burns all of the patient records of a well-regarded medical firm; a government division’s entire website vanishes without a trace. Data breaches and failures are not isolated incidents. According to the 2014 ...Read More

Top 6 Database Performance Metrics to Monitor in Enterprise Applications

The previous article presented an introduction SQL and NoSQL. This article builds on these topics by reviewing six of the top performance metrics to capture to assess the health of your database in your enterprise application. Specifically this article reviews the following: Business Transactions Query Performance User and Query Conflicts Capacity Configuration ...Read More

5 Tricky SQL Database Performance Challenges

There’s a good chance you’ve come across various performance challenges while writing queries and working within SQL if you use it on a regular basis. You might be dealing with slow-moving or poorly-written queries, inefficient subqueries, indexes with tons of writes to them but little or no reads, or different CPU and ...Read More

10 Popular Oracle Performance Metrics that Every DBA Should Know

Before you jump into creating KPIs for your Oracle database, clearly state and test your assumptions right up front. That has to come first. Otherwise, you’ll go down a blind alley many times trying to achieve better performance that will never happen because your assumptions were wrong in the first place. Be ...Read More

Franken-Monitor Visits a War Room [COMIC]

Having silo’d monitoring toolsets will often provide more trouble than they’re worth. All too often, monitoring tools don’t work well together, provide conflicting data, or just simply can’t diagnose the problem. In a War Room scenario — where people from the database team, servers, developers, IT operations, and anyone else involved — ...Read More

A Newbie Guide to Databases

Databases are an incredibly useful tool for storing data. Similar to a library storing books in an organized structure consisting of categories – such as history or art – a database imposes order on your data so that you can quickly construct the information you are looking for. Different types of databases ...Read More

The Franken-Monitor adds Database Monitoring [COMIC]

In June with our Summer ‘15 Release, we introduced the IT world to true Unified Monitoring — a single pane of glass to monitor your whole environment. Finally obtain complete visibility into your entire IT Infrastructure with an industry-first application-centric integrated monitoring platform. Coinciding with the release, we re-introduced the concept of ...Read More

Too many tools, not enough big picture: A case of Franken-monitoring

In recent interview, an IT operations director told us, “We frankly have too many tools, and many of them weren’t performing to our expectations.” If you are an enterprise ops leader managing complex applications, chance are pretty high that you can relate to that statement. At AppDynamics, we call this “Franken-monitoring,” a situation ...Read More