Running the software across multiple nodes?
Closed this issue · 1 comments
Hi -- We have a configuration where we dispatch traffic using a load balancer and I'm wondering if you think yourTwapperKeeper is compatible with that? We have 4 machines that all access the same database, so I'm wondering how much of the synchronization of state is done in the database? E.g. Does yourTwapperKeeper check to see if a process is launched on another host using the database? Or do we run the risk of running too many of the same PHP process on different hosts talking to the same database?
Thanks in advance,
Martin
Martin,
The implementation was definitely designed with a single node in mind.
However, if the yourTwapperKeeper software was loaded on each of the 4 machine, and pointing back to a single mysql installation (w/ 4 different databases) then you would should be ok - but the mysql database may take a beating b/c the current install of yTK really polls the mysqld database often (probably too often).
But you couldn't point back to a single database b/c each archiving node would attempt to archive everything in the single database (it wouldn't know that there are other nodes).
I had to deal with this type of setup on the original TwapperKeeper.com site, but that was written specifically for that implementation and wasn't really based off this codebase.
John