Live data from Hacker News

Amazon’s Consumer Business Turned Off Final Oracle Database

aws.amazon.com

201–210 of 471 posts

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#202

Here is the meat of the Report: >We migrated 75 petabytes of internal data stored in nearly 7,500 Oracle databases to multiple AWS database services including Amazon DynamoDB,Aurora, RDS, and Redshift. >We kept careful track of the costs and the performance, and realized the following results: >Cost Reduction – We reduced our database costs by over 60% on top of the heavily discounted rate we negotiated based on our…

How did they negotiate a discount when they weren’t yet able to move off the database? ‘Give us a discount or...’ or what?

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#203
post #167

We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time.…

I wonder: How long before someone adds a patch to PostgreSQL as a 'compat' patch, or extension.

I believe EnterpriseDB sells something like that.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#204
post #185
post #132

Earlier quoted context omitted.

I'm curious, what are the technical reasons OpenJVM won't work for you?

I think he complained about licensing fees?

But licensing fees aren't 'technical issues'. You say 'technical' to mean not related to things like licensing.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#206

We've been working on migrating from Oracle to Postgres for a few years now. We are about 2 weeks from being finished. It is not for the faint of heart, but it is totally worth it. The documentation is much much better, performance is equivalent or better, the sql dialect is saner, etc. Other than moving the data itself (ora2pg was invaluable for this), rewriting the queries is what has taken the most amount of time.…

Very useful - anyone using oracle should try to use ANSI keywords now to avoid work in the future, always use COALESCE instead of NVL, use ANSI date functions, etc.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#207

The video feels like a big middle finger to Oracle. "stop oracle", and the URL https://aws.amazon.com/products/databases/freedom . Not that I'm complaining, Oracle deserves all the hate they get for their business practices. But associating AWS with "breaking free" is extremely ironic. It's just as much of a source for vendor lock in as Oracle. If you are not extremely careful/dedicated with your system design, you a…

In the same vein of oracle trying the one-ring-to-bind them, RDS is amazing on many levels, but AWS is all in on database lockin with their customers. RDS probably affords enough flexibility to get your data out, but Dynamo... that's a different story.

Aurora actively makes me want AWS to have my data. It's the only thing that AWS has that I miss on a daily basis.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#208

Here is the meat of the Report: >We migrated 75 petabytes of internal data stored in nearly 7,500 Oracle databases to multiple AWS database services including Amazon DynamoDB,Aurora, RDS, and Redshift. >We kept careful track of the costs and the performance, and realized the following results: >Cost Reduction – We reduced our database costs by over 60% on top of the heavily discounted rate we negotiated based on our…

How did they negotiate a discount when they weren’t yet able to move off the database? ‘Give us a discount or...’ or what?

I'd guess it goes something like, "We have 75 petabytes of data to move over and would like to use your services but are concerned about costs. What kind of prices can you give us?".

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#209

Earlier quoted context omitted.

In 2001/2003, I led a small team at an agency that converted Kraftfoods and 50+ brands from 25+ ATG Dynamo web/app CMS servers + 20+ Oracle servers to .NET 1.0 CMS on 3 web servers, 3 app servers and 3 Microsoft SQL Servers. Even then Oracle tools were horrible for developers and still are. The only reason they had that many databases was Oracle's business is licensing, massive, expensive licenses, and their sales pu…

Oracle's new licensing requirement for Java is a bit threat to that platform. My company for technical reasons can't switch to OpenJVM so we're going to pay Oracle their new licensing money but we're not doing any greenfield Java development and are going to work towards moving our Java applications to another platform. That's an n=1 example but wouldn't be surprised if others end up migrating away, causing longterm…

So rewriting everything onto a new platform is cheaper and less risky than doing the work to break dependencies on Oracle JDK? I know nothing about your situation, but it sounds to me like you've made a mistake somewhere.

Re: Amazon’s Consumer Business Turned Off Final Oracle Database

#210

Earlier quoted context omitted.

How did they negotiate a discount when they weren’t yet able to move off the database? ‘Give us a discount or...’ or what?

I'd guess it goes something like, "We have 75 petabytes of data to move over and would like to use your services but are concerned about costs. What kind of prices can you give us?".

But they’ve got no choice - there’s no ‘or else’ until they’re able to move off.

What stopped Oracle charging them a billion dollars a CPU for the last few years since they’ve already announced they were moving off?

Post reply on HN