PostgreSQL v13 Deployment and Scaling with ClusterControl 1.8.2
PostgreSQL is one of the databases that can be deployed via ClusterControl, along with MySQL, MariaDB and MongoDB. ClusterControl not only simplifies the deployment of the database cluster, but has a function for scalability in...
Best Practices in Scaling Databases: Part Two
In the previous blog post, we have covered the basics of scaling - what it is, what are the types, what is a must-have if we want to scale. This blog post will focus on...
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...
Understanding Indexes in MySQL: Part One
Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of...
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...
Full Ops Automation of your Hybrid Cloud Database
In a previous blog, we wrote about about the architecture of hybrid cloud databases. Having database instances in different datacenters sounds all good, but how do you manage all that? How do you know if...
Automate Database Health Check
Ensuring the database is healthy is one of the critical and important things that a database administrator must do. If we neglect the maintenance of the database, there is a higher probability that we run...
MongoDB Database Deployment Automation
Organizations are making use of infrastructure in the cloud because it offers speed, flexibility, and scalability. You can imagine if we can spin up a new database instance with just a click, and it takes...
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...
MySQL Database Deployment Automation
Automation is in vogue these days. Technology evolves quickly, and more people are contributing to existing available third party automation software platforms. As the season of fast-paced deployments, automation is now necessary and considered as...
Database Automation Best Practices in the Healthcare Industry
Database management at scale can’t be done without proper automation techniques. Long gone are the days when database administrators were naming their database servers, spend days tuning and tweaking the configuration, ensuring that everything works...