Experience with Scalearc sharding? Does anyone have experience with Scalearc sharding and it's ability to scale ? Does Scalearc needs to have the whole data in memory or does it behave well with disk storage ? I'm thinking to big database application like 10TB and above.
ScaleArc does not do Data Sharding

I actually wrote an earlier post where I evaluated it for my former employer : Experience using ScaleArc in test or production?


It does provide excellent read/write splitting using a single IP address and proprietary caching (ScaleArc's secret sauce).
You configure the ScaleArc server to have one or more Masters and One or More Slaves. It works great with Percona XtraDB Cluster as well as with Master with 1+ Slaves using MySQL Replication.
Each DB Server must have the complete dataset.


I doubt that you have the budget for multiple servers using 10TB of disk each.

What you might be looking for is ScaleBase not ScaleArc.