=====Data Sync Server Installation Manual=====
1.	Recommend to use a dedicated computer for Data Sync server. Suggest to use SSD hard disk instead of HDD.

2.	Download mariadb-10.11 from internet and install it.

3.	Add/Modify below lines in my.ini.

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER
max_allowed_packet = 128M
 	Connect_timeout = 86400

4.	Unzip the data sync programs provided by iGarment.

5.	Create folder \Company under \synchro folder & put your company’s id.co in this folder.

6.	Run Synchro.exe & set Configuration as below:-

{{:en:synchro_manual_1.png?500|}}

Company = database name

Server IP = iGarment server IP (input the fastest ip no. in your factory location)

Server Port = 7001

User Name = login user name for Data Sync program (cannot include Chinese character)

Password = if required (cannot include Chinese character)

Encrypt Key = ‘n=’ value in id.co file

Local Server IP = 127.0.0.1

Local Username = root

Local Password = root password (If you have set root password when installing mariadb, you need to input the password here. If no password set, just leave this field blank)

Skip tables = input the tables that you do not want to sync, separate tables by commas e.g. ngattach, ngattachdtl, ngbackup, ngclicklog, ngdoclock, t_%

Need to add ‘t_%’ in order to skip all temporary tables.

Verify tables = input the tables that you want to verify between local and SaaS database

Log File = system will automatic update this file name e.g. db135-master-log.062

Log Position = system will automatic update this position number e.g. 318819


7.	Click ‘Build’ to create the database from beginning

Message ‘Are you sure to rebuild database?’ will be shown. Click ‘Yes’.

{{:en:synchro_manual_2.png?500|}}

-	System will download the backup zip file (xxx.gz) to \archive folder.

-	After download, system will unzip the backup file (xxx.db), then init database.
 
8.	After database initialization is completed, click ‘Replicate’ to start the data sync process.

{{:en:synchro_manual_3.png?500|}}

9.	If you want to verify tables, click Verify.

{{:en:synchro_manual_4.png?500|}}

-	System will show the tables that you have inputted in Configuration with their corresponding log file and position.

-	Then click ‘Replicate’ after verify tables have been set.

{{:en:synchro_manual_5.png?500|}}

-	System will start the verification process when verify log file is reached.

-	If no error found after verification, it will show ‘OK’ under ‘Note’ column.

-	If error found, need to ‘Build’ database from beginning.

10.	Automatic upgrade data sync program

-	Update.exe and update.ini are added

[Configuration]

Product=synchro

Force=1

If Force is set to 1, it means that you must upgrade the program before you can start the data sync process.

Note:
- Log file size is limited to 10M. 

If exceed 10M, system will automatic create a new log file e.g. synchro.log, synchro.log.187, synchro.log.186 … etc. 

The latest log is synchro.log
 
Internal Note:
-For iWorkPMS customers, below error will be found when ‘Build’.

Error: Table ‘pyxxxxx.nguser’ doesn’t exist.

Need to manually create table ‘nguser’ in iWorkPMS database because iWorkPMS user table is ‘pyuser’. Create a login user in ‘nguser’.