mercredi 25 février 2015

How to set up two MySQL databases on separate servers to sync with string replace?

I have two MySQL databases on two separate servers. Both will host the same CMS but one will serve general visitor traffic while the other - the master - is accessed by editors. The contents of the the two database have to be identical, but as the two servers have different domain names, every sync should perform a string replace: from domain A, to domain B.


I found a MySQL replication is possible, but how can one sync two databases with a specific string to be always replaced to another specific string?


Update: As an example:



//Preset string to search:
"apple"

//Replacement string:
"orange"

//Edited data:
"Lorem ipsum dolor sit apple amet"

//Data sent to sync with other server:
"Lorem ipsum dolor sit orange amet"

Aucun commentaire:

Enregistrer un commentaire