• ERR_CERT_AUTHORITY_INVALID invalid certificate authority error. Ignore it?

    In IT world, we all used to this error: 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 Cloud we connected to all of these web (https) based tools via Intranet, internal network. In most cases it was no way traffic would go through Public Internet, as it was no public connectivity to the tools.
  • 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 formerly bmcs. It is now called simply oci. The installation process is fully automated you just need to run the following command under the user you plan to use it.
  • 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 terabyte of redundant storage for about 26 USD/month.
    For bigger databases this solution would not be practical. An option would be to create a standby in the cloud and to backup it locally to the cloud.Thus the only concern would be the redo log generation against your outbound traffic.

    Local setup:
    OS: Oracle Linux 7
    Oracle Database 12c Enterprise Edition Release 12.2
    (ASM, the sample schema installed only)
    Oracle Cloud Infrastructure command line interface 2.4.10 (configured and ready to use)

    Remote cloud setup:
    Basically you would need a valid account that have the rights to create object storage.
    You can assign the following policy to grant the minimum rights for this task:

    Allow group MyBackupGroup to manage buckets in tenancy  
    Allow group MyBackupGroup to manage objects in tenancy  
    

  • 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 of the most comprehensive benchmarking suites for SSD. It replicates the SNIA Solid State Storage (SSS) Performance Test Specification (PTS) Enterprise v1.
  • 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, it’s columnar store persists on disk. When look from filesystem level, columnar store data consists of a lot of small files.