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