In order for XTIVIA to provide DBA managed services to governmental agencies where the FBI's Criminal Justice Information Services Division (CJIS) Security Policy is required, CJIS compliance was necessary. CJIS is a set of standards for accessing criminal justice...
Database Blog Posts
Automating Log Rotation with Logrotate
Rotating MySQL logs is important because logs can take up a lot of disk space if left unmanaged. For example, an untuned database can lead to a lot of slow queries being logged. The error log can become large if it includes notes and warnings. Additionally, binlogs...
Migrating from SUPER to Dynamic Privileges
When performing health checks on a database, I look at how many users are granted SUPER privileges. If you're reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
Explaining Database Normalization Like You’re Five
Normalization is not that complicated. In fact, the beauty of these rules is that you may not know you're already applying them in your database design. To demonstrate, over the course of this multi-part series, we'll be covering the three generally accepted levels of...
SQL Query Plan Karaoke
Because even DBAs need a little holiday humor, and we all know how SQL query plans can go.
What’s a Database Health Check?
As a critical component of your business, a healthy database is vital to staff efficiency and customer satisfaction. If you've neglected database maintenance and tuning, chances are you're running into a litany of performance issues. When your database begins to lag,...
The Basics of Database Performance Tuning
Poor database performance bogs down operations, and as the lifeblood of a business, companies can't afford barriers to data access. One of the best ways to navigate past performance issues is by getting a regular database performance audit. Just like a car needs...
Will Migrating to PostgreSQL or MongoDB Save You Money?
One of the most common questions our clients ask us is, "can we save money migrating to an open-source database like PostgreSQL or MongoDB?" The answer is simple: yes. Before we dive into the details, it's important to note that "open source" does not mean free. While...
What is MFA and Why does it Matter?
Multi-Factor Authentication (MFA) is something a lot of IT professionals know about but never want to bring up to their clients. MFA is the next step defense in your everyday battle in protecting your day to day operations. So let's talk about it. What is MFA?...
Sockets, Cores, and Threads, oh my!
What do you mean, exactly, by "CPU"? Once upon a time, computers sat on our desks; we knew exactly how many processors they had; and back then our biggest uncertainty was whether they could handle Y2K. Fast forward to today: our computers have 4, 8 or 16 processors —...