Hi,
We are working on two sites that need to share some information (e.g. blacklisted emails for newsletter, risky transactions). What is the best way to achieve this?
Options I can see:
(1) sites talk directly to each other - if so, would this be through a restful api or otherwise? Would we store all the data on site A with the site B basically reading and writing to site A OR would both sites have a full dataset with regular synchronisation (e.g. every ten minutes).
(2) set up third database that both sites connect to - either directly or through a restful api or something like that. This seems like the cleanest option, so I would love some more defined ideas on how this could work.
(3) sites directly connect to each others' databases - this seems a bad idea in terms of security and speed (locked tables).
I would very much appreciate some ideas around this.
Note: in our case, the sites actually share the same code base (but have separate databases, themes, assets, etc...) and they are running on the same server.
Thank you
--