title: Database to Database communication
body: <p>I'm in the planning stage of building a website for a company that I work with. This company is an Electronics wholesaler and wants to get a better web presence. Their current POS system uses PervasiveSQL as the database. I will be using MySQL for the website DB and PHP for the language.</p>
  
  <p>I want to integrate this website with this current database however; i want to have the website use it's own database just in case an intrusion happens, everything won't be compromised. When the website takes in an order I want it also to be duplicated into their POS system. </p>
  
  <p>How do I go about accomplishing this? Do I just write a second INSERT statement in my code and insert into both databases? Is there a method I can use that when the database has something inserted into a table it will trigger an event that takes the information inserted and place it into another database? I ask this because when a new product or customer account is added into the original POS system I want that information to be placed in the websites database.</p>