Infrastructure at your Service

Category Archives: Cloud

David Barbarin

Introducing SQL managed instances on Azure

By | Cloud, Database Administration & Monitoring | No Comments

I never wrote about data platform solutions on Azure so far. The fact is in Switzerland we’re definitely late about the Cloud adoption and Azure data platform solutions. There are different reasons that are more or less valid but I don’t want to contribute to any debate here. In any case the last announcements in this field with Azure data centers in Switzerland could encourage customers to reconsider this topic in the near future. Don’t…

Read More
Mehdi Bada

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 2

By | Big Data, Cloud, Development & Performance | No Comments

In this part of the blog posts series, we will show how ansible helps us to configure our cluster and install all pre-requisite needed for Cloudera Manager. Ansible is one of the most important automation tools currently. Ansible will help us to configure all nodes for a manual installation using Cloudera Manager. Our playbook will contain the following roles: cm_repo: add the same C.M repo into all nodes. os_config: Adjust all OS parameter for installing…

Read More
Oracle Team

ADWC: Creation of Autonomous Data Warehouse Cloud service

By | Cloud, Oracle | 4 Comments

By Franck Pachot . You want to try the Autonomous Data Warehouse Cloud Service? That’s easy. Here is a Step-by-Step. Cloud Credits First, you need Cloud Credits. You may have bought them (any recent negotiation with Oracle Sales, even for on-premises, involves some Cloud Credits). You can have a free trial with 300$ Cloud Credits available for 1 month. To get another month, you need a different e-mail address and different Credit Card number (not…

Read More
Mehdi Bada

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 1

By | Big Data, Cloud | No Comments

Deploying a Cloudera distribution of Hadoop automatically is very interesting in terms of time-saving. Infrastructure as Code tools such as Ansible, Puppet, Chef, Terraform, allow now to provision, manage and deploy configuration for large clusters. In this blog posts series, we will see how to deploy and install a CDH cluster with Terraform and Ansible in the Azure cloud. The first part consists of provisioning the environment with Terraform in Azure. Terraform features an extension…

Read More
Oracle Team

A free persistent Google Cloud service with Oracle XE

By | Cloud, Oracle | 3 Comments

By Franck Pachot . In a previous post I’ve listed several free online services which run an Oracle XE so that you can test your SQL easily. You may want use Oracle XE further, with full access to the database and its host, and still from a web browser. You probably have a Google account. Then you also have a Virtual Machine on the Google Cloud (0.5 vCPU / 1.70 GB RAM boostable to 1…

Read More
Mehdi Bada

Managing Oracle Big Data Cloud – CE with REST API

By | Big Data, Cloud, Oracle | 3 Comments

In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption of your cloud credits. We should first have a look at the official documentation so as to understand what the API is composed of. https://docs.oracle.com/en/cloud/paas/big-data-compute-cloud/csbdp/QuickStart.html  Use the following URL composition to get access to REST endpoint: https://region-prefix.oraclecloud.com/resource-path According…

Read More
Mehdi Bada

Oracle Big Data Cloud Service – Compute Edition

By | Cloud, Oracle | 4 Comments

In this blog post, we will see how to create a Big Data cluster through the Oracle Cloud Services. If you want more details about the Oracle Big Data cloud services offering, you can refer to my previous blog Introduction to Oracle Big Data. First, you need to create your trial account through the following link: https://cloud.oracle.com/tryit. Note that, when you create your trial account, all information (phone number, address, credit card…), must be from…

Read More
Oracle Team

Oracle Cloud: script to stop all PaaS services

By | Cloud, Oracle | No Comments

By Franck Pachot . With metered cloud services, keeping all your instances running may become expensive. The goal is to start them only when you need them. Here is a script that stops all instances you have on the Oracle Cloud Service PaaS. You can schedule it for example to stop them at the end of the business day, or when they are not active for a long time. The scripts use the REST API…

Read More
Oracle Team

Oracle Database to SQL Server 2016 TCO Analyzer

By | Cloud, Database management | No Comments

Today, many enterprises are striving to transform their IT organization from a cost center into a strategic asset and looking for ways to get more value from their application and data platform investments. To deliver on this vision, Microsoft SQL Server 2016 – via its on-premises, cloud, or hybrid deployment options – provides customers with significantly lower total cost of ownership (TCO) compared to existing Oracle DB platform. How to know the real difference in…

Read More
Olivier Toussaint

DBSAT un outil pour la sécurité de vos bases de données Oracle

By | Cloud, Database Administration & Monitoring, Database management | One Comment

Qu’est-ce que DBSAT ? C’est un outil gratuit d’Oracle que vous pouvez télécharger sur My Oracle Support avec comme référence : Doc Id 2138254.1. Il a pour but d’évaluer la sécurité de vos bases de données Oracle en analysant la configuration et les stratégies de sécurité mise en place afin de découvrir les risques liés à la sécurité. Comment cela fonctionne t-il ? Dans un premier temps il sera nécessaire de collecter les informations de…

Read More