Two questions:
1. How often does the slave database get updated with changes to the master database?
2. If I route all non-update queries to my slaves and all update queries to my master, will there be a performance hit as my slaves check to see that their data is up-to-date? Do they even check?!?!
Thanks,
Jean
1. How often does the slave database get updated with changes to the master database?
2. If I route all non-update queries to my slaves and all update queries to my master, will there be a performance hit as my slaves check to see that their data is up-to-date? Do they even check?!?!
Thanks,
Jean