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,...
Automate Database Schema Object Check
Monitoring your database schema changes in MySQL/MariaDB provides a huge help as it saves time analyzing your database growth, table definition changes, data size, index size, or row size. For MySQL/MariaDB, running a query referencing...
Database Automation Best Practices in FinTech
Automation equals speed - there is no discussion about it. Automation also increases reliability and reduces the error rate. Those feats are important in pretty much every kind of industry, but they are crucial for...
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...
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...
Automating Security Audits for MySQL
Taking care of the security of your MySQL instances is a near-daily task of almost every MySQL DBA. Today, we will look into how you should go about automating security audits for MySQL. Why Automate...
Automated Testing of the Upgrade Process for MySQL/MariaDB/Percona Server
Upgrades are always a hard and time-consuming task. First, you should test your application in a test environment, so, ideally, you will need to clone your current production environment for this. Then, you need to...
Automated Testing of the Upgrade Process for PXC/MariaDB Galera Cluster
Upgrading your database for Galera-based clusters such as Percona XtraDB Cluster (PXC) or MariaDB Galera Cluster can be challenging, especially for a production-based environment. You cannot afford to lose the state of your high availability...
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....
Using Automation to Speed up Release Tests on Galera Cluster With ClusterControl
Release tests are typically one of the steps in the whole deployment process. You write the code, and then you verify how it behaves on a staging environment, and then, finally, you deploy the new...
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...