AWS Series: How is Redshift so fast?

Helen Anderson on October 05, 2018

Redshift is a solution for big data warehousing from Amazon. Once you’ve created a data warehouse, called a cluster, you can use SQL tools to perf... [Read Full]
markdown guide
 

I've worked as a contractor at a company that funnily had a really slow Redshift.

After a bit of investigation me and another developer found out they only had one leader node and no compute nodes and didn't plan to invest in more than one...

So yeah Redshift is fast, unless you use it in a cluster of one where there's no distribution or parallel work. Like that you're probably better off using PostgreSQL :D

 

Lol that is such a brutally typical type of situation organizations find them in.

 

Yep sounds right, get a free technology, make it a proprietary solution, do not give anything back to the community, sounds like Amazon :D

I think nowadays MariaDB can reach Petabytes of data, they have built a new column store engine and they will release a new technology to scale and paralel queryes (Clusterix or something). The costs would probably be a factor smaller than AWS and it's open source. It can read from any ODBC source as well, from multiple parallel sources acting like a live catalog for an warehouse.

 

Has MariaDB replaced MySQL? Is there a major advantage to using it?

How does it compare to Postgres/PostGIS?

 

Basically yes. Most MySQL core developers moved to MariaDB, and they added the features that MySQL corporate version has and a lot others on top, for free. They made a foundation and a license that guarantees it will be public all times, so what happened to the product when it was bought by Oracle would not happen to Maria, even if the Foundation is bought.

As for the reasons why you should not use MySQL anymore here are a couple, including that many Linux distros dropped the support for MySQL and moved to Maria.

seravo.fi/2015/10-reasons-to-migra...

Postgres has the same downsides and limitations as MySQL and a worse license and dev policy from what I heard (its owned by one company and keep a lot stuff secret and take arbitrary product decisions).

blog.panoply.io/postgresql-vs-mariadb

 

Hi @Helen Anderson,
I have Read about this in dzone as well and found that lot of people are switching if anybody wants to know that why? Then read dzone post: dzone.com/articles/5-steps-migrate....

If you want to find that the difference between MariaDA and MySQL then click here.

code of conduct - report abuse