PART 2 This is the second blog in our series comparing different database management systems. In the last blog we looked at different data structures and their corresponding database management systems. In this part of the blog series we will consider different use cases best suited to each system. Introduction All Database Management Systems have […]
Introduction With so many options and a consistently growing number of new technologies becoming available every year, the world of databases and data stores can be confusing or hard to keep up with. And with Oracle’s recent 18c release being mainly based around their autonomous database which may revolutionize the DBA domain all together, we […]
Although Larry started his presentation last week with a small faux-pas and members of the audience had to wait for the correct slides, waiting is definitely not something customers can expect from the Oracle Cloud with the new 18c Database. Everything will be better, faster, and most importantly “self-driving”. Highlights of the launch featured the […]
In this blog, we show how we created a Datastax Cassandra cluster on Oracle Cloud Infrastructure (OCI) using Terraform and benchmark Oracle Cloud baremetal machines running Cassandra stress. 1. Steps to Create the Cluster Go here to download the Terraform projectFollow the guide to setup your environment Edit the file env-vars and fill in all the relevant […]
Choosing a Cloud Service Provider (CSP) isn’t easy. Much like finding and falling in love with a significant other, selecting and committing to the correct CSP can be like a marriage; with all the risks and benefits. Therefore it is important for companies to make carefully considered decisions when choosing a CSP as a partner […]
PART 4 In the last blog we examined different relational database offerings and considered some of their unique features and differences. In this blog we will compare and evaluate different NoSQL offerings, starting with Document Stores. This is done in an attempt to highlight some of the key differences between otherwise similar technologies. We also […]
n this blog we will compare the network performance of instances in OCI and AWS. The Network is a sensitive resource in multi-tenant environments, and is usually one of the first contributors leading to diminished performance when the environment is oversubscribed. In AWS there is a concept of Placement groups. Network performance is optimized between […]
The focus of this article would be cloud specific steps rather than repeating already well known steps in the net.Its purpose is only to give you an idea for an use case and should not be used in a production environment. The high level setup: Source:Two nodes (VirtualBox) Oracle Linux 7.Oracle Grid Infrastructure 12.2 .Oracle […]
High Level Project description In this article we describe migration of Standalone Oracle DB to 2 Node RAC with Physical Standby, from one datacenter (DC1) into another datacenter (DC2) without direct connectivity between the datacenters. The goal is to switch to DC2, and in DC2 “RAC primary + standby” configuration needed to be activated immediately. […]
Well configured ssh environment may save a lot of your time and is less error prone. Here we are going to cover the most common case where a client needs to access an application server which is behind a gateway server/bastion host. Later on we are going to build on this setup to add port […]
Almost any web based tool in the office will have it. And we ignore it by default, without thinking about it. And it was ok to do so. Before cloud days. NOT ANYMORE… Lets think about it for a bit. Before Cloudwe connected to all of these web (https) based tools via Intranet, internal network. In […]
The following Blog discusses the process and results of testing I/O performance of an Oracle Database running on Oracle’s Cloud Infrastructure (OCI) compared to the same database running on Amazon Web Services (AWS). The Oracle Stress Testing Tool (SLOB) was used to test Data Load Performance, IOPS, physical random single-block reads and single block writes. […]
This article shows how to install and configure OCI command line under Linux OS. It also covers some features that may ease your life when using the tool like: profiles, output filtering, generating and reusing templates for creating objects in the cloud. Install. The “new” OCI command line tool is actually a next version of […]
This article describes how to take a local to your premises backup of an Oracle database and to store it in OCI, formerly known as Oracle Bare Metal Cloud. Depending on your connectivity to the cloud service this could be useful for small to medium size database backups.At the moment of writing Oracle offers a […]
Oracle introduced two type of cloud services. OCI (Oracle Cloud Infrastructure) Formerly called Bare metal cloud, and OCI Classic. In this blog I will cover Oracle Cloud infrastructure. OCI Provides two type of shapes: Virtual machine and Baremetal, We can select virtual machine or bare metal while creating instance and selecting shape in OCI. Bare metal prefix with BM, […]