Categories
Products
Technologies
Top Rated docs

June 11, 2019

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...

May 31, 2019

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...

May 20, 2019

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...

May 10, 2019

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...

March 20, 2019

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...

March 4, 2019

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...

February 26, 2019

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...

February 22, 2019

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....

February 11, 2019

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...

November 28, 2018

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,...

November 5, 2018

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...

July 24, 2018

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...

Subscribe below to be notified of fresh posts