9 ms·
Azure Database for MySQL and PostgreSQL
- justinclift 9y agoWow. If someone had suggested this would happen last year, I would have said pigs would fly first. /me looks outside for flying pigs. Yep, there they are, whole groups of them going by in formation. ;)
- meetbhagdev 9y agohttps://media.giphy.com/media/l3vR2Dr1As9J002T6/giphy.gif https://media.giphy.com/media/l3vR2Dr1As9J002T6/giphy.gif :)
- niklasrde 9y agoWell, this happened today at work: http://imgur.com/AsezmPp http://imgur.com/AsezmPp
- gressquel 9y agogreat stuff from Microsoft this. Now people can run Wordpress on azure withouth install mysql on a seperate instance.
- bebop 9y agoI think you may have posted this on the wrong announcement. This is for Postgres on Azure. There is another thread about mysql :)
- dang 9y agoWe merged that thread (https://news.ycombinator.com/item?id=14309662 https://news.ycombinator.com/item?id=14309662) into this one, so now the thread can be about both.
- partiallypro 9y agoIt seems it's still better to run mySQL on a VM if you're running multiple databases for smaller sites. But for single sites that need to scale, it's way better than ClearDB, which is hot garbage if you ask me.
- lima 9y agoWhy?
- partiallypro 9y agoIf you're asking why I think it's still better to run a VM for multiple databases, my answer is pricing. If you're asking why I think ClearDB is hot garbage, it's because of pricing, in ability to scale down (you literally cannot scale down ClearDB in Azure), connection limits on the DB that make no sense with the pricing, etc.
- barking 9y ago"Azure Database for PostgreSQL" Postgresql database for Azure?
- kalmi10 9y agoNo, this is a PaaS offering that includes high-availability, fault-tolerance and disaster recovery, and uses a customized version of PostgreSQL behind the scenes.
- kamathsun 9y agoWe are using community edition of PostgreSQL and the same PostgreSQL we all love. /works at Microsoft and the PostgreSQL managed service/
- meetbhagdev 9y ago+1
- notatoad 9y agoTo me (and, i think, in general product naming conventions), "Azure for Postgres" would mean some sort of azure service plugin that you can add to any arbitrary postgres installation. "Postgres for Azure" would mean Postgres support on Azure's PaaS.
- insulanian 9y agoRDS was the main reason I stuck with AWS all this time. Happy to see MS recognizing that PostgreSQL is very much preferred these days.
- pianoben 9y agoBetter late than never - this is a welcome alternative to Amazon's RDS support for postgresql, the lack of which has been the primary reason I've kept personal workloads off of Azure. I'm excited to take this for a spin! Azure SQL Server has been great at work; operationally, it couldn't be simpler, and the point-in-time restore feature saved our bacon at least once. The only drawback has been... SQL Server itself. It's a solid performer, but T-SQL is a bear to work with. If MSFT can apply the same operations magic to postgres, they'll have a real winner on their hands.
- thom 9y agoWhat kind of things have been annoying you about T-SQL?
- pianoben 9y agoAs a preface, let me say that SQL Server is great so far. It's rock-solid, and the query planner is wonderful. T-SQL itself is my only real gripe. That said, here are a few things that annoy me: The major bummer during development was, for me, the lack of a command to drop a schema and all the things in it. I've found the ability to `DROP SCHEMA IF EXISTS foo` to be invaluable when iterating on DB designs. In T-SQL, the alternative is to maintain a "drop-all.sql" file, which is tedious and error-prone when making use of foreign-key relationships. (more generally, postgres' DDL seems more ergonomic) I miss the simplicity of postgres' upsert capabilities. T-SQL has MERGE, which is vastly more complicated and verbose. I get that it is quite powerful and flexible, but I've never personally needed more than upsert semantics, and the design of MERGE means that I pay (in esoteric syntax) for features that I don't use. Table-valued params are an adequate substitute in T-SQL for postgtresql array parameters, but driver support outside of .NET is middling at best, so our Java code gets a little dodgy when using them. Despite the more recent introduction of JSON support in SQL Server, there is no true equal to `json` or `jsonb` types. There's simply no substitute in Azure SQL for the variety of procedural languages available in postgresql; T-SQL, as a procedural language, is just not very easy to work with. I'd much prefer python, perl, or even plpgsql itself. Finally, I miss the ability to add comments on tables, columns, procs, etc, directly in SQL. Those are the things that immediately impact me; others may not be bothered at all.
- ankushio 9y agoThe landing page says "With Azure Database for PostgreSQL, you can scale the performance of your database with no application downtime". I don't see an option to scale the Postgres database in my Azure Portal. Is this feature not available yet?
- kamathsun 9y agoYou 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 /
- philliphaydon 9y agoAny idea if plv8 extension will be added soon?
- kamathsun 9y agoPlease provide feedback here - https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-...
- deleted 9y ago[deleted]
- ankushio 9y agoI 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"
- kamathsun 9y agoThe 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/
- rattray 9y agoHonestly, I'm flat-out impressed by what I'm seeing from Azure these days.
- meetbhagdev 9y ago:)
- shontnew 9y ago:)
- SaloniSonpal 9y ago:-)
- philliphaydon 9y agoThis is absolutely great news. Just a word of warning, plv8 extension isn't available in the preview: https://docs.microsoft.com/en-us/azure/postgresql/concepts-extensions https://docs.microsoft.com/en-us/azure/postgresql/concepts-e... Apart from the lack of that extension, ah so exciting. <3 PostgreSQL.
- meetbhagdev 9y agoLoving the excitement! We are actively reviewing feedback in the public preview. Make sure you record your feedback here: https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-... :)
- philliphaydon 9y agoSubmitted. :) https://feedback.azure.com/forums/597976-azure-database-for-postgresql/suggestions/19232863-plv8-extension https://feedback.azure.com/forums/597976-azure-database-for-...
- macieksarnowicz 9y agoWe are planning on gradually adding more extensions. If you have your favorite one, please submit it at the feedback link above.
- caleblloyd 9y agoMicrosoft azure product links for those looking: MySQL: https://azure.microsoft.com/en-us/services/mysql/ https://azure.microsoft.com/en-us/services/mysql/ PostgreSQL: https://azure.microsoft.com/en-us/services/postgresql/ https://azure.microsoft.com/en-us/services/postgresql/
- shontnew 9y agoHere are the pricing links https://azure.microsoft.com/en-us/pricing/details/postgresql/ https://azure.microsoft.com/en-us/pricing/details/postgresql... https://azure.microsoft.com/en-us/pricing/details/mysql/ https://azure.microsoft.com/en-us/pricing/details/mysql/
- lmickh 9y agoSo is a "compute unit" the same as the "Azure Compute Units" that are used to measure VMs? 800 ACU roughly comes out to 4 cores. At $0.78/hr, that is hardly comparable to the RDS offerings. Didn't see an indication of memory. Much like SQL Server DTUs and DWUs, the spacebucks measurements only seem to useful for hiding the actual price comparisons. At least they stopped the DTU/DWU non-sense for these services.
- kamathsun 9y agoCompute units are a measure of computing throughput for your instance with pre-configured amount of RAM. We do not count hyperthreads as core. So 100 compute units is 1 core, 200 compute units is 2 cores, etc. /works at Microsoft and managed PostgreSQL service /
- lmickh 9y agoThanks. Apparently I completely missed that in the FAQ.
- karmelapple 9y agoDoes it say what the pre-configured amount of RAM is? Also, does it talk about what level of admin rights I can get to these machines?
- GordonS 9y agoUsing 'DTUs' for SQL Database and both 'Compute Units' and IOPS for PostgreSQL & MySQL makes it rather difficult to compare the services. Any advice on how to compare performance for a given price?
- SaloniSonpal 9y agoYou can also find the details here: https://docs.microsoft.com/en-us/azure/postgresql/concepts-compute-unit-and-storage https://docs.microsoft.com/en-us/azure/postgresql/concepts-c...
- sbuttgereit 9y agoWhat looks compelling about the PostgreSQL offering as compared to AWS RDS is that it looks like you get a PostgreSQL cluster rather than a single database in a shared cluster. At least reading the documentation for creating a DB implies that (https://docs.microsoft.com/en-us/azure/postgresql/quickstart-create-server-database-azure-cli https://docs.microsoft.com/en-us/azure/postgresql/quickstart...). For me, it might remove some blockers to moving some clients to a cloud managed database solution that had always been there with AWS RDS. If that follows through and pays off for having a proper PostgreSQL super user in the database environment available for use (what I really want), that can make certain things much more do-able (brings new things you have to watch out for, too, but... pick your battles).
- macieksarnowicz 9y agoThank you for your feedback. We indeed offer a whole server (database cluster) and you can create multiple databases in it and have full control of the resources allocated to that cluster. The admin user provisioned for the server is not a full superuser, but it is close to that. We are trying to find the right set of permissions to provide to our customers without jeopardizing our ability to manage this server for you. Please submit your feedback here: https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-... if you see a problem with the permissions.
- sciolistse 9y agomacieksarnowicz is shadowbanned for whatever reason, but he answered: Thank you for your feedback. We indeed offer a whole server (database cluster) and you can create multiple databases in it and have full control of the resources allocated to that cluster. The admin user provisioned for the server is not a full superuser, but it is close to that. We are trying to find the right set of permissions to provide to our customers without jeopardizing our ability to manage this server for you. Please submit your feedback here: https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-... if you see a problem with the permissions.
- 9y ago
- sandGorgon 9y agoUnfortunately, still not available in the India datacenter. This is going to be huge in India. Microsoft has massive mindshare in India with the govt because of the regulatory landscape. I have it on firsthand info that several banks in India are going to make their first ever transition to the cloud on Azure because of Microsoft's willingness to go the extra mile around whatever security dances that the banks want them to do. Plus Azure has India datacenter which takes of the PII problem for healthcare and financial data. It is truly unfortunate that the management console has the worst UX ever.
- macieksarnowicz 9y agoOur plan is to be in all the Azure regions before we GA the service. We will be gradually expanding our presence over the next months, based on available capacity. Please speak up if you have a region where we are not present yet.
- Roritharr 9y agoWill this also be available in the German Azure Datacenter that is managed by T-Systems?
- macieksarnowicz 9y agoOur goal is to be present in all Azure locations, including the national clouds. Cannot yet say how quickly we will get there, please stay tuned.
- kamathsun 9y agoWe will come to India soon :-) /works at Microsoft and managed PostgreSQL service/
- tracker1 9y ago> It is truly unfortunate that the management console has the worst UX ever. I think that title goes to AWS...
- tlear 9y agoNice, starting new project and this looks like the way to go for us. Postgres <3 Need to check if available in Japan yet
- kamathsun 9y agoWe are in Azure Japan East and Japan West regions today! /works at Microsoft and managed PostgreSQL service/
- yilu331 9y agoPlease add/vote what are most critical PostgreSQL extensions you want to have in Azure Database for PostgreSQL. https://feedback.azure.com/forums/597976-azure-database-for-postgresql https://feedback.azure.com/forums/597976-azure-database-for-...
- kamathsun 9y agoPlease read my blog about Azure Database for PostgreSQL here -https://azure.microsoft.com/en-us/blog/announcing-azure-database-for-postgresql-preview/ https://azure.microsoft.com/en-us/blog/announcing-azure-data... /I work at Microsoft on the managed PostgreSQL service/
- phlai 9y agoIts exciting to see Azure grow its offering to compete Amazon and Google.
- denois 9y agoGood news. AWS is way too complex for startups. Azure is much simpler and don't require a separate DevOps department :D
- philliphaydon 9y agoHow is AWS complicated? I struggle more with Azure than I do with AWS. And I've used Azure more than I've used AWS...
- abrookewood 9y agoJust a word of caution: be very careful to check the latency between the DB tier and the VM tier. We had to abandon a multi-month deployment to Azure because the latency was too high and it caused all sorts of issues with our app. To be honest, our DB access approach wasn't great (heaps of really small requests), but we couldn't re-architect it in the timeframe we had. We were also doing this in Sydney, so maybe it was just a localised issue (the Australian data centres are relatively new). Anyway, hopefully they have that sorted - we need more competition!
- kaeshiwaza 9y agoIs it possible to create a replicate user and then replicate to a local server ?
- kaeshiwaza 9y agoA quick try show me that it's very very slow... Like 1s for a very simple query on a quite small database. I tried from a scaleway server (in France).