title: PDO transaction across multiple databases, is it possible?
body: <p>I have the following problem with one of our users: they have two stores in two diferent locations, each place has its own database, however, they need to share the client base and the list of materials registered for sale. At the moment, what we do is when the client registers a new client, a copy is made on the other location's database. Problems quickly arise as their internet connection is unstable. If, at the time of the registration, the internet is down, it tries to make a copy, fails and carries with inconsistent databases.</p>
  
  <p>I considered making the updates to the database via Pdo transactions that would manage the two databases, but it seems that you need a new instance of PDO <code>$dbh1= new PDO('mysql:host=xxxx;dbname=test',$user,$pass);</code> for each database, and I don't see a way to commit both updates.  Looking at this related question <a href="https://stackoverflow.com/questions/128377/what-is-the-best-way-to-do-distributed-transactions-across-multiple-databases">what is the best way to do distributed transactions across multiple databases</a> it seems that I need some for transation management. Can this be achieved by PDO? </p>