Replicating a MySQL Database to a Development Machine - Bad Idea?

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 )

+4
source share
5 answers

And what if you need to change the database schema or do some experimentation with data / triggers / SP / constraints? as soon as you change the data on the slave, it will be in an asynchronous state until dump import + synchronization is added. so why not just import the dump sometimes?

+1
source

Having real data is always a huge development aid. Just remember to clear each user's email address so that you don't spam them with development email.

+4
source

Until you influence the development environment for the rest of your team (there is no harm in testing your application with production data). However, this special environment should be kept separate from your development / script environment (call it specialized or near-production).

+1
source

Do you have any confidential data on your production server (passwords?)? I don’t know if this applies to your environment, but in some places the security rules are less strict in the machines for developers than on production servers ("what is this? Do all developers say that they need root access to install CPAN modules?" - not a problem, it's just a dashboard ").

If there is sensitive data, think about whether you are increasing your exposure by copying it to another machine.

(and does replication use secure connection (SSH)?)

+1
source

I think that in your circumstances - yes, this is a bad idea. No actual data, even daily updates, is needed for development. And your internet connection conditions are poorly suited for replication playback.

0
source

Source: https://habr.com/ru/post/1305285/


All Articles