How to Automate Deployment of PostgreSQL Database
In the world of information technology, automation is not a new thing for most of us. In fact, most organizations are using it for various purposes depending on their work type and objectives. For example,...
How to manage large databases effectively
One of the biggest concerns when managing a database is the size and complexity of its data. As the size of the database increases, you need to have a plan in place for how to...
Best Practices in Scaling Databases: Part 1
All of you have heard about scaling - your architecture should be scalable, you should be able to scale up to meet the demand, so on and so forth. What does it mean when we...
New User and LDAP Management in ClusterControl 1.8.2
After upgrading to ClusterControl 1.8.2, you should get the following notification banner: What's up with that? It is a depreciation notice of the current user management system in favor of the new user management system...
Automated Testing of the Upgrade Process for PostgreSQL
Testing is a time-consuming task, but it is a must before any upgrade process on any technology. Depending on the type of upgrade, it could be harder or easier, but it is always necessary if...
Automate Database Configuration Check
Many system administrators commonly overlook the importance of ongoing database configuration tuning. Configuration options are often being configured or tuned once, during the installation stage, and being left out until some unwanted events occur to...
Announcing CCX Database as a Service from Severalnines
We at Severalnines are thrilled to announce the release of CCX, our brand new database as a service (DBaaS) offering! It’s a fully managed service built atop the powerful ClusterControl automated operational database management...
Using Automation to Speed up Release Tests on PostgreSQL
Having a test environment is a must in all companies. It could be necessary for testing changes or new releases of the application, or even for testing your existing application with a new PostgreSQL version....
How to Get Started With Database Automation
Database automation helps make complex and time consuming tasks simple and fast. The tasks most commonly and easily identified for automation are those that are time-consuming yet repetitive. These often consume productivity, and can affect...
Automating Security Audits for PostgreSQL
Security audits are a must in all companies to protect data and avoid any possible security breaches, but it is also a time-consuming task as you need to check a lot of things periodically. The...
Enforcing Role-Based Access Controls with ClusterControl
In Severalnines’ recent release of ClusterControl version 1.8.2 we have introduced a lot of sophisticated features and changes. One of the important features is the newly improved User Management System, which covers New User and...
Audit Logging for PostgreSQL
Auditing is a requirement for many security regulations or standards, like PCI - Payment Card Industry, and even a good way to keep your data as safe as possible knowing what is happening in your...