El Carro: Run Oracle Databases on Kubernetes
1–10 of 28 posts
Re: El Carro: Run Oracle Databases on Kubernetes
#2Note: i never really considered putting oracle in kubernetes to be a technical problem; since you can pass a “raw” block device from a distributed block storage.
I consider it to be a licensing nightmare as the normal oracle license means you’ll need to license every single vCPU on the cluster.
The express edition used here has some relatively anaemic usage limits which you could brush up against very quickly:
“Oracle Database 18c Express Edition automatically constrains itself to the following resource restrictions;
2 CPU threads; 2 GB of RAM;and 12 GB of user data.”
Still, it’s cool, but I would caution anyone against introducing an oracle dependency.
Re: El Carro: Run Oracle Databases on Kubernetes
#3Note: i never really considered putting oracle in kubernetes to be a technical problem; since you can pass a “raw” block device from a distributed block storage. I consider it to be a licensing nightmare as the normal oracle license means you’ll need to license every single vCPU on the cluster. The express edition used here has some relatively anaemic usage limits which you could brush up against very quickly: “Oracl…
I've never used Oracle and, given it's reputation, never will. Is there anything that it does better than other databases?
Re: El Carro: Run Oracle Databases on Kubernetes
#4Note: i never really considered putting oracle in kubernetes to be a technical problem; since you can pass a “raw” block device from a distributed block storage. I consider it to be a licensing nightmare as the normal oracle license means you’ll need to license every single vCPU on the cluster. The express edition used here has some relatively anaemic usage limits which you could brush up against very quickly: “Oracl…
I've never used Oracle and, given it's reputation, never will. Is there anything that it does better than other databases?
Quite a number of things but I’m scared to list them for fear of someone here thinking it might be a good idea to play with it.
Things that oracle does right: high availability, consistency of data (which is harder than you think, and the tools we use tend to use are genuinely crap at this especially things like MySQL and MongoDB which are insanely popular), performance of OTLP workloads, and support*
Your mileage may vary on that last point.
Re: El Carro: Run Oracle Databases on Kubernetes
#5Earlier quoted context omitted.
I've never used Oracle and, given it's reputation, never will. Is there anything that it does better than other databases?
Quite a number of things but I’m scared to list them for fear of someone here thinking it might be a good idea to play with it. Things that oracle does right: high availability, consistency of data (which is harder than you think, and the tools we use tend to use are genuinely crap at this especially things like MySQL and MongoDB which are insanely popular), performance of OTLP workloads, and support* Your mileage ma…
A more appropriate comparison against Oracle database would be MS SQL Server, or even Postgres, no?
MySQL/MariaDB is a different product class with different priorities, and MongoDB is a "NoSQL" product.
Re: El Carro: Run Oracle Databases on Kubernetes
#6Earlier quoted context omitted.
Quite a number of things but I’m scared to list them for fear of someone here thinking it might be a good idea to play with it. Things that oracle does right: high availability, consistency of data (which is harder than you think, and the tools we use tend to use are genuinely crap at this especially things like MySQL and MongoDB which are insanely popular), performance of OTLP workloads, and support* Your mileage ma…
A more appropriate comparison against Oracle database would be MS SQL Server, or even Postgres, no? MySQL/MariaDB is a different product class with different priorities, and MongoDB is a "NoSQL" product.
Mysql, Postgres and Oracle are closer than ever in functionality, but I don’t think postgres/mysql alone can compare to “Oracle”, but if you compare postgres+greenplum/citus/XL or mysql+Vittess to Oracle+RAC that’s pretty close, but you’ll probably need to choose from a few extras to get all the way there. The key difference is Oracle is doing it all in one monolithic stack.
Re: El Carro: Run Oracle Databases on Kubernetes
#7Earlier quoted context omitted.
Quite a number of things but I’m scared to list them for fear of someone here thinking it might be a good idea to play with it. Things that oracle does right: high availability, consistency of data (which is harder than you think, and the tools we use tend to use are genuinely crap at this especially things like MySQL and MongoDB which are insanely popular), performance of OTLP workloads, and support* Your mileage ma…
A more appropriate comparison against Oracle database would be MS SQL Server, or even Postgres, no? MySQL/MariaDB is a different product class with different priorities, and MongoDB is a "NoSQL" product.
MySQL directly competes.
But Postgres and MSSQL are the true equivalents, you’re right.
Correctness is hard was my main comment. There’s a whole class of other database types, but oracle can do NOSQL document storage just fine.
Postgres and MSSQL can too, especially the former, but there are some weird quirks, like having documents larger than 16KiB means they’re stored off-row in a compressed TOAST table. Which hurts performance a lot.
Re: El Carro: Run Oracle Databases on Kubernetes
#8I'm curious about this for tangential reasons. Does it allow you to pass through actual raw storage and network devices to the container?
Re: El Carro: Run Oracle Databases on Kubernetes
#9Note: i never really considered putting oracle in kubernetes to be a technical problem; since you can pass a “raw” block device from a distributed block storage. I consider it to be a licensing nightmare as the normal oracle license means you’ll need to license every single vCPU on the cluster. The express edition used here has some relatively anaemic usage limits which you could brush up against very quickly: “Oracl…
I've never used Oracle and, given it's reputation, never will. Is there anything that it does better than other databases?
For most (but not all) purposes, PostgreSQL is approximately as good, the devil is in the details of your specific application. Oracle is a competent OLTP system but it makes a different set of tradeoffs than PostgreSQL. For geospatial performance, as an example, neither platform clearly wins -- it goes back and forth depending on the details of what you are doing.
The tl;dr: start with PostgreSQL and evaluate from there.
Re: El Carro: Run Oracle Databases on Kubernetes
#10If, like me, you at some point need to support Oracle coming from Postgres there are a few annoyances you should be aware of:
- No boolean type. Different folks will choose T/F chars, Y/N chars or 0/1 integers. - Strings are not nullable. An empty string and a null string are the same thing. - Date also has time.
By default, you end up with some very annoying bugs. Expect to actually change the way some of your columns work.