Setting Up Replication

Setting Up Replication

Follow the steps below to set up Replication for a new track.

1. Grab the latest version of the database and ClubSpeed folders from another location; best to inquire a manager as to what track will be better for the location you’re currently building in the event they have more than two locations.
2. Run 2 truncate scripts (both located under the Replication category in ZenDesk)
   1. Track Data
   2. Financial Data
3. In the Database copied over, update LocationID setting in ControlPanel
4. Ensure that the following settings in the ControlPanel are set to true
   1. ReplicateCustomerInfo
   2. ReplicateFB_Customer
5. Add IP address of new server into locations by opening IIS and going to Default Web Site > SP_Services and opening up the IP/Domain Restrictions
6. Add the new location’s public IP address to ALL location servers (including new location) by going into the Database, ClubSpeedV8 > Locations table. You can use the script below and adjust to the track you’re modifying
   • *NOTE: If the sub-domain is already set up to their public IP, you can insert the sub-domain instead of the IP in the Locations table
7. 
   
   1. insert into clubspeedv8.dbo.locations(locationid,locationname,ipaddress,timeoutMS, disabled, OnlineBookingName)
      values(LocationID,'Name Of Track','licensename.clubspeedtiming.com','5000', 'False', 'Name of Track')
8. Values to replace in the above script:
   1. LocationID – Match to what you inserted into the LocationID setting in the ControlPanel of the new location
   2. Name Of Track – Add the name of the new track
   3. licensename.clubspeedtiming.com – Change the licensename part to the new track’s sub-domain
9. Set up the replication task in the Task Scheduler
   1. Setting Up Task Scheduler
10. Run the customer signature program. You can download it from the Club Speed Colo or from the attachment on this document.

If you'd like to "catch up" the new location, follow our guide on Catching a Track Up on Replication

Related Articles