Problem Having decided to move our Oracle databases to the cloud, we now want to build equivalent VMs as database servers.  This is simple enough when we have only one or a very small number of databases. But this can…

This post is the first part of a series of blog posts regarding the lifecycle and management of tombstones. Deleting and expiring data in Cassandra is something that you should carefully plan. Especially if you’re about to delete a massive…

With the current focus on data science, data engineering and the game-changing advantages of doing data lakes or warehouses in the cloud, all the major cloud providers continue to strengthen their data-related services and tools. On this front, Microsoft has…

ProxySQL is a great tool. It’s one of the most recommended technologies in our Open Source Database practice. Many of our clients are running it or are migrating towards it, but we’ve seen that it is pretty CPU-intensive. We’ve also…

Kubernetes is an open-source container orchestration system for automating deployment, scaling and management of containerized applications. Running a SQL Server database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to provision stateful containers using persistent volumes,…

I will go through detailed steps here on how to recreate a disk group used by CRS. Some things to bear in mind: – I created this cluster based on another existing cluster, so I just followed the same patterns…

Due to complex requirements for service relocate and restore as part of patching, I decided to script the process. Requirements: Existing configuration: Save existing services affinity: Note: /tmp/service_hawk*.conf is read-only to prevent accidental overwrite. Patching starts from instance1 and relocate…

Exadata 19c comes with Linux 7 and Exadata 12c and 18c come with Linux 6. There will then be an upgrade to Linux 7 when upgrading from 12c or 18c to Exadata 19c or above. In this specific case, you…

The Oracle Cloud Infrastructure, also known as the second generation cloud, offers an integrated command line utility called OCI Command Line Interface (CLI) which can be used to perform almost all the activities we can do using the web console….

Creating deep learning models using Keras is pretty straightforward, which is why Keras is often used for prototyping and creating proof-of-concept products. But when it comes to using it for training bigger models or using very big datasets, we need…