Oracle 11g Migration to a New Server
Migration Plan Old Oracle server, A: 192.168.221.23 (RHEL 6 x86_64) New Oracle server, B: 192.168.221.66 (RHEL 7 x86_64 with better hardware, disk subsystem and processor) Database…
Read articleThe DataSpeed notebook
Ideas worth sharing.
Practical perspectives on database performance, reliability and the open-source tools behind it all.
9 articles
MongoDB Primary Switchover While Production is Running – Activating DR to be Primary
Introduction In this blog post, we are going to share our method on performing a primary switchover of a MongoDB Sharded Cluster from a production site to a disaster recovery site. You…
Read article
Solving MongoDB Upgrade Error: “trap invalid opcode ip”
Introduction While working with one of our clients, we were facing an issue during the upgrade process from MongoDB 4.4 to MongoDB 5.0. After installing the new MongoDB 5.0 packages, we…
Read article
MySQL Replication: Types, Architecture, and Best Practices
Introduction MySQL replication is a powerful tool for building high-availability systems and scaling read-heavy workloads. Replication allows for multiple copies of the database to be…
Read article
Creating Vagrant Box
A vagrant box is a pre-packaged virtual machine image that can be used with Vagrant to create and configure virtual development environments. A box typically includes an operating system…
Read article
Backup Streaming using Percona Xtrabackup from Master to Slave for MySQL 5.6
Backup using xtrabackup does not lock the database, which can be performed online with very minimal disruption to the production database. The database server should be operating like…
Read article
Backup Streaming using MySQL 8.0 Clone Plugin to Slave
For MySQL 8.0, we should use the clone plugin to clone InnoDB tables to another server without blocking. While cloning is happening, the source server can operate normally (nothing is…
Read article
Installing Galera Cluster 8.0 on SUSE Linux Enterprise Server 15
SUSE Linux Enterprise Server (SLES) is not a new distro in the market. It has been existed for the past 21 years ago, where the first release was based on Red Hat Linux (version 5.1) and…
Read article
MariaDB MaxScale Offline Installation for CentOS 8
For offline installation, a number of things have to be configured in the first place: SELinux is disabled, or set permissive mode. A mysql client is optional but recommended to test out…
Read article