Re:Why favor PostgreSQL over MariaDB/MySQL?
by manigandham on Tuesday September 05, 2017 @08:30PM
(#15180217)
Neither Netflix nor any of the top "startups" are anywhere near aggressive performance. In fact they're usually full of slow fragile tech that only looks great to blog about.
HFT, adtech, scientific engineering and many other industries are magnitudes farther ahead.
Re:Why favor PostgreSQL over MariaDB/MySQL?
by stephenr on Tuesday September 05, 2017 @12:28PM
(#15176716)
> no-ops deployment
This is the worst joke in tech really. Developers/Managers all jumping on the "cloud" bandwagon because "hey we don't need ops" and then you end up with "Galera is such a POS, you can't use it with RDS".. <facepalm>
Re:Why favor PostgreSQL over MariaDB/MySQL?
by otterley on Wednesday September 06, 2017 @01:53AM
(#15181521)
> If you really want no-ops deployment, use something that requires minimal amount of ops, like ElasticSearch. Just give it an obscene amount of RAM and it'll work fine for ages.
I can assure you this is not the case if your indexes are very large and their number is constantly growing, and/or clients are doing very complex queries that stress the system.
Re:Why favor PostgreSQL over MariaDB/MySQL?
by pas on Thursday September 07, 2017 @04:48PM
(#15195570)
The same thing applies to anything really, if you try to "shard" (partition, or simply do multi tenancy) based on files, MySQL tables, MongoDB collections, and of course elasticsearch indexes.
And you have to plan ahead and start with a large number of shards, to be able to scale your ES cluster.
Yet it's much better than trying to get some kind of SQL based cluster going, because those require knowledge of a lot of subtle internal details.
If you really want no-ops deployment, use something that requires minimal amount of ops, like ElasticSearch. Just give it an obscene amount of RAM and it'll work fine for ages.
RDS or not, if you want to run a big site, you'll need (dev)ops expertise. And a lot of it. Famously, Netflix - the big full-cloud business, - employs the most aggressive performance engineering and other "auxiliary" development groups. (Because AWS is fckn!1 expensive, and when you can run on a thousand less nodes, it'll cost you less. And yes, of course Netflix gets a big discount, but you won't, at least not initially.)