Splitting Tcadmin Mysql Stats from main database

[CloudNine]

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. 

Edited February 13 by CloudNine