Maximizing Storage I/O Performance for Microsoft SQL Server workloads on Oracle OCI IaaS.

Running Microsoft SQL Server on Oracle OCI IaaS can deliver excellent performance, but only if the storage layer is designed and validated correctly. Too often, performance issues are attributed to the database engine while the real bottleneck sits in an improperly configured or untested storage setup. In this article, I walk through a storage configuration specifically designed for SQL Server workloads on Oracle OCI, focusing on block volume layout, attachment type, and I/O characteristics. The setup is not theoretical: it…

Continue ReadingMaximizing Storage I/O Performance for Microsoft SQL Server workloads on Oracle OCI IaaS.

How to setup a linux Virtual IP Failover (IP Floating) on Oracle OCI managed by pacemaker

Introduction In many environments, it is still essential to use infrastructures with an active/passive Linux cluster, which require the use of IP floating. In cloud infrastructures, the secondary IP address must be managed not only by the operating system but also by the cloud infrastructure. In this tutorial, we will see how the IP floating of a Linux cluster can be managed as an integrated resource by Pacemaker, in a simple manner and without custom code, as seen in several…

Continue ReadingHow to setup a linux Virtual IP Failover (IP Floating) on Oracle OCI managed by pacemaker

Establish a VPN with Oracle OCI with a dynamic public IP ADDRESS on CPE

Oracle Cloud Infrastructure (OCI) does not support the use of Domain Name System (DNS) for configuring the Customer Premises Equipment (CPE) as the VPN tunnel endpoint. This tutorial aims to enable small businesses that do not have access to a static public IP address to use the IPSec service even with a dynamic address. The strategy involves deploying a script capable of automatically generating a new OCI tunnel whenever the public IP of the Customer Premises Equipment (CPE) changes. In…

Continue ReadingEstablish a VPN with Oracle OCI with a dynamic public IP ADDRESS on CPE