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 […]
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, […]
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 […]
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, […]
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 […]
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 […]
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
One of the big use cases for Oracle Cloud Infrastructure (OCI) formerly known as Baremetal Cloud is noSQL and newSQL. Oracle states 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, […]
DSE 5.0.7, Spark 1.6.3 Accessing Spark Accessing spark from outside the spark cluster Spark SQL Pyspark Scala Spark Job Spark Thrift / Beeline note Difference between thrift query and spark-sql query, is that thrift server uses a shared SparkSQL context whereas Spark SQL does not. Accessing Cassandra Materialized Views from Spark users_by_email_mview is a materialized […]
Configuration: DSE 5.0.6 (See Datastax Cassandra on AWS for Installation Details) so when you start dse spark or dse spark-sql, in spark UI, you can see 3 out of 4 cores allocated Verification: Finding the spark master Spark Web UI: http://<node1>:7080Now in http://:4040/stages/, we can see 1 Fair Scheduler Pool, with schedule mode as FAIRFrom AWS […]
Here is a quick example how to install Oracle Braremetal cloud cli on MacOS or Linux.Please note what oracle just renamed Braremetal cloud to Oracle Cloud Infrastructure (OCI) First thing first – python. I recommend to start with Python 3.6 or later. Oracle says python 2 is also supported, but when I tried bmcs installed […]
Setting up AWS EC2 Instance Type: m4.xlarge, 4 node cluster, 2 in each AZStorage: Two EBS volumes, data volume 400GB, 150GB log volume, root volume 150GB (General Purpose SSD)OS:Amazon Linux AMI 2016.09.0 (HVM), SSD Volume Type – ami-b953f2daThe Amazon Linux AMI is an EBS-backed, AWS-supported image. The default image includes AWS command line tools, Python, Ruby, Perl, […]