Database sharding and Rails

ruby-on-rails database activerecord sharding
Teflon Ted picture Teflon Ted · Sep 4, 2008 · Viewed 10k times · Source

What's the best way to deal with a sharded database in Rails? Should the sharding be handled at the application layer, the active record layer, the database driver layer, a proxy layer, or something else altogether? What are the pros and cons of each?

Answer

John Topley picture John Topley · Sep 7, 2008

FiveRuns have a gem named DataFabric that does application-level sharding and master/slave replication. It might be worth checking out.

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
delete_all vs destroy_all?

I am looking for the best approach to delete records from a table. For instance, I have a user whose user ID is across many tables. I want to delete this user and every record that has his ID in …

Read More
Can you get DB username, pw, database name in Rails?

I'm writing a rake task that does some DB work outside of Rails/ActiveRecord. Is there a way to get the DB connection info (host, username, password, DB name) for the current environment as defined in database.yml? I'd like …

Read More