Live data from Hacker News

Clustrix, a distributed SQL DB, launches on AWS

clustrix.com

21–30 of 42 posts

Re: Clustrix, a distributed SQL DB, launches on AWS

#21
post #14

I want this to work, and be real, but I'm skeptical. I don't know how to change that.

Try it. You'll like it :)

++

Worked for an employer who used it. FAAANTASTIC. I met with the entire Executive team out in SFO on Friday, great company. I have never seen anyone take such care in doing massive QA (including month+ long regression testing on every generations of their platform)

Re: Clustrix, a distributed SQL DB, launches on AWS

#22

Does anyone here have direct customer experience with Clustrix? If so, I would be very interested in hearing honest customer feedback.

Clustrix is legit. Running it in production now (on their all-SSD hardware, not the new AWS version) across two physical sites. Functionality is sufficient, performance is admirable, support is top shelf.

Their bet was contrarian: embracing SQL -- specifically MySQL wire & dialect compatibility -- at a time when the open source options were trending toward NoSQL.

For funded start-ups with a calculable data-to-revenue ratio, Clustrix buys you the option for arbitrary future expansion while retaining the functional benefits of the RDBMS stack.

Once your product succeeds to a level where daily operational reporting is necessary, you'll appreciate the ubiquity of SQL: analysts and off-the-shelf tools all speak SQL without the overhead of glue code, data staging, or ETL.

Re: Clustrix, a distributed SQL DB, launches on AWS

#23
post #12
post #3

So, there's Amazon Redshift (which is cloud-postgres) https://aws.amazon.com/redshift/ and now there's Clustrix (which is cloud-mysql)

In case you were saying Redshift is literally PostgreSQL, it appears it's actually ParAccel: http://www.informationweek.com/software/information-manageme...

ParAccel, Neteeza, Greenplum and Vertica all owe some measure of their roots to PostgreSQL (the GP binary is still called `postgres`).

Development of parallel query execution in PostgreSQL proper has been stagnant for quite a while unfortunately: http://wiki.postgresql.org/wiki/Parallel_Query_Execution

Re: Clustrix, a distributed SQL DB, launches on AWS

#24

Does anyone here have direct customer experience with Clustrix? If so, I would be very interested in hearing honest customer feedback.

We use it on a large Rails e-commerce site and it works well. All features work as advertised and it is a drop in replacement for mysql. Their support team is also great and is like having your own dba team.

I can also say that I've been participating in the private beta of this AWS version for a week now and it is both stable and performant. Although we use their appliance in production, I'm very excited about this AWS version as it allows us to run clustrix in our testing and staging environments (where we previously had to run mysql).

I think it's a really great thing that more people/companies will be able to use their awesome database without having to purchase an appliance.

Re: Clustrix, a distributed SQL DB, launches on AWS

#25
Excuse me for, maybe, stupid question, but: we have few (250+) InnoDB tables and triggers - if we will try to move all data to Clustrix, will our application continue to work? I've read about "drop-in replacement" but maybe somebody here already have experience in same issue.

Re: Clustrix, a distributed SQL DB, launches on AWS

#27

Excuse me for, maybe, stupid question, but: we have few (250+) InnoDB tables and triggers - if we will try to move all data to Clustrix, will our application continue to work? I've read about "drop-in replacement" but maybe somebody here already have experience in same issue.

It's a good question. We built the entire database from the ground up, without any MySQL code. So while we support most of the frequently used features, we don't support everything.

You can get a list of unsupported features and differences from our docs:

http://docs.clustrix.com/display/CLXDOC/Unsupported+Features

http://docs.clustrix.com/display/CLXDOC/Feature+Differences

Having said that, our customers find that the value that they get out of scale out, fault tolerance, and performance is worth the tradeoffs of not supporting every single MySQL feature.

Honestly, our goal is not to be 100% MySQL compatible. We're aiming to be compatible enough to capture a significant share of existing MySQL installs, but we're really after building a truly scalable relational db.

Re: Clustrix, a distributed SQL DB, launches on AWS

#28

DBaaS - but what about latency between apps and db servers? If we use own cluster, servers can be placed in local network, but how it's possible with DBaaS model? About CAP theorem - which line is Clustrix for?

It seems like all aaSes are located in EC2 so latency should be no problem.

Re: Clustrix, a distributed SQL DB, launches on AWS

#29
post #27

Excuse me for, maybe, stupid question, but: we have few (250+) InnoDB tables and triggers - if we will try to move all data to Clustrix, will our application continue to work? I've read about "drop-in replacement" but maybe somebody here already have experience in same issue.

It's a good question. We built the entire database from the ground up, without any MySQL code. So while we support most of the frequently used features, we don't support everything. You can get a list of unsupported features and differences from our docs: http://docs.clustrix.com/display/CLXDOC/Unsupported+Features http://docs.clustrix.com/display/CLXDOC/Feature+Differences Having said that, our customers find that t…

Thanks. In your blog I've found: "The database has native support for dealing with JSON documents."

Why it's not in the features list? I thinks it's very cool.

Re: Clustrix, a distributed SQL DB, launches on AWS

#30
I just signed up for the trial. I hope to receive an invitation as we're actively using Galera on AWS-EC2 right now and experimenting with RDS.

We are a live event streaming company that expects several million viewers per event so something scalable/highly-available is what we're looking for.

fingers crossed for that 'invite'.

Post reply on HN