RockGym Pro - Multi Site

Hi I'm just trying to get my head around the multi-site version of RG Pro and wondered if someone could answer the following:

Do all of the connected gyms read and write to one main database or do each of the individual gyms only ever write to their own database?

I.e Once a member registers at Gym A - do their details aways stay on Gym A's Database or will Gym A then update the new member onto all of the other Gym's databases?

I hope that makes sense!

0

Comments

8 comments
  • Each gym runs their own database, but all databases are connected to each other. A member stays on their home database, but their profile is fully accessible from all locations. They can also check-in to remote gyms, be sold products at remote gyms, etc.

    The system works very well, and the nice thing is that there is no single point of failure. If a gym goes offline, it does not effect the operations at the other gyms.

    There are a few quirks related to this design, but none really effect operations.

    Here's a (bad) picture :)

    http://www.rockgympro.com/?page_id=1031

    There are many facilities using the multigym version in the U.S., including one business that has 7 locations.

    Hope this helps
    Andy

    0
    Comment actions Permalink
  • Thanks for the fast reply Andy... Yeah this what I though was the case, as you say it's rare that it will cause problems.

    So, if the internet was down at Gym A and a Gym A member tried to check into Gym B BUT they had a pre-paid pass, presumably the procedure would be a phone call between gyms to confirm and amend the member's pre-paid balance?

    0
    Comment actions Permalink
  • Yes. Exactly. In the case that GYM-A is offline, it is not available at GYM-B (and a status message makes the staff aware of this). When it comes back online, it is automatically brought back into the system.

    If your internet is "typically" reliable, you won't have a problem. If you have seriously flaky internet, it might become an issue - but so would any centralized database!

    Probably the most painful part is setting up the VPN.

    0
    Comment actions Permalink
  • We do occasionally get power cuts at our current gym but seems to be less of an issue these days, thankfully!

    When setting up the VPN is there any recommended internet connection type/speed that we should be aware of, or can the 2 databases connect across a regular ASDL internet line? (baring in mind we're in the UK, I'm guessing our broadband isn't quite as fast as in the US!).

    0
    Comment actions Permalink
  • I won't lie. Faster is better. There might be some reporting options which are painful over the VPN (for remote gym reports only) if you have a slow connection, but you can always just remote desktop over there in those cases....

    Can you watch videos over the connection without pain? If so, it is probably good to go.

    0
    Comment actions Permalink
  • Thanks Andy, yes watching videos is usually OK at Gym A but Gym B is currently under development so we will have to watch this space!

    0
    Comment actions Permalink
  • Andy, are there any issues with using a hosted mysql db as the centralized database instead of setting up a VPN?

    0
    Comment actions Permalink
  • You cannot use a remotely hosted MySQL database, the latency will make the software unusable. RGP is very database intensive, and transferring all the SQL statements across the open internet is just too slow.

    The distributed databases connected via VPN works very well (and prevents any single point of failure). Many, many gyms are using it with success.

    Hope this helps
    Andy

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post