Scaling to 100M: MySQL Is a Better NoSQL

Post by sciurus » Tue, May 24, 2016, 8:52 PM UTC

TheGuyWhoCodes wrote: post #13

This is basically "We made it work, easy, all the rest are wrong". Wix is 10 years old, they probably started with MySql and stuck with it, is it wrong? Maybe, maybe not. If they were to start today would they have used Mysql aswell or gone with another solution? Did they spend the last 10 years building tools to help them scale MySql (at which point it's easy for them to operate) rather than use a tool that had mult…

Post by narrowrail » Tue, May 24, 2016, 8:56 PM UTC

mh-cx wrote: post #80

I have not heard about "Wix" before, but maybe they should have done some more research before picking this name. To a German this sounds like "wichsen" which means, well, "wank"[1]. [1] http://dict.leo.org/ende/index_de.html#/search=wichsen

Post by olavgg » Tue, May 24, 2016, 9:12 PM UTC

narfz wrote: post #77

agentgt wrote: post #72

Earlier quoted context omitted.

We use varchar for UUID (on postgres) which surprisingly hasn't been that terribly performance wise. And yes we do use varchar(36) although on postgres it doesn't really matter because I think almost all varchars are text. I would love to switch to native UUID someday though.

we did the same and then switched to the native UUID type. it eliminates the need for a unique index and we saw a drop in storage space by 1/2. it's totally worth converting UUID to the uuid field. ALTER TABLE my_table ALTER COLUMN my_uuid TYPE uuid USING uuid::uuid;

Post by mh-cx » Tue, May 24, 2016, 9:33 PM UTC

narrowrail wrote: post #83

mh-cx wrote: post #80

I have not heard about "Wix" before, but maybe they should have done some more research before picking this name. To a German this sounds like "wichsen" which means, well, "wank"[1]. [1] http://dict.leo.org/ende/index_de.html#/search=wichsen

Not only is this completely off-topic, they are a publicly traded company NASDAQ: WIX and they are currently valued at ~$1B.

Post by atomic77 » Tue, May 24, 2016, 9:40 PM UTC

tiffanyh wrote: post #3

Since Wix is using MySQL as a key-store ... I wonder why they didn't look at using Postgres HStore [1]. HStore is a key value store built directly in the RDBMS of Postgres. [1] http://www.postgresql.org/docs/9.6/static/hstore.html