performance - Questions on the Azure scalability targets and the use of multiple Azure storage accounts? -
the windows azure storage abstractions , scalability targets blog post indicates there 5,000 entities/second transaction limit single storage account, , there 500 entities/second limit single table partition. , meet first limit 1 should used multiple accounts, , partition limit 1 should design partitions carefully.
i'd ask others have experience on 5000 limit single storage account. right now, i'm designing community of blogs/wikis , 1 day site becomes popular , attracts lot of traffic. should split user related tables 1 storage account , blog related tables account , yet wiki related tables prevent limit right now? or should add more accounts there need, way there way transfer azure storage tables 1 account another? article says when hit limit “503 server busy” responses, there way know limit getting close in advance without accully resulting 503 errors?
i haven't hit account limit overall, have hit limit number of transactions on queue trying set number of worker roles reading queue ridiculous level.
as far know there no "you're hit limit" warning. first time know you've hit limit 503 error.
with transferring data 1 account another, there no built in functionality you. either have roll own solution read through every row in source table , write destination table, or use cerebrata cloud storage studio allows download , upload contents of tables or cmdlts let same thing, cheaper/free.
if you're starting out , have logical ways of partitioning data across storage accounts , doesn't make code complicated, it. wouldn't worry @ stage. chances if site become popular , start hitting transaction limit, come area hadn't expected or may come many transactions 1 table. said community of blogs, area that's transactions ever store comments. if more 5000 transactions second against comments table may need partition comments across multiple storage accounts. of course if blogs popular, chances you'll have other problems deal well.
Comments
Post a Comment