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

Oracle’s Cloud Licensing Change

oracle-base.com

Post reply on HN
Print view View original

11–20 of 241 posts

Re: Oracle’s Cloud Licensing Change

#11

Post by rosser »

pallopiipaeri wrote: post #9
brad0 wrote: post #3

Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?

MySQL and Postgres have multi-master replication. They do NOT have distributed transactions (with the distributed locking system etc). For some customers it is important. Others have delusions that they need it. Oracle has other products as well. I am generally aware of couple used widely. Their ESB is one of the heavy players, and some sausage stands always need the most advanced ones. The funny thing is that with O…

Postgres has two-phase commit, which can be used at the application level to implement distributed transactions.

It does not have multi-master replication natively, though there are companion projects that enable it.

Re: Oracle’s Cloud Licensing Change

#12

Post by toyg »

brad0 wrote: post #3

Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?

Qualify "people". For many classes of enterprise applications (BI etc), mysql and postgres are not even a choice, it's all about oracle/sql server/db2.

Pg and mysql dominate developer-centric operations, but business-first environments are a very different game. There, it's all about long sales cycles and long feature-lists that only big vendors can afford.

Re: Oracle’s Cloud Licensing Change

#13

Post by echelon »

How much longer do you all think Oracle will be around as a company? They burned all bridges with engineers long ago, and they're not going to be able to keep selling their blatant and expensive lock-in strategy to management.

Maybe when they finally do go under Google will be able to buy Java and MySQL...

Re: Oracle’s Cloud Licensing Change

#14

Post by Illniyar »

brad0 wrote: post #3

Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?

The Oracle database is a beast, both in terms of performance, performance tuning and features.

It probably out performs MySQL and Postgres in most areas - and if you don't do horizontal scaling, then Oracle is probably your best bet if you want to get the most out of a server.

I don't think there are any advantages of going to vertical scaling over horizontal scaling these days.

Re: Oracle’s Cloud Licensing Change

#17

Post by toyg »

pallopiipaeri wrote: post #9
brad0 wrote: post #3

Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?

MySQL and Postgres have multi-master replication. They do NOT have distributed transactions (with the distributed locking system etc). For some customers it is important. Others have delusions that they need it. Oracle has other products as well. I am generally aware of couple used widely. Their ESB is one of the heavy players, and some sausage stands always need the most advanced ones. The funny thing is that with O…

> Oracle's JavaEE application server is kind of nice

You mean Weblogic, right? Because OAS has been dead for a while now. Afaik, Weblogic and Websphere are practically the same, hard to say one is "just plain inferior" to the other.

Re: Oracle’s Cloud Licensing Change

#18

Post by tlogan »

brad0 wrote: post #3

Is support the only reason people choose Oracle databases over something free like MySQL or Postgres?

Here are some reasons (things I used in past):

- ASM

- DataGuard

- FlashBack Query

- RAC

- PL/SQL (the worst language ever but very useful for building packages inside database)

- Window Functions

- Transparent Data Encryption

- online reorg

- RMAN and online backup

Oracle as a company is terrible. But Oracle RDBMS is a mean machine. Do not underestimate it.

Re: Oracle’s Cloud Licensing Change

#20

Post by keypusher »

rosser wrote: post #11
pallopiipaeri wrote: post #9

Earlier quoted context omitted.

MySQL and Postgres have multi-master replication. They do NOT have distributed transactions (with the distributed locking system etc). For some customers it is important. Others have delusions that they need it. Oracle has other products as well. I am generally aware of couple used widely. Their ESB is one of the heavy players, and some sausage stands always need the most advanced ones. The funny thing is that with O…

Postgres has two-phase commit, which can be used at the application level to implement distributed transactions. It does not have multi-master replication natively, though there are companion projects that enable it.

PG 9.6 brought bidirectional replication in and supported via mainline extension (no patches).

http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/

Post reply on HN