I have same set of databases in 2 servers MYsql 5.5 (even master -Slave will do). but I have 5 months data in master where all Transactions will happen and 2 years data in Slave (only reporting or Select Queries will be executed)
Active and live Data will be in Master and Full Data in Slave. but at the end of the day or at specific time all the transactions happend in the master should be updated in Slave. Please give me your Solution.