Disaster Recovery Planning for MySQL & MariaDB
We’re happy to announce that our new whitepaper Disaster Recovery Planning for MySQL & MariaDB is now available to download for free! Database outages are almost inevitable and understanding the timeline of an outage can...
PostgreSQL Audit Logging Best Practices
In every IT system where important business tasks take place, it is important to have an explicit set of policies and practices, and to make sure those are respected and followed. Introduction to Auditing...
Integrating PostgreSQL With Authentication Systems
PostgreSQL is one of the most secure databases in the world. Database security plays an imperative role in the real-world mission critical environments. It is important to ensure databases and the data is always secured...
Top PostgreSQL Security Threats
Modern databases store all kinds of data. From trivial to highly sensitive. The restaurants we frequent, our map locations, our identity credentials, (e.g., Social Security Numbers, Addresses, Medical Records, Banking info, etc...), and everything in...
Setting up HTTPS on the ClusterControl Server
As a platform that manages all of your databases, ClusterControl maintains the communication with the backend servers, it sends commands and collect metrics. In order to avoid unauthorized access, it is critical that the communication...
Safeguarding your Data with ClusterControl
In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in...
How to Achieve GDPR Compliance: Documenting Our Experience (II)
Introduction The General Data Protection Regulation (GDPR) is just around the corner, and we’re sharing with you the things we’re doing to make sure we’re ready. As the GDPR will be taking effect on May...
PostgreSQL Privileges and Security – Locking Down the Public Schema
Introduction In a previous article we introduced the basics of understanding PostgreSQL schemas, the mechanics of creation and deletion, and reviewed several use cases. This article will extend upon those basics and explore managing privileges...
How to Secure Your PostgreSQL Database – 10 Tips
Once you have finished the installation process of your PostgreSQL database server it is necessary to protect it before going into production. In this post, we will show you how to harden the security around...
SSL Key Management and Encryption of MySQL Data in Transit
Databases usually work in a secure environment. It may be a datacenter with a dedicated VLAN for database traffic. It may be a VPC in EC2. If your network spreads across multiple datacenters in different...
PostgreSQL Privileges & User Management – What You Should Know
User management within PostgreSQL can be tricky. Typically new users are managed, in concert, within a couple of key areas in the environment. Oftentimes, privileges are perfect on one front, yet configured incorrectly on the...
Database User Management With ClusterControl
In the previous posts of this blog series, we covered deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health, how...