mysql - Strategy on synchronizing database from multiple locations to a central database and vice versa -

-

i have several databases located in different locations , central database in data center. have same schema. of them changed(insert/update/delete) in each location different data including central database.

i synchronise data in central database. data in central database synchronise locations. mean database change in location 1 should reflected in location 2 database.

any ideas on how go this?

just @ symmetricds. data replication software supports multiple subscribers , bi-directional synchronization.


Comments

Post a Comment

Popular posts from this blog

c# - BasicHttpBinding equivalent CustomBinding using WCF Client and PHP WebService -

-
i running visual studio 2008 unit test c# webservice php using wcf , received following error: system.servicemodel.security.messagesecurityexception: http request unauthorized client authentication scheme 'anonymous'. authentication header received server 'ntlm,basic realm="(null)"'. ---> system.net.webexception: remote server returned error: (401) unauthorized.. i using windows xp sp3 machine, unit test vs 2008 , wcf connect php webservice. i have no control php webservice. cannot modify (neither configuration security). here config file client use webservice php: <system.servicemodel> <extensions> <bindingelementextensions> <add name="customtextmessageencoding" type="company.integracioneasyvista.customtextencoder.customtextmessageencodingelement,company.integracioneasyvista.customtextencoder, version=1.0.0.0, culture=neutral, publickeytoken=9744987c0853...
Read more

android - Cannot use ndk-build on Cygwin -

-
i have use ndk clien't project. using windows 7. i followed installation instructions. have installed cygwin 1.7.1. in cygwin bash, go android ndk root directory. when see contents of directory, usin $dir command, can see contents including ndk-build, when try use ndk-build, result get: $ndk-build bash: ndk-build: command not found. not sure doing wrong. cygwin emulates gnu/linux environment on windows computer. means you're working "shell" not same windows command-line. if type asdf.exe in windows command-line, tries find asdf.exe in current directory. if can find it, file executed. if can't find it, it'll go through every directory of %path% , try again. however, if type asdf in bash (there multiple kind of shells, bourne again shell 1 of them), not after in current directory. instead it'll try find in 1 of path directories. can't give sources here, afaik it's security reasons. if want run file not in path , must p...
Read more

sql server - python to mssql encoding problem -

-
Image
greetings by using pymssql library, want write data mssql database encounter encoding issues. here sample code write db: # -*- coding: utf-8 -*- import _mssql .... connection info data here .... def mssql_connect(): return _mssql.connect(server=host, user=username, password=pass, database=db, charset="utf-8") con = mssql_connect() insert_ex_sql = "insert mydatabsae (id, programname, programdetail) values (1, 'test characters ÜŞiçÇÖö', 'löşüiiğĞü');" con.execute_non_query(insert_ex_sql) con.close() sadly data written db corrupted: the collacation of mssql db is: turkish_ci_as how can solved? here possible solution : the key insert_ex_sq.encode('your language encoder') . try instead: con.execute_non_query(insert_ex_sq.encode('your language encoder'))
Read more