Connecting remote MySQL database to local MySQL database?

I want to write PHP code to be embedded in a Drupal7 module. I want to call a procedure which can copy newly generated data in the local MySQL database to a remote MySQL database. When data is inserted in table A of my local database it should be copied to the specific table B on the remote MySQL database. Table 'A' is on local host. Table 'B' is on remote server. INSERT data on 'A' -> copied to 'B' Is this possible?