Author Topic: Consolidate all database servers into single instance  (Read 329 times)

steelshark

  • Newbie
  • *
    • View Profile
Consolidate all database servers into single instance
« on: October 09, 2018, 10:14:05 pm »
Goal of this project is to consolidate the 10 database servers we are running now into 1 server with several databases and seperate users. This is primary to save costs.

Conditions of sattisfaction
1. All database servers for coins in the EQD ecosystem are divested. Only the main EQD database server remains
2. All databases are migrated to the main EQD database server.
3. Seperate accounts are made per coin and user permissions are finegrained so they can only access their database schema.

Estimated time
4 hours payable in EQD

steelshark

  • Newbie
  • *
    • View Profile
Re: Consolidate all database servers into single instance
« Reply #1 on: October 09, 2018, 10:16:27 pm »
Consolidation was done successfully.
Every coin now has a database on the main EQD database server. Each coin is using its own user account with finegrained permissions to access the database.
All old database servers are turned off.
This should save roughly 100$ a month on the AWS bill

Time spent was roughly 8 hours
« Last Edit: October 27, 2018, 03:52:47 pm by steelshark »