-
Notifications
You must be signed in to change notification settings - Fork 505
Future Ideas
gglin edited this page Sep 13, 2017
·
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 analyze server configuration, server status and build the best configuration file for them. Maybe analyze 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.