[jjeaff]

Quoted from AWS:

>Amazon Aurora with MySQL compatibility is also built using MySQL https://aws.amazon.com/rds/mysql/what-is-mysql/

Tell me more about how uninformed I am...

Mysql won't even break a sweat for a few million records. I have run mysql databases with a single instance and billions of records with little optimization needed.

PostgreSQL is great for developers and I love some of the features it has that mysql doesn't (although mysql 8.0 has caught up quite a bit). But Postgresql is not nearly as battle tested for highly scaled implementations and in many cases will not perform as well as mysql.

I get the impression you have never actually built anything or you would know how so much of the internet runs on a php/mysql stack (think big, like Wikipedia).

And your comment about being zapped by 240v shows that you don't understand how electricity works. You could be zapped by 240v and barely feel it if you aren't grounded well. So to say you know what it is like to be zapped by 240v is like saying you know what it is like to get hit by a car. There are a million shades of grey of how that could end up.

[opless]

> Tell me how uninformed I am From https://aws.amazon.com/rds/aurora/ Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases.

Compatible As I understand it they're protocol compatible and that's it. I shall have to ask my guy at Amazon about it further as clearly it's somewhat ambiguous.

> MySql I've managed to happily provoke all manner of poor behaviour from MySQL and MariaDB. Some of it repeatable, with certain backends. I've used and admined MySQL since 98 or so. Enough to compare and contrast it with Ora/MSSQL/postgres.

Before I swore off the frankly horrid lamp stack about a decade ago, I had built quite a number of sites for SMEs, including Recruitment Agencies , A racing federation, A major airline ticketing company, I could go on, but I assure you that I'm not a noob as you suggested.

My point before, what just because LAMP stacks are well used, doesn't make them GOOD. It doesn't matter what's built with them. Even Facebook uses/used PHP, but it completely redesigned its own runtime IIRC.

> Shades of grey/240v I estimate that there's only about 50 ;)

Yes, get it going through your heart and you're toast, or you bridge live and neutral and your muscles contract stopping you from pulling away.

Anecdotally I've had bigger zaps from electric fences than mains.

Anyway my assertion still stands, MySQL is a toy database and should not be used in a critical environment.

LAMP stacks are horrible.

Arguing with a stranger over the internet is futile. :-)

Good night!

[jjeaff]

Spend 30 seconds educating yourself on Aurora. It's not ambiguous. It clearly says it on the AWS page I linked. MySQL compatible Aurora is a fork of MySQL with a modified storage engine. According to AWS's own docs, the performance increase is mostly a hardware play where they are replicating and striping the storage across various SSDs.

If you haven't used LAMP in 10 years, oh my. 10 years in the world of devops and software development might as well be an eternity. MySQL's InnoDB storage engine is a totally different animal that MyIsam.

Your experience is severely out of date and/or incorrect. You should keep it to yourself and avoid contradicting strangers over the internet when you know very little about what you are talking about.

[opless]

Yep. Just got a reply from my guy at Amazon who referred me to https://youtu.be/U42mC_iKSBg

Which clearly says compatible and goes into more depth than anyone really needs.

I would say this person would be authoritive, rather than documentation which is usually not written by the developers themselves. But you knew that already. Right?

So I educated myself. Maybe you should too :-)

"Mostly a hardware play", mmhm. That's contradicted by the video. But I can't be right can I? I don't have enough fake internet points! SMH

BTW my test with MySQL was only a few years ago, and it was InnoDB, thanks.

I should say I've not used LAMP stacks in anger for that period of time. I still very occasionally pick up php and still find the documentation woefully inadequate and wrong. Over time I've moved over to python for my hacky projects and whilst I still consider whitespace as syntax to be insane, it's actually easier to get stuff done.

You might disagree with my opinions, but disagreeing with my experience is quite embarrassing.

[jjeaff]

You do realize that MariaDB is also Mysql compatible? As is PerconaDB. No one is arguing that aurora isn't mysql compatible and that video doesn't contradict AWSs own website that says mysql compatible aurora is based on mysql.