News for hackers. Stuff that matters.

A comment on Azure Database for MySQL and PostgreSQL. Parent comment

Re:Azure Database for MySQL and PostgreSQL by kamathsun on Wednesday May 10, 2017 @01:57PM (#14310170)
You can scale by clicking on the Pricing tier. However note that scaling operations currently only support within a service tier. i.e, scaling up/down within Basic and scaling up/down within standard. Ability to scale across service tiers will come soon. /works at Microsoft and the managed PostgreSQL service /
[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by ankushio on Wednesday May 10, 2017 @06:29PM (#14312315)
I tried out this feature in the Basic tier, but my I see downtime during the scaling up of the instance.

I opened a psql console and ran "BEGIN; SELECT CURRENT_TIMESTAMP; SELECT pg_sleep(200); SELECT CURRENT_TIMESTAMP; COMMIT;"

I see the error "server closed the connection unexpectedly"

[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by kamathsun on Wednesday May 10, 2017 @08:51PM (#14313097)
The application should have logic to re-try connections. When you scale, there is a brief moment ~30-45seconds when the app wont be able to connect to the database and then resumes if you re-try connection. /I work at Microsoft on the managed PostgreSQL service/
[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by martinknafve on Thursday May 11, 2017 @12:52AM (#14313900)
How do you accomplish no application downtime if for 45 seconds you can't connect to the database?

In background processes you might get away with retrying connections for a minute but most users will probably consider your site broken if page load time is 45 seconds.

[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by GordonS on Friday May 12, 2017 @04:08AM (#14322216)
That's a rather... 'liberal' use of 'no application downtime'.
[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by philliphaydon on Wednesday May 10, 2017 @02:04PM (#14310227)
Any idea if plv8 extension will be added soon?
[ Parent | on HN ]
Re:Azure Database for MySQL and PostgreSQL by kamathsun on Wednesday May 10, 2017 @02:27PM (#14310417)
Please provide feedback here - https://feedback.azure.com/forums/597976-azure-database-for-...
[ Parent | on HN ]