Miscellaneous

How to Send a TDE Encrypted Backup to Someone Outside Your Organization

Once you enable your database to be encrypted with Transparent Data Encryption (TDE), the physical database files, and the database backups are encrypted.  If your database and database backup are encrypted, then how can you send the encrypted backup to a person outside your organization? The easiest way to share a TDE enabled database to …

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 …

Installation

MySQLHK: Installation of MySQL

My favorite way of MySQL installation is to go with tar ball. It is easy, simple and manageable. There is also other thoughts people would think the tarball has many limitations and restrictions in terms of package dependency and functional incompatibility with the OS. If certain functions are not available in generic tarball but they …

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 …