How to Easy Manage Database Updates and Security Patches
Database security requires careful planning, but it is important to remember that security is not a state, it is a process. Once the database is in place, monitoring, alerting and reporting on changes are an...
How to Protect Your MySQL & MariaDB Database Against Cyberattacks When on a Public Network
It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often...
Using OpenVPN to Secure Access to Your Database Cluster in the Cloud
The internet is a dangerous place, especially if you’re leaving your data unencrypted or without proper security. There are several ways to secure your data; all at different levels. You should always have a strong...
How to Use the Roles That Have Changed in MySQL 8.0
Database Security is important to any MySQL setup. Users are the foundation of any system. In terms of database systems, I generally think of them in two distinct groups: Application, service, or program users - basically...
Database Backup Encryption – Best Practices
Offsite backup storage should be a critical part of any organisation’s disaster recovery plan. The ability to store data in a separate physical location, where it could survive a catastrophic event which destroys all the...
Utilizing Encryption to Strengthen PostgreSQL Database Security
Please Note: Portions of the blog contain references and examples from "ANNOUNCING AVAILABILITY OF POSTGRESQL INSTANCE LEVEL ENCRYPTION" by CyberTec, a company which provides support, consulting and training for PostgreSQL. Organizations deal with different types of...
How to Deploy PostgreSQL for High Availability
Introduction Nowadays, high availability is a requirement for many systems, no matter what technology you’re using. This is especially important for databases, as they store data that critical applications and systems rely on. The most...
Database Security Monitoring for MySQL and MariaDB
Data protection is one of the most significant aspects of administering a database. Depending on the organizational structure, whether you are a developer, sysadmin or DBA, if you are managing the production database, you must...
Self-Provisioning of User Accounts in PostgreSQL via Unprivileged Anonymous Access
Note from Severalnines: This blog is being published posthumously as Berend Tober passed away on July 16, 2018. We honor his contributions to the PostgreSQL community and wish peace for our friend and guest writer....
New Backup Management and Security Features for MySQL & PostgreSQL: ClusterControl Release 1.6.2
We are excited to announce the 1.6.2 release of ClusterControl - the all-inclusive database management system that lets you easily automate and manage highly available open source databases in any environment: on-premise or in the...
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...
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...