H
H
hAh0L2019-03-07 09:45:02
MySQL
hAh0L, 2019-03-07 09:45:02

Base for the test. How to update correctly?

There is a production base with a large amount of data. MySQL 5.2.7. Bases inside more than one. It is desirable to have a limited copy of the database on another machine for the tasks of testing and debugging applications. Questions:

  1. The production base stores a fairly large amount of data, the increase is also significant. The full amount of data for the test is not required. If you set up a master-slave replication, is it possible to delete obsolete data on the slave using cron?
  2. If it is impossible to delete from the slave, what is the best way to implement what you want?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
alternativshik, 2019-03-07
@alternativshik

Cannot be removed from the slave.

I
index0h, 2019-03-07
@index0h

Why would you link one to the other?
The database for the test is a set of fixtures.
A database for local development and viewing - can also be made in the form of fixtures.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question