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 name/Oracle SID: dbmas The migration plan is basically to copy the database from A to the new server B and take over the old IP address from A. Using […]
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 may use this method to promote the DR site, while the production site is running and accessible, commonly to test out if DR […]
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 found out the MongoDB services couldn’t be started at all and were generating trap exceptions in dmesg. This simply means the MongoDB binary was unable […]
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 maintained, providing redundancy and distributing read traffic across multiple servers. In this blog post, we’ll discuss MySQL replication, including types, architecture, and best practices. Types of Replication MySQL supports several […]
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 normal, with a bit higher load due to data copying/streaming/compressing which depending on the backup command and database size. We can use xtrabackup to re-sync our replication […]
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 blocked except DDL), with a bit higher load due to data copying/streaming/compressing (depending on the clone command). Consider the following 2-node MySQL 8.0 Replication setup: […]
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 KDE 1 in July 1998. It had since moved away from Red Hat’s distribution and became a completely separate […]
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 the client connectivity from MaxScale server. This requires local repository to be configured correctly. In this example, we are going to deploy our […]