3 ms·

I would love to see a technical justification for doing this, especially that references strengths gained in a cloud environment.

discodave 8y ago
I imagine a major justification, especially for Amazon, is to stop paying Oracle $$$. I'm not sure if you consider that a technical, or a business justification, but I don't really see a distinction here. Some more strictly technical justifications would be: * Aurora has the potential to be a better architecture in the long run because it has something closer to an active/active redundancy, rather than Oracle's primary/secondary architecture, where fail-overs are manual and/or prone to failure. * Aurora can also scale out to larger database sizes than Oracle.
- withhighprod 8y ago
  Exactly it’s order of magnitude larger then the second largest customer of oracle not too long ago
- grumpydba 8y ago
  Oracle has had active/active for years. It's called RAC and costs around one arm.
  - wiredfool 8y ago
    But if the primary arm goes down, they’ll have your leg take over payments.
  - chasil 8y ago
    Oracle Standard Edition used to cost around $8k/core. Now Standard Edition 2 costs $17k/core, but I believe it includes a license to use Real Application Clusters (RAC), justifying the price hike. Not much justification if you're only running a single instance, though.
    - grumpydba 8y ago
      This is insanely expensive indeed. And limited to one socket per node.
      - chasil 8y ago
        Here is the price list: https://www.oracle.com/assets/technology-price-list-070617.pdf https://www.oracle.com/assets/technology-price-list-070617.p... SE2 processor license is $17,500. Enterprise processor license is $47,500.
        thorin 8y ago
        Interesting, I don't think I've ever seen a comprehensive price list before and I've worked with Oracle for 20 years. Generally I've been somewhere with a site licence so you can use almost anything or used XE and bought standard one for production.
        glogla 8y ago
        But SE2 (and formerly SE1) is 17500 per socket, while Enteprise is 47500 per core. There's also core scaling factor, which used to be 0.5 for Xeon. So single 8 core CPU is 17500 with SE2, but 40.547500.
rst 8y ago
The main justification for some people will be getting away from Oracle's ... quirks, regarding both technology and business practices. The cloud environment for many folks will just be an added fringe benefit. (Note also that if "cloud" is all you want, and you're comfortable with Oracle otherwise, Oracle is loudly touting their own.)
grumpydba 8y ago
Oracle license management is technically difficult and consumers a lot of brainpower. Oracle is also a hairy beast, kind of the perl of databases: there's always more than one way to do it.

discodave 8y ago

I imagine a major justification, especially for Amazon, is to stop paying Oracle $$$. I'm not sure if you consider that a technical, or a business justification, but I don't really see a distinction here. Some more strictly technical justifications would be: * Aurora has the potential to be a better architecture in the long run because it has something closer to an active/active redundancy, rather than Oracle's primary/secondary architecture, where fail-overs are manual and/or prone to failure. * Aurora can also scale out to larger database sizes than Oracle.

withhighprod 8y ago
Exactly it’s order of magnitude larger then the second largest customer of oracle not too long ago
grumpydba 8y ago
Oracle has had active/active for years. It's called RAC and costs around one arm.
- wiredfool 8y ago
  But if the primary arm goes down, they’ll have your leg take over payments.
- chasil 8y ago
  Oracle Standard Edition used to cost around $8k/core. Now Standard Edition 2 costs $17k/core, but I believe it includes a license to use Real Application Clusters (RAC), justifying the price hike. Not much justification if you're only running a single instance, though.
  - grumpydba 8y ago
    This is insanely expensive indeed. And limited to one socket per node.
    - chasil 8y ago
      Here is the price list: https://www.oracle.com/assets/technology-price-list-070617.pdf https://www.oracle.com/assets/technology-price-list-070617.p... SE2 processor license is $17,500. Enterprise processor license is $47,500.
      - thorin 8y ago
        Interesting, I don't think I've ever seen a comprehensive price list before and I've worked with Oracle for 20 years. Generally I've been somewhere with a site licence so you can use almost anything or used XE and bought standard one for production.
      - glogla 8y ago
        But SE2 (and formerly SE1) is 17500 per socket, while Enteprise is 47500 per core. There's also core scaling factor, which used to be 0.5 for Xeon. So single 8 core CPU is 17500 with SE2, but 40.547500.

rst 8y ago

The main justification for some people will be getting away from Oracle's ... quirks, regarding both technology and business practices. The cloud environment for many folks will just be an added fringe benefit. (Note also that if "cloud" is all you want, and you're comfortable with Oracle otherwise, Oracle is loudly touting their own.)

grumpydba 8y ago

Oracle license management is technically difficult and consumers a lot of brainpower. Oracle is also a hairy beast, kind of the perl of databases: there's always more than one way to do it.