0

We have a PHP/Symfony 2 application using MySQL as the database. The database contains a large amount of data.

The application is deployed to a separate server(s) and an empty/clean version of the database deployed. The application is then run on a local network as the application is used where internet access is not always available (hospitals, banks etc).

Once the application has collated all the information are there any solutions for replaying the data back to the original database?

We are not using Master/Slave as we do not want the Slaves to contain all data from the original database.

  • From here - something like mysqldump --tables myTable --where="id < 1000" (1000 is just a sample - you would obviously choose your own query(ies) to match your own data retention requirements). Check out the thread for other tips. – Vérace Jun 14 '15 at 15:12
  • Thanks, the solutions you mentioned are based around extracting data out from one system, without any mention about importing data back in. Are there options using the binlog to record the inserts/deletes/updates and then playing these back to the original data source? – Paul M Jun 15 '15 at 15:22
  • @PaulM The community voted to delete your self-answer because it was simply a link to an external resource. If you can provide something that answers the question here (even briefly) supported by an external link, I'm sure that would be fine. That said, I would encourage you to at least mention the main points you found helpful in solving your problem. Thanks. – Paul White Nov 26 '16 at 13:00
1

When using master/slave you do not need to replicate the all instance. You can go up the the table with the replicate-wild-do-table parameter.

May be this could help you in what you are trying to do

1

There are an storage engine called FEDERATED for MySQL. You can replicate just some tables and any change in any database affect the other. You can evaluate if federated tables resolve your problem. Federated

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.