up vote 0 down vote favorite
share [g+] share [fb]

I have a database (MySQL) and I need data from n databases (probably multiples DBMS). For example, if a person is added as an user in other database I need to update my table with the new name.

The data is critical, and for sure, only I would have access to read.

My database is the only one that needs to be updated with the new data.

The alternatives that I found:

  • Forget all the text above, and simply generate tokens that are distributed to the organizations, that give a token for each user.
  • The other sites have (or will build) an API to access the information externally.
  • Sync databases (here, I need help about the structure to do that)
link|improve this question
Hi Fel, just curious, are you trying to group n database tables into a single database on your end? Or will each remote database have a separate database name on your central server? – DTest Feb 21 at 20:45
@DTest, the first option, is what i am trying. – Fel Feb 21 at 20:57
1  
Honestly, if you're using different types of RDBMSs, you will probably be better off wrapping each one in API calls (your second bullet point). – DTest Feb 21 at 21:22
@DTest, maybe another alternative, what do you think about a database abstraction library to access remotely another DBMS ? – Fel Feb 22 at 14:42
you could also potentially run into name clashes if they're all in the same database (system_user on each database for example). There are a ton of problems that isolating into database-specific API calls would probably solve easiest. – DTest Feb 22 at 14:48
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.