I have two backend applications which provide the same functions and they are located on two separate machines (actually this is to make a load balance). So they handle the client frontend requests using the same manner.
I want to collect some statistics about all the clients connected (i.e: what is the most used component in the client GUI application or something like that) and send the result to all clients every second.
I am thinking about calculate these statistics on each backend component separately and sum both together in that case I have set of options like make some sort of communication between backend components, or simply make small table in global DB and each backend update the table then select and send to its clients but this may decrease the performance as I want to send the statistics every second
I need a help