Write a post simultaneously to other site’s database

  • I have met a very interesting problem.
    Now we are developing a cluster of a few independent sites, which collect data from a different sources. And we have a main site, which should display all the data collected. Site planned to be high-load (many visitors at the same time).
    We tried to get data by the main site through REST API calls to low-level sites.
    In that case site performs a huge amount of operations and even without visitors all the cores overload.
    As a variant our command proposed to write the data by low-level sites into main site database simultaneously.
    The question is: Could I write a record (post) to main site database too whilst I write it to low-level site database?
    Thank a lot for a fast reply.

    • This topic was modified 5 years, 6 months ago by digestsua.
Viewing 1 replies (of 1 total)

  • It’s possible, but probably not quite so easy. You would have to have a separate database connection set up on each of the sub-sites that can access the main database, and then set up a whole lot of custom code that writes to the remote database on any add/edit/delete post actions.

    One other option might be to make the REST API calls from the sub-sites. That way you’re pretty much doing what you want to anyway, and the main site doesn’tget “bogged down” making remote calls all of the time if they aren’t needed.

Viewing 1 replies (of 1 total)
  • The topic ‘Write a post simultaneously to other site’s database’ is closed to new replies.