[eluser]Jonas G[/eluser]
Hi.
I'm building a site that gets alot of xml data pushed to it. All xml data is saved in a database. This data has to be shared with 3-5 other sites (all on the same host though) and I'm trying to figure out the best way of doing this. As I see it, I have a couple of options:
1. Saving the data to a single database which all the sites connect to. Pros: I only have to save the data one place. Cons: I have to connect to more than one db from every site + I have to figure out how to use IgnitedRecord (as I need the mapping) over more than one db (if that is even possible).
2. Save the data to all the databases. Pros: I don't have to worry about connecting to multiple databases (except for the xml parser). Cons: The data is very sensitive and if I miss a single entry it would be bad. If I have 4 different databases that means 4 places where things can go bad
I feel option 2. is the better option but would love to hear some opinions.
Jonas