Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Amazon’s Consumer Business Turned Off Final Oracle Database

aws.amazon.com

Post reply on HN
Print view View original

181–190 of 471 posts

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

#181

Post by mypalmike »

zentiggr wrote: post #141
mumblemumble wrote: post #12

Earlier quoted context omitted.

It is not. Amazon accomplished the task by building their own Oracle replacement. You have to be approximately as large as Amazon for that to be a realistic option. If you'd like to use the alternatives that Amazon built, you can, of course, migrate to Amazon Web Services. Though, if you dislike the vendor lock-in you're experiencing with Oracle, and are considering Amazon as a good place to flee to, you possibly hav…

Thank you for mentioning the departure fee... That just took AWS off the table for me unless I'm pushed into it by other (paying) parties.

I believe the parent is referring to the price of the bandwidth that would be required for transferring data from AWS to somewhere else.

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

#182

Post by toyg »

chrisseaton wrote: post #152
Mountain_Skies wrote: post #112

Earlier quoted context omitted.

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…

> My company for technical reasons can't switch to OpenJVM The OpenJDK (not 'OpenJVM', that's not a thing) is literally 100% the same build as Oracle JDK now. There can't be any technical reason.

It might be the magic "support" word - random openjdk builds don't bring any commercial guarantees.

This said, the likes of RedHat, Amazon and Azul are pretty happy to offer those guarantees, and I bet their prices are lower than Big Red O.

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

#183

Post by koolba »

irrational wrote: post #89

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.…

> any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))

What does this refer to? AFAIK, you can invoke functions just about anywhere including in the ORDER BY clause:

    => CREATE FUNCTION some_func (int) RETURNS int AS $$ SELECT $1 + 1; $$ LANGUAGE SQL;
    CREATE FUNCTION

    => SELECT t.* FROM (SELECT 1 AS a) t ORDER BY some_func(t.a);
    a 
    ---
    1
    (1 row)
Are you referring to not being able to reference column aliases in an ORDER BY clause? (work around is to use a subquery)

    => SELECT 1 AS a ORDER BY some_func(a);
    ERROR:  column "a" does not exist
    LINE 1: SELECT 1 AS a ORDER BY some_func(a);

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

#184

Post by brianmc21 »

Mountain_Skies wrote: post #112
drawkbox wrote: post #59

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…

We were told not to download any new versions of java due to oracle trying to extract money for it. Basically we are going to do the same.

Purge every oracle product slowly but surely

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

#185

Post by csomar »

danbtl wrote: post #132
Mountain_Skies wrote: post #112

Earlier quoted context omitted.

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…

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

I think he complained about licensing fees?

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

#186

Post by kungito »

vbezhenar wrote: post #143
y4mi wrote: post #75

Earlier quoted context omitted.

How? Its an Open source implementation of the java vm which they don't own.

Why do you think that they don't own OpenJDK? Here's snippet from "OpenJDK: How to contribute" page: > Like many other open-source communities, the OpenJDK Community requires Contributors to jointly assign their copyright on contributed code. If you haven't yet signed the Oracle Contributor Agreement (OCA) then please do so, scan it and e-mail the result to oracle-ca_us(at)oracle.com. Please make sure to specify Open…

Well they definitely can just like Microsoft can with all their open source projects which require CLA and all the other big corps with same open source model but the already published code also stays under the currently assigned license. They can only change newer version's licese which would probably cause a fork and do more damage than help

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

#187

Post by toyg »

IronWolve wrote: post #168

Oracle goes after customers with 3rd party companies, if you use oracle expect calls for audits and more licenses. You download virtualbox extension at work? Thats a fee per user. Use an Oracle VM in a vmware cluster? They want paid for all cores in your environment now. Seriously, Oracle goes after their customers like criminals. I refuse their calls at work, they really are just looking for something to make you pa…

> Oracle goes after customers with 3rd party companies

That's going to end soon - the partner ecosystem has been royally shafted by Oracle's big "cloud push", people are moving away from a vendor who simply sold them down the river; and in their Brave New Cloud World, there is no need for license resellers and auditors.

Ironically, that might end up improving Oracle's reputation - they'll just be seen like Google, where everything is automated and support goes from mediocre to nonexistent.

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

#188

Post by CydeWeys »

wwarner wrote: post #99
wmf wrote: post #93

Earlier quoted context omitted.

If the amazon product catalog depends on Aurora, then when Aurora has an issue, so does Amazon retail. Because one-off internal IT never goes down? This isn't a good argument, especially since AWS wants to handle their other customers' availability.

No, not at all, but it rarely goes down at the same time. I mean, I could be wrong, but that's my read of the announcement. Another issue with the managed services is that they don't provide total control over configuration, which is a complete show stopper for a large high performance data store.

A lot of large cloud outages are caused by networking problems, which do tend to bring everything down.

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

#189

Post by LrnByTeach »

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 scale. Customers regularly report cost savings of 90% by switching from Oracle to AWS.

>Performance Improvements – Latency of our consumer-facing applications was reduced by 40%.

>Administrative Overhead – The switch to managed services reduced database admin overhead by 70%.

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

#190

Post by didibus »

zentiggr wrote: post #141
mumblemumble wrote: post #12

Earlier quoted context omitted.

It is not. Amazon accomplished the task by building their own Oracle replacement. You have to be approximately as large as Amazon for that to be a realistic option. If you'd like to use the alternatives that Amazon built, you can, of course, migrate to Amazon Web Services. Though, if you dislike the vendor lock-in you're experiencing with Oracle, and are considering Amazon as a good place to flee to, you possibly hav…

Thank you for mentioning the departure fee... That just took AWS off the table for me unless I'm pushed into it by other (paying) parties.

It's not really a fee. It's just the price they charge you for data transfer to external systems. This is known as Data Egress charges and all cloud providers I know off has it. The cost of egress will depend on which service you are using. Some services have lower data transfer out costs, some have higher, etc..
Post reply on HN