I have a production webserver with a MySQL database setup as Master. I have a dev server with MySQL setup as Slave, with the data successfully being replicated from the Master.
What happens when a developer commits a chance to the Slave db? Is that commit going to screw up the whole setup?
If this is not the ideal situation for a Production / Dev / Staging setup, what would the ideal setup be?