forked from thiagopradi/octopus
-
Notifications
You must be signed in to change notification settings - Fork 3
Future Ideas.
tchandy edited this page Sep 14, 2010
·
2 revisions
Some tools that could help dealing with database:
- Having a tool to move data between shards: Syncronize data between replicated shards, doing some filters with the query (maybe having a proxy between the application and the database, do some filters/analises with the data, send data to a specific shard before inserting it inside the master database.
- Adding the support for multiple databases native for ActiveRecord 3.1.
- Generating config file for the servers, based in the shards.yml config file.
- A tool to analyse server configuration, server status and build the best configuration file for them. Maybe analize if the database has tables without indexes, unused tables/fields, configurations that are made database slow.
- Web interface using sinatra to monitor all servers, seeing their performance, and monitor downs, bottlenecks, and what time in the day the database is most used, what tables, statistics, etc.