Database - General

Ever wondered where to start learning to get trained in PostgreSQL? In this blog we will walk you through all the official PostgreSQL community resources and everything you need to become a PostgreSQL expert.

In this blog we’ll take a look at the most common PostgreSQL failure scenarios and show you how you can solve or cope with the issues. We’ll also look at how ClusterControl can help us get back online

Drupal is a CMS designed to create everything from tiny to large corporate websites. Failover comes in handy for any admin as it can eliminate long hours of downtime caused by corruption the need for maintenance. In this blog we’ll discuss how you can implement database failover for your MySQL or PostgreSQL databases.

Join methods are the various ways to join two tables depending on the kind of data, query, etc. In this blog, we’ll look at an overview of all the different join methods currently supported by PostgreSQL.

WordPress is, by far, the most popular CMS in the world powering millions of websites from small to large. But how can you ensure the unavailability of your database will not impact the website? In this blog post we will show how to achieve failover for your WordPress website using ClusterControl.

Scan methods are the various ways to select data from the table depending on the kind of data and percentage of data selected. In this blog, we’ll look at an overview of all the different scan methods currently supported by PostgreSQL.

In this blog, we will validate a PostgreSQL backup by restoring the backup onto a Docker container. For this post, we will use pgBackRest as the tool of choice to run the PostgreSQL backup which is maintained in a separate repository host.

Is the future of database management autonomous? Oracle has developed the world’s first Autonomous Database, which guarantees to cut your cloud services bill by more than half. In fact, it’s the cheapest database on the market today. In this blog we explore the ideas behind autonomous databases and how they may affect your infrastructure.

PostgreSQL is so flexible that can serve as a simple relational database, time-series data database, and even as an efficient and low-cost data warehousing solution. In this blog, we’ll see what a data warehouse is, why is it needed, and why PostgreSQL could be the best option for it.

Presto is a parallel distributed SQL engine that allows you to run interactive big data analytics queries on a wide variety of data sources. In this blog, we are going to show you how you can install it and use it with your existing RDBMS systems.

Nowadays, Big Data Analytics is a common task in a company and there are several ways to perform this task. In this blog, we’ll see what Apache Spark is and how we can use it to work with our PostgreSQL database.

This blog walks you through running PHP 5 applications with the latest version of MySQL 8.0 on CentOS 7 operating system. This blog is based on the real experience that we faced when we were working with an internal project that requires PHP 5 application to be running alongside our new MySQL 8.0 in the new environment.

Autonomous Database eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.

This blog provides an overview of the Data Lake concept. We’ll go through some of the changes in storing and processing unstructured data and available solutions either on-prem and in the cloud.

Managing privileges on a database can be a hard and time-consuming task if we’re working in large organizations or if you have a complex privilege structure created on the database side. In this blog, we’ll see how we can cope with the database user management by using roles and how to use them on MariaDB.

Big data processing and data warehousing plays an important role in analytics, forecasting, statistical reports, and more. This blog will help MySQL DBA's leverage the MariaDB ColumnStore (a columnar-storage engine system which is part of MariaDB AX) for these types of tasks.

This blog provides an overview of the migration process between MySQL Enterprise 8.0 and MariaDB 10.3. In this blog post, we’ll go through some of the most important differences as well as the migration procedures.

This guide discusses the options available to IT leaders when bringing in open source databases into their environments as well as general information on the open source database market.