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…
Today I had a look at PostgreSQL in Amazon RDS. Once you have an Amazon AWS account (this requires a valid credit card for verification) setup bringing up a PostgreSQL instance is pretty easy. The first 12 months are free but be sure to read about the restrictions and what is terminated by default and what is not. Once your…
By Franck Pachot . Remember my first try of Oracle cloud when Larry Ellison announced the Cloud in june? This week at OOW15 Larry Ellison announced that IBM is not a competitor anymore for them, then I checked IBM Cloud: IBM Bluemix offers IaaS, PaaS and SaaS. As I did in my first trial for Oracle, I’m testing the simplest…
By Franck Pachot . We experienced the first planned outage this week-end, so let’s see how it is notified and what happens. EMEA Commercial 2 – Amsterdam Outage notification before: subject: Announcement: Upcoming Mandatory Maintenance for Oracle Cloud e-mail date: 16 Octobre 2015 1:49 message: Start Time / End Time: Saturday, October 17, 2015 9:00:00 PM CEST – Sunday, October…
By Franck Pachot . In previous posts, I’ve installed SLOB on the Cloud Services, measured IOPS and CPU. There’s another resource that is even more important in a cloud environment: network. Tuneling port 1521 over ssh I’ve create a virtual instance by default where only ssh is opened: I don’t want to open other port, so I’m using it with…
By Franck Pachot . In the previous blog post I’ve measured the physical i/o performance, with SLOB. We can run the same with a small size of data and a large buffer cache in order to measure logical reads (LIOs) and CPU performance. What is an OCPU? Except if you are licensed in NUP, you are already used to pay…
By Franck Pachot . You buy resources on the Cloud, but they are mutualized, thanks to virtualization. Are you sure you have the resources you paid for? When it comes to Oracle databases there are 3 ways to test performances: Run an application, or a simulation of an application, such as the excellent SwingBench from Dominic Giles Run low-level calibration…
By Franck Pachot . When we give our trainings (dbi services workshops) we signal our best practices with this logo. It’s our know-how, acquired through experience, consulting, service desk, exchange at events, beta testing, etc. that we share with our customers. Let’s have a look at a few points that we recommend to change if you provision a database with…
By Franck Pachot . My first trial was not very good because I had access to Schema as a Service only. Which is not new. But Oracle Cloud Services is becoming now a reality, available for trial and available for general availability. Let’s see now how to use Database as a Service. Creation My goal here is to see what…
By Franck Pachot . The cloud has been annouced, I want to try. From the cloud.oracle.com/database website, there is Trial only for the ‘Database Schema Service’ so I asked fot it, received an e-mail with connection info and it works: Good. The password was temporary, so I have to change it, and set answers to 3 within 4 questions…
The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used for simple SELECT SQL queries,…
The Ignite Event took place in Chicago last week. According to what has been presented, here are the first news about the new SharePoint 2016! SharePoint 2016 looks like an enhancement of the existing SharePoint 2013 version. Most of the SP2013 features will continue to work but in a more powerful way. SharePoint 2016 will be focused on the following…
