Infrastructure at your Service

Cloud Archives - Page 5 of 7 - Blog dbi services

Oracle Team

Créer une base Oracle sur le Cloud en quelques clicks

By | Database Administration & Monitoring | No Comments

By Franck Pachot . Il n’a jamais été aussi facile de créer une base Oracle. Et ceci grâce au Database as a Service (DBaaS). C’est l’occasion de tester le cloud: Oracle Cloud Service offre une version d’essai de un mois. Si vous êtes proches de Genève, passez nous voir lors du SITB les 26-27 avril: http://www.dbi-services.com/fr/events-fr/swiss-it-business-sitb-du-26-au-27-avril-2016/ Mais j’ai aussi fait une video pour montrer comment créer sa base sur le Cloud de A à Z.

Read More
Oracle Team

Cloning a PDB to the Oracle Cloud Service

By | Database Administration & Monitoring | 3 Comments

By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access the VM. However, from the VM you can’t access your own network. You need it to move data between from on-premises or private cloud to the public cloud. Or to setup a Data Guard between…

Read More
Daniel Westermann

The Postgres Plus® Cloud Database

By | Database Administration & Monitoring | No Comments

In the last posts (1, 2, 3, 4, 5) I looked at PostgreSQL in Amazon RDS. Another option you have if you want to go to the cloud is to use the The Postgres Plus® Cloud Database offered by EnterpriseDB. I will not go through the whole setup here as this is described in detail here. So once you went through the registration and setup process you should be able to login. The login URL…

Read More
David Hueber

About SSH keys in Oracle Public Cloud

By | Database Administration & Monitoring, Technology Survey | No Comments

When working with resources on the Oracle public cloud, whatever it is IaaS or PaaS, the principle access method is based on SSH keys exchange. Once our instance is created this is going to be the first and only way accessing it. Of course afterward additional ports/services can be opened. However the question is how to manage these keys and how important are they?

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Loading the beast

By | Database Administration & Monitoring | No Comments

The last posts outlined how you can bring up a PostgreSQL instance in the Amazon cloud, how you can restrict access to the instance, how you can configure it and how you can add a read replica. In this post we’ll look at how you can load data to the instance. A database without data does not make much sense, does it? For having some data available to load I’ll populate my local PostgreSQL 9.4…

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Adding a replica to the beast

By | Database Administration & Monitoring | No Comments

In the last post I looked on how you can change the PostgreSQL parameters when the instance is running in the Amazon cloud. In this post we’ll look at how to add a replica to the PostgreSQL instance that is already running. Even if you push things to the cloud you want to make sure that you have a standby database in case the master crashes. At best the replica is running in another data…

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Configuring the beast

By | Database Administration & Monitoring | No Comments

In the last post I looked at how you can strengthen the security for your PostgreSQL instance in Amazon RDS. In this post I’ll look at how you can configure your PostgreSQL instance. When you login to the Amazon console and select your running instance the screen looks like this: If you want to modify the instance there is a “modify” entry in the “Instance Actions” menu: This brings you to the main configuration page…

Read More
Daniel Westermann

PostgreSQL on Amazon RDS – Securing the beast

By | Database Administration & Monitoring | No Comments

In the last post I looked at how to bring up a PostgreSQL instance in the Amazon cloud. In this post I’ll look into how to restrict access to this instance to specific IP addresses to strengthen security. If you think about moving things to the cloud you for sure want to make the stuff accessible to restricted people or systems only. On the left side there is a “Security Groups” menu which sounds like…

Read More