Category: Miscellaneous

Miscellaneous

The Data Charmer: Using MySQL 8.0: what to expect

MySQL 8.0 will be GA soon (just my assumption: Oracle doesn’t tell me anything about its release plans) and it’s time to think about having a look at it. If this is your first try of MySQL 8, get prepared for several impacting differences from previous versions. In this article I won’t tell you what …

Miscellaneous

Does GPU hardware help Database workloads?

Graphics processing units or GPUs are dedicated highly parallel hardware accelerators that were originally design to accelerate the creation of images. More recently, folks have been looking at GPUs to accelerate other workloads like Database analytics and transaction processing (OLTP). Although GPUs have little or no use for OLTP style workloads, they have been shown to …

Miscellaneous

How to Get Started with ClusterControl

Managing database production systems takes a ton of work. Even with all the passion you can muster, it is never an easy undertaking. For one, the times when you had single database vendor are gone. The competition in the market is very strong. Developers, architects, everyone takes what’s best for their application. You regularly need …

Miscellaneous

MySQL Single Table Point-In-Time Recovery

In this blog post, I’ll look at how to execute a MySQL single table Point-In-Time Recovery. I recently wrote a blog post describing a different way of doing Point-In-Time Recovery (PITR). If you want to know the step by step, please visit the mentioned blog post. Here is a quick summary of the approach: Restore the …

Miscellaneous

Oracle 12cR2 Upgrade and the Alert Log

Oracle 12.2.0.1 offers a number of enhancements over version 12.1.0.2, but one of those enhancements may throw a ‘monkey wrench’ into any alert log monitoring that may be in effect. It’s a quiet change that won’t be noticed until alert log monitoring scripts no longer generate reports. In 12.2.0.1 the alert log timestamp changes to …

Miscellaneous

How to automate the auditing of operational best practices for your AWS account

With a microservices architecture, distributed teams often need a central operational excellence team to make sure that the rest of the organization is following operational best practices. For example, you might want to know if you configured lifecycle policy, versioning, and access policies properly for objects in an Amazon S3 bucket. Proper configurations ensure that …

Miscellaneous

Write Optimizations for Qualcomm Centriq 2400 in MariaDB 10.3.5 Release Candidate

MariaDB has been collaborating with Qualcomm Datacenter Technologies in pushing the performance envelop by leveraging innovative ARM-based hardware architecture with MariaDB’s unique database architecture.  As part of the Qualcomm Centriq™ 2400 product launch back in Nov 2017,  we demonstrated the strong read scalability of MariaDB on this chip.  Since then, MariaDB and Qualcomm engineering have …

Miscellaneous

How to Secure your PostgreSQL Database – 10 Tips

Once you have finished the installation process of your PostgreSQL database server it is necessary to protect it before going into production. In this post, we will show you how to harden the security around your database to keep your data safe and secure. 1. Client Authentication Control When installing PostgreSQL a file named pg_hba.conf …

Miscellaneous

How to install Apache, PHP 7.1 and MySQL on CentOS 7.4 (LAMP)

This tutorial shows how to install an Apache web server on CentOS 7 server with PHP (mod_php) and MySQL database. The acronym LAMP is short for Linux, Apache, MySQL, PHP. This updated tutorial shows the installation of the latest PHP versions (7.0, 7.1 and 7.2) on CentOS 7.4. 1 Preliminary Note In this tutorial, I use …