pim data synchronization

As mentioned in the previous blog, when data synchronization is performed, you need to create a trigger for each operation table on each site. During addition, deletion, and modification, the task of a trigger is to concatenate the SQL statement to be operated into a string and save it in the synchro_tb_operate_log table. If an exception occurs during trigger execution, the exception information is saved in

(id,appid,ratio,status,create_time,char_ package_name,version) Select Id,appid,ratio,status,create_time,char_package_name,version from V_bill_ Tbl_versiOn_update_control_info; Select COUNT (*) into V_src_count from Work_table_tbl_version_update_control_info; Select COUNT (*) into V_dst_count from Tbl_version_update_control_info; Raise Notice ' v_src_count:%, v_dst_count:% ', v_src_count,v_dst_count; if (V_src_count = v_dst_count and v_src_count 4. Execute the function to synchronize and conf

character (20) not null, ratio integer DEFAULT 0 not null, status character (1) DEFAULT 0 not null, create_time timestamp without time zone DEFAULT now (), char_package_name character varying (50), version character varying (8 )); Create table work_table_tbl_version_update_control_info (id integer not null, appid character (20) not null, ratio integer DEFAULT 0 not null, status character (1) DEFAULT 0 not null, create_time timestamp without time zone DEFAULT now (), char_package_name character

Label:Reading guidance With the rapid development of the company's business data volume is also rapidly increasing, based on the user each dimension depth analysis, the relationship data pressure is more and more large; so eager to find some solutions; The research took a long time to finally adopt the Golang+mongod cluster of this scheme, using MONGO to do data

C # synchronize data in the SQL Server database-Database Synchronization tool [synchronize new data],C # synchronize data in the SQL Server database 1. Write an SQL processing class first: using System;using System.Collections.Generic;using System.Data;using System.Data.SqlClient;using System.Text;namespace PinkDatabas

function, you must create two different SQL azure databases. -To implement cloud to local, you must create an SQL azure dB and use SQL Server dB locally. Data sync uses a concept called "Hub Database". Through integration of hub databases, data sync enables different databases (on premise dB and on cloud dB) the synchronization can be smoother. This Hub data

port [testshare]//authenticated module name in the client needs to specify PATH =/share///Directory participating in synchronization ignore errors//can ignore some unrelated IO errors Read Only = no//allows readable writable list = no//does not allow listing of hosts allow = 10.208.131.1.199//allows synchronous hosts to deny everything else auth users = ad min//authenticated user name secrets file =/etc/rsyncd.pass//password files storage addressV. C

Document category: Database Keyword: MySQL master slave Recently, due to project requirements, Mysql Data Synchronization has been set on Linux servers. Fortunately, there are a lot of network resources, and Google has all of them, but the actual operation is troublesome.Yes, I encountered a lot of problems, but I fixed it by Google, At the same time, I have learned a lot of relevant knowledge and will summ

database of data sync. 3. Create on the same SQL azure Server -The database name is azureemployeedb. The database type is "Web" and the maximum size is "1g" -This database is used as the on cloud database. Ii. Start data sync 1. log on to the Windows azure platform. (Process omitted) 2. Select "Data Synchron