Hate oracle personally. But when Amazon mention cost savings, I assume they're not at list price for normal aws customers like us?
Article mentions that, yeah - cost savings are based on their already heavily discounted deal with Oracle.
Amazon’s Consumer Business Turned Off Final Oracle Database
31–40 of 471 posts
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#32In my mind the true "hard part" would be in migrating business logic that lives in Oracle stored procedures (PL-SQL). Are there any tools that do a decent job in translating procs to non-Oracle dialects?
I haven't used it in quite awhile but as I recall ora2pg[0] has some basic auto-conversion of PL-SQL.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#33The very fact that they are dogfooding DynamoDB (with core features of their business) makes me want to take it more seriously and use it more. I also love that they didn't just replace Oracle with but instead thoughtfully pieced together a strategy based on what the data was going to be used for. Well done!
Have used DynamoDB a couple times, most recently for data processing.
It is extremely expensive, for data storage and performance. Queries are limited and cumbersome to write.
If you are looking at it, put a reasonable amount of test data in and play with it too see what costs look like compared to the performance you need from it.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#34Is this not a case study that anyone can leave Oracle now, if an Amazon scale install can?
It shows that a big company like Amazon, hiring thousands of SDEs still needed other vendors software than their own, because of all that time they spent in hiring and firing people and obsessing over their customers needs. sarcasm
[deleted]
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#35Earlier 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…
Most places likely aren't using Oracle at Amazon's scale, either. I suspect that one of MySQL, Postgres or Microsoft SQL Server can fill in for Oracle if you have access to the source code and can make changes yourself. (If you've bought software that is Oracle-only, then it's not an option -- but it wasn't an option for Amazon, either). I suspect that in a lot of cases, this will pay for itself, but it might take 10…
>Microsoft SQL Server
Out of the frying pan, into the fire.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#36The developer carrying it out still using 2015 MBP
Is that a...big deal? It's just 2015. Most of my coworkers use 2015 models because they prefer them.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#37I wonder if anyone here has seen any net new adoption of Oracle DBs in the last few years? It was an absolute juggernaut 10-15 years ago and has rapidly tanked their reputation and spread their business across software, services and cloud with mixed results. Is it actually still growing or just milking their stodgy enterprise customers for more money?
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#38Migrating everything to the same externally-available cloud infrastructure is exactly the thing that Google needs to do, but has been failing at for going on a decade now. Yes, I'm bitter about it.
It's not even on the radar for them I believe. Maybe ask again in another ten years.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#39> The migration gave each internal team the freedom to choose the purpose-built AWS database service that best fit their needs, and also gave them better control over their budget and their cost model. Anyone know of a comprehensive resource that we could use to figure out which DB to use?
Here’s an algorithm which I believe to be 95% accurate:
If only a single user/device needs to access the data: use SQLite. In all other cases: use PostgreSQL.
Re: Amazon’s Consumer Business Turned Off Final Oracle Database
#40> The migration gave each internal team the freedom to choose the purpose-built AWS database service that best fit their needs, and also gave them better control over their budget and their cost model. Anyone know of a comprehensive resource that we could use to figure out which DB to use?
The og-aws Slack or ##aws on freenode
But really, you should understand what kind of data store you need based on your use case is first and then decide on an implementation later...