Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster
In the previous blog post, we showed you some basic steps to deploy and manage a standalone MySQL server as well as MySQL Replication setup using the MySQL Puppet module. In this second installation, we...
Database Automation with Puppet: Deploying MySQL & MariaDB Replication
Puppet is an open source systems management tool for centralizing and automating configuration management. Automation tools help to minimize manual and repetitive tasks, and can save a great deal of time. Puppet works by default...
How to Migrate WHMCS Database to MariaDB Galera Cluster
WHMCS is an all-in-one client management, billing and support solution for web hosting companies. It's one of the leaders in the hosting automation world to be used alongside the hosting control panel itself. WHMCS runs...
Popular Docker Images for MySQL and MariaDB Server
A Docker image can be built by anyone who has the ability to write a script. That is why there are many similar images being built by the community, with minor differences but really serving...
How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker
ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse. Recently, ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera...
How to Migrate from MSSQL to MySQL
Migrating from proprietary engines into open source engines is a trend that is growing in the industry. However, database migration is not something to be taken lightly. In this blog, let’s see what is needed...
Migrating from Oracle Database to MariaDB – What You Should Know
Gartner predicts that by 2022, 50% of existing commercial databases will have been converted to open source databases. Even more, 70% of new in-house applications will be developed on an open source database platform (State...
Migrating from DB2 to PostgreSQL – What You Should Know
Whether migrating a database or an application from DB2 to PostgreSQL with only one type of database knowledge is not sufficient, there are few things to know about the differences between the two database systems....
ClusterControl Tips and Tricks: Running ClusterControl on PHP 7
ClusterControl consists of multiple components and one of them is the user interface, a web application running on PHP platform. Some customers had concerns since PHP 5.x was deprecated early this year. This blog post...
What's New in PostgreSQL 11
PostgreSQL 11 was released on October 10th, 2018, and on schedule, marking the 23rd anniversary of the increasingly popular open source database. While a complete list of changes is available in the usual Release Notes,...
Migrating from MSSQL to PostgreSQL – What You Should Know
As you may know, Microsoft SQL Server is very popular RDBMS with highly restrictive licencing and high cost of ownership if the database is of significant size, or is used by a significant number of...
Failover for PostgreSQL Replication 101
Failover might sound like a buzzword for anyone within the IT industry, but what’s behind it? What is a failover? What can I use it for? Is it important to have it? How can I...