Friday, October 26, 2012

More info about bluesyntax sharding solution for SQ Azure

I'm very interested in bluesyntax SQL Azure sharding management solution which I came across today. I've sent them a letter hopefully to get some answers about the product and if it can fits my app needs.




My needs:

I am searching for an affordable way to scale database in the cloud. Starting with one DB and want to be sure that I can grow to terabytes of data (if needed) and still maintain high performance and easy to backup and restore the data in case of data corruption. Many of today's solutions are very expensive (>$1500 per node),  I'm corrently looking at Nhibernate Shards and BigCouc (NoSQL).

I am currently an AWS customer but don't mind moving to Azure if the solution fits my needs. I have several things that I need to solve:

1) Start with small database, but being able to easily shard the data when data grows
2) A solution that can grow to terabytes of data
3) Easy to backup and restore the data in point in time, so if data corruption occurs, I can restore my data in a sharded environmet
4) A loyal company that I can trust that it will be here in the future and provide the services I need
5) Use numbers as IDs instead of GUID so I can use friendly URLs on my website ex. http://website.com/1233435662699 instead of a guid. Prefer the numerical representation
6) Want to know if with bluesyntax I need to carefully choose my sharding key
7) Being able to make paging / sort / order the data in sharded env. ex. get the last 10 products for page1. page 2 and so one (aka paging)
8) Easy to manage my sharding environment
9) SLA
I want to know if your product fits my needs?

Hopefully I get answers. It's hard to find an easy-to-use sharding solution for .net these days, any other solution you know of that I can look at?

No comments:

Post a Comment