@neekz0r yep. I’ve been an Oracle database admin for the past 5-ish years and am seeing the light now 😂. Better late than never.

@sharpgeek Hah, I don't envy you. Have you been sued yet?

Personally, I've never dealt with oracle DB, of which I am thankful for.

I'd be really interested though, from a technical perspective and in the weeds discussion on what you see as lacking in open source solutions vs oracle db.

@neekz0r I spent about a year migrating different db's from Oracle to MySQL and honestly the disadvantages came down to purely business/political. My past clients would rather have paid Oracle license fees for "out of the box" solutions for HA/DR, etc, backed by Oracle support instead of internal talent or consultants. The one thing that always came up with MySQL specifically was ACID compliance (nevermind that Oracle owns them now). I'm digging into PostgreSQL and MSSQL this year. We'll see what I learn.

@neekz0r I should clarify, those that migrated to MySQL were perfectly happy to rely on tools built by communities of tech people NOT tied to Oracle. But for the rest of my past companies.... that would have been almost literally sacrilegious.

@sharpgeek Yikes.

I hate(d) mysqls implementation for replication. When I last used it, it was a single-threaded bin file and thus always a bottle neck on servers that had a lot of write/update ops.

Now-a-days, i'm (thankfully) pretty removed from the underpinnings of SQL and just use AWS RDS services.

@neekz0r yeah I 100% rejected projects involving write heavy MySQL dbs. I think in version 5.7 they may have changed some things to make it slightly better but I haven’t had reason to look into it.

I’m curious. With AWS RDS have you run into any performance issues at the db level or does amazon truly handle that stuff behind the scenes?

@sharpgeek It's handled behind the scenes. Don't get me wrong; if you have developers creating varchar(256) indexes you can still get in trouble, and it's no replacement for sharding and such if your app needs it.

But all in all, you create the instance, tell it how many availability zones you want, and that's that. If you need more horsepower, you upsize it. Snapshots are taken care of and there is any easy path for multiple region DR.

A few caveats that can catch people by surprise.

@ted PLEASE don’t tell Uncle Larry (Ellison) that I found out 😰

@sharpgeek it's really okay, he couldn't really wrap his head around the concept of there being others.

Which did you decide to try?

@ted On the Database side of my adventures, Microsoft SQL Server (it’s probably going to pay some bills) and PostgreSQL have my full attention for now.

@sharpgeek I know what you're saying, but I really want that to be a Bill Gates pun.