The infrastructure about MySQL Master Slave replication involves:
- MySQL custom configuration
- MySQL custom recall
- Optimization and performance about point 1 and 2
Often there are open source that customizes MySQL recall, and it is not simple to adapt a MySQL Master Slave infrastructure. So that any simple idea is considered.
More open source uses user session, and table about session could be unique problem about a system of Master Slave replication with more slave.
Each slave could permit a read-only permission for each table excluding table session with these MySQL commands:
grant select on database_name.* to 'mysql_user'@'localhost';
grant all on database_name.table_session to 'mysql_user'@'localhost';