I am considering replicating a production MySQL database on my development machine, so I always get the current data.
The production database is at the external level. My development machine is behind an unreliable internet connection. It is possible that the development machine may be disconnected from the Internet for extended periods of time (hours).
Will there be any adverse effects on the production database by doing this?
(I don't need real data, but that would be nice, and that would be a good excuse to stumble on replication. If the consensus is that this is a bad idea, I will set up daily work to import the previous nightly backup into my development database )
source share