New answers tagged scalability
U should try to partition your table, try this : http://dev.mysql.com/doc/refman/5.1/en/partitioning-management.html I really suggest you to use MyISAM instead. Such a scenario i had in my workplace for some big tables that we use to store data. I have done a script that inserts every night records from the main_table to an main_table_bak a backup of the ...
You can do it in the front end. For example if you are using ASP .Net you can do it Global.asax page details could be found here.
How it is done Basically, it is easy: Set up three(!) config servers Start a mongos query router and have the --configdb option string point to the three config servers. Note: the string has to be identical on all mongos Restart your going to be shard with the shardsvr option set. This step isn't strictly necessary, but best practise. What this basically ...
Top 50 recent answers are included