I have country-wise MySQL servers and one master server.
The master server has all country data.
In that I want to copy data of a particular country from the master MySQL server.
Example: if any data inserted on the master MySQL server is related to India, it will also be inserted into the Mysql server in India.
How can this be achieved?
Table structures in both a country-level server and the master server are the same:
-- -- Table structure for table `vxp_service_types` -- CREATE TABLE IF NOT EXISTS `vxp_service_types` ( `st_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `st_name` varchar(25) NOT NULL, PRIMARY KEY (`st_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;