Blog

Please visit us on medium for more blogs

Visit Now
Business
Cloud
February 14, 2018

Choosing the Right Cloud Service Provider (CSP) for 2018: Things to Consider

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 […]

Read More
Database
NoSQL
February 10, 2018

A Manager’s Guide to the Database Galaxy – Part 4 (NoSQL Document Stores)

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 […]

Read More
AWS
Benchmarking
Oracle Cloud Infrastructure (OCI)
December 17, 2017

OCI and AWS 10Gbit network test

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 […]

Read More
Database
Oracle
Oracle Cloud Infrastructure (OCI)
December 14, 2017

Create a physical copy of your local database in Oracle Cloud Infrastructure with no backup.

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 […]

Read More
Database
Oracle
November 24, 2017

Oracle Standalone DB -> RAC + Standby Migration

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. […]

Read More
Tips & Tricks
November 23, 2017

Easy ssh tunneling and port forwarding

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 […]

Read More
Cloud
Tips & Tricks
November 20, 2017

ERR_CERT_AUTHORITY_INVALID invalid certificate authority error. Ignore it?

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 […]

Read More
AWS
Benchmarking
Oracle Cloud Infrastructure (OCI)
November 14, 2017

Benchmarking Oracle’s DBaaS against RDS – A Performance Comparison.

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. […]

Read More
Oracle
Oracle Cloud Infrastructure (OCI)
November 14, 2017

OCI command line setup and some interesting features

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 […]

Read More
November 4, 2017

What is Oracle Cloud Infrastructure (BareMetal Cloud). How to implement resources in OCI.

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, […]

Read More
November 4, 2017

On-premises RMAN backup placed in a storage object on Oracle Cloud Infrastructure.

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 […]

Read More
AWS
Benchmarking
Oracle Cloud Infrastructure (OCI)
October 30, 2017

Oracle Cloud Infrastructure NVMe SSD vs AWS local storage. Broader test.

In this blog we compared Oracle Cloud Infrastructure baremetal local NVMe SSD with AWS instance NVMe store on MemSQL use case. MemSQL load mostly concerned about concurrent writes, and relatively large reads. Thins blog will do broader test, covering most performance aspects of SSD. Will use Cloud Harmony Block storage project for benchmarking. In my opinion it is one […]

Read More
AWS
Benchmarking
Oracle
October 30, 2017

Oracle Cloud Infrastructure vs AWS. NVMe SSD test for MemSQL use case – 2

One of the big use cases for Oracle Cloud Infrastructure (OCI) formerly known as Baremetal Cloud is noSQL and newSQL. Oracle says what big advantage on storage layer would be PCIe based NVMe SSD with super low latency. And elimination of virtualization layer would let it shine at full. While MemSQL row store is in-memory, […]

Read More
Business Intelligence
Datastax
Spark
October 23, 2017

Spark and Qlik Integration

Steps: Start Spark Thrift Server on Datastax Cluster Enable Qlik Server’s Security Group on AWS to access port 10000 (basically from qlik, need to connect to thrift server port 10000) Install Simba ODBC Driver for Spark on the Qilk Windows EC2 InstanceCreate System DSN as follows: Spark Server Type: SparkThriftServer Host: internal-spark-thriftserver-prod-lb-861234576.ap-southeast-1.elb.amazonaws.com (DNS name of […]

Read More
NoSQL
Spark
October 20, 2017

Spark SQL Query Explain Plan

DSE 5.0.6, Spark 1.6.2 Example 1 From cqlsh, below query works Below query does a Full Table Scan(FTS) Below query does not do FTS, because leading partition key column is txn_status Below query does not return result at all if txn_date is not cast Example 2 Example 3 Example 4 Example 5 CATEGORIES

Read More