The Central Service allows you to have a central MySQL database. If you have more than one venue you will have synchronized players, bans, player cards and visits.

The Runtime-Server is the decentralized independent application running at each venue. Depending on the configuration, the Runtime-Server uploads new locally created records and downloads new remotely created data. The server is capable to have incremental (fast) and full synchronization.

The topology has a big advantage. Whenever the central database is not reachable or off the Runtime-Server continuous working. Failed synchronizations will not result in a total failure. The scheduler will start a new upload/download later and shows a warning to the administrator.

Advantages are:

  • Decentralized and independent Runtime-Server
  • Incremental and full synchronization
  • Common database for all venues
  • Centralized data backup
  • Standard MySQL server
  • Standard HTTP server (e.g. Apache)
  • Reliable topology for a minimum number of outages

Configuration

To set up service configuration, select the "Services" tab of the server window. Choose the service you want to configure, e.g. "CW-Sync-Central". Click the  Config -button at the bottom and a new window will pop up.

Info

The "Info" tab show synchronization information about the last or next operation. If the dates differ there might be a problem with the SQL database or the http server.

Scheduler

The "Scheduler" allows operation at a specific time or duration. Usually the Minutes-checkbox is enabled and the value is set to 60 minutes. The server will synchronize every 60 minutes the local database with the central SQL database.

Databases (SQL/Local)

To set up the SQL database parameters, click "Databases (SQL/Local)". Enter all values for connecting to the MySQL server.
At first you need the host address of the MySQL server. The URL can be a domain or an IP address. Make sure you set the right port for your connection.
Enter the database name, user name and password. Make sure you set a proper user name and password for you synchronization user. Do not use the root user and password for your live system, for tests, it's OK.

Each location or venue must have a unique location identifier. You can easily start with "1". We used "99" for a developer location. That is important to distinguish between your different venues, clubs, sites and locations.

HTTP Server

Photos will be shared as well. The Runtime-Server will upload and download images from a http server. Enter the URL for your photo folders. As you can see the URL can include a port number, e.g. "8888". The standard value is "80", but you can use any port you like. For uploading data to the server you need a user name and a password.

Make sure you set up your MySQL server and HTTP server properly.
We recommend:
  • Use proper passwords.
  • Use VPN connections if your server is reachable through the internet.
  • Do not use standard ports.
  • Set up Security Certificates (https).

You cannot purchase the "Central Service" extension directly from the server application. Please contact us if you are interested in connecting all your venues and locations to share the same data.