title: How to create trigger to insert data to a database on another server
body: <p>I have 2 mysql databases on different hosts, want trigger after insert data to one database it inserted to another . I'm new in mysql , in sql server I can create linked server and do it . But how to do in mysql ?
  Both databases have similar table</p>
  
  <pre><code>CREATE TABLE `tsttbl` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `age` smallint(6) NOT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8
  </code></pre>