I think one of the advantages of no-sql such as MongoDB is that it can scale horizontally automatically: just add a cheap machine and the data can "spread over" to the new machine. How about for RDBMS, does any RDBMS do that automatically too? ...
I have a MongoDB sharded setup with 3 shards: shard0000, shard0001 and shard0002. The machine that runs shard0002 is down now, which causes all my queries to fail. I'd like to temporarily remove shard0002 from my setup and keep working with the first two shards. That should be doable assuming I only use unsharded collections that reside ...
Right now, I'm dealing with a TON (trust me) of data that needs to be available in real-time for fast reads and writes to customers. The backend storage system that we're using is Oracle, but we'd like to replace our big, beefy machines with a leaner system. For various reasons, we can't use Cassandra, and we're testing (but I'm scared...
I've got a wordpress multisite installation that's hosting enough blogs I need to shard the database. I see there are three plugins available to spread wordpress across multiple databases: http://wordpress.org/extend/plugins/hyperdb/ http://premium.wpmudev.org/project/multi-db http://wordpress.org/extend/plugins/shardb/ I'm trying t...
Here's the problem I'm trying to solve: I need to be able to display a paged, sorted table of data that is stored across several database shards. Paging and sorting are well known problems that most of us can solve in any number of ways when the data comes from a single source. But if you're splitting your data across shards or using ...
I have a MySQL database with tables in the form of "shard_0", "shard_1", "shard_2", etc. These are virtual shards. Now I want to add another DB server and move the even-numbered shards ("shard_0", "shard_2", "shard_4", ...) to the new machine. What is the best way to do that? There are many tables so ideally I wouldn't have to type out...