Addressing common challenges when scaling out MySQL horizontally

When we explore strategies to scale our MySQL-based database layer, we realize that there are many different options. As opposed to proprietary solutions, open-source products nourish themselves from their communities and novel architectures or enhanced versions are generated, often incorporating…

Read More >

Inspiration and Announcements from Microsoft Inspire 2019

Thousands of Microsoft partners and employees filled T-Mobile Arena in Las Vegas on July 15 for the kick-off of Microsoft’s three-day partner event, Microsoft Inspire. Microsoft executives shared their thoughts on the tremendous growth opportunities of the continued digital transformation,…

Read More >

Using rsync to Copy GoldenGate Trails from DBFS to ACFS

I am currently working on project to migrate GoldenGate trail from Oracle Database File System (DBFS) to Oracle Automatic Storage Management Cluster File System (ACFS). The migration is performed in two phases. This is the first phase, in which I create…

Read More >

How to Test MySQL Server Hostname with ProxySQL Multiplexing

Overview While working on a MySQL Galera cluster with ProxySQL, I was in the process of testing traffic going to the MySQL nodes by using the @@hostname command to ensure which MySQL host behind the proxy the query ran on….

Read More >

How To Delete MGMTDB and MGMTLSNR Using emcli

Problem: MGMTDB and MGMTLSNR are running on only one host at a time and when relocated, will be paged unnecessarily. One team member`s suggestion is to relocate MGMTDB and MGMTLSNR back to its original host. It does not make sense having…

Read More >

How to fix error when MySQL client fails to load SQL file with Blob data

In one of my latest database restore jobs, I was helping a MySQL client with issues related to mysqlbinlog and I wanted to share it here. In case you didn’t know, MySQL is a simple SQL shell with input line…

Read More >

How to Upgrade Grid Infrastructure to 18c

Now that Oracle Grid Infrastructure (GI) 19c has been released, it is time to upgrade your GI to 18c! I am presenting here a well-tested procedure to upgrade your Grid Infrastructure to 18c. It has been designed and applied on…

Read More >

How to install 18c Grid Infrastructure in Silent Mode on Linux 7

This blog post will show you how to install 18c Grid and upgrade to 18.6.0.0. 1. Download the 18c binairy and Apr, 2019 PSU: 18c Grid: https://download.oracle.com/otn/linux/oracle18c/180000/LINUX.X64_180000_grid_home.zip Apr 2019 PSU: https://updates.oracle.com/Orion/Services/download/p29251992_180000_Linux-x86-64.zip?aru=22869122&patch_file=p29251992_180000_Linux-x86-64.zip OPatch 12.2.0.1.17: https://updates.oracle.com/Orion/Services/download/p6880880_180000_Linux-x86-64.zip?aru=22870225&patch_file=p6880880_180000_Linux-x86-64.zip 2. Prepare OS for Oracle installation,…

Read More >

A look at new features Azure SQL Database Serverless and Hyperscale

Last May, the Microsoft Build 2019 conference took place in Seattle. A number of new features and capabilities were announced and demonstrated. This week, communities in the Asia Pacific held their own version of Build, bringing the best and the…

Read More >

How to mine an RMAN Log

I wanted to compare Oracle Recovery Manager (RMAN) backup to an existing NFS versus a NEW backup appliance. I performed a Proof Of Concept (POC) to compare and contrast NFS and NEW, backed up both, then mined the logs to…

Read More >
Page 3 of 34712345...10...Last Page »