Curious if anyone has done this/accomplished this, having a seperate database that is just for stats for game services?
( Yes i know mysql replication of master-slave is an option, but you are still doing many writes to the main database )
Specifically these tables;
tc_game_service_historical_stats
tc_game_service_detailed_stats
tc_game_service_live_stats
These 3 are heavy data tables, they are not essential for game services to run and cause some of the largest traffic between tcadmin webservices and the mysql database.
Putting these 3 tables into their own database would help optimise tcadmin to function more efficiently and allow further optimisation of the main mysql database.