I am using a PostgreSQL database in a web application deployed on United Kingdom bluemix region (eu-gb.bluemix.net). I chose the UK region just because it is the nearest to the customer.
My question is where my database will be actually hosted, as a single page request from the user may result in several SQL queries. I tried "Compose for PostgreSQL" and "ElephantSQL" (a third-party PostreSQL with size limit of only 20MB for the free plan) services. I think (based on the host ip) that ElephantSQL deploys the database in the same region where I created my space but Compose is always hosted in US.
Do I have any control on where my database is created?
Answer by SimonHeywood (41) | Jan 10, 2017 at 02:16 PM
For Compose it depends on the account creating the services.
All Bluemix accounts using an IBM email address will deploy to an IBM sandbox in US Dallas regardless of the Bluemix region used.
Bluemix public will deploy to the relevant datacenter for the Bluemix region. You can see a list of the Softlayer datacenters on the Compose support site.
Thanks @SimonHeywood for this information, Therefore I'd better move the application to the US South region.
Some services not available in UK Region ? 2 Answers
Apps and services in different regions 1 Answer
Connection to PostgreSQL service with Django 1 Answer
How to migrate Bluemix application in US South to UK ? 1 Answer
unable to connect PHP to compose postgreSQL, "Call to undefined function pg_connect()" 1 Answer