Over the years, I have written a pretty extensive shopping cart/back end processing application using TeraScript. The application handles multiple web sites with a separate MySQL database for each web site. All databases are running under one MySQL service with the One File per Table option enabled. This option makes InnoDB to store each created table into its own .ibd file.
Each web site/database has an Inventory table. I would like to share the Inventory table from one site with another site. I use many JOINs and LEFT OUTER JOINs when reading the inventory table. I could look through all my tafs and tcfs for all INSERTS, UPDATES and DELETES, add code to update each other's table and keep the separate Inventory tables identical, but I am looking for a better solution. I could pull the Inventory table out of the database and make the table it's own database that both sites access, but I am not sure if JOINs and LEFT OUTER JOINs would work. Is there a way in MySQL to have one database look to another database for a table instead of it's own? Or any other strategies you might recommend? Thanks in advance Steve Fogelson Internet Commerce Solutions ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
