Companies have a project, the need to implement internal and external network database data synchronization. Ask the great spirit.

The following project scene, there are three server:
Cloud: 1, ali has a server-side program and database (primary)
2: A company has A server-side program and database
3, company B: is there a server program and database

External users of unified access client ali cloud server
Type A, B, unified access client company Intranet server

Need because of the external user client, with A, B company clients interact,
So to achieve: ali cloud, company A and company B three database of data real-time synchronous or short time delay synchronization (& lt; 1 min).

Is there a way to do it, please?

CodePudding user response:

Where is Daniel?

CodePudding user response:

What database?

1 if there is a special software support?
2 whether to support the trigger, the trigger + timing synchronization service
All three can change the database service control? Modify success, at the same time send message to synchronize

CodePudding user response:

refer to the second floor tianfang response:

database?

1 if there is a special software support?
2 whether to support the trigger, the trigger + timing synchronization service
All three can change the database service control? Modify success, at the same time send message to synchronize

Thank you, it is the MySQL database.

CodePudding user response:

There is no trigger, no proprietary software, without any plan

So want to consult with Daniel, here is there a specific feasible scheme

CodePudding user response:

The network layer can build a VPN

Mysql's own synchronization
http://www.wjxfpf.com/2015/10/193047.html

Ali otter
https://github.com/alibaba/otter
http://blog.chinaunix.net/uid-15472411-id-3886795.html

To avoid repeating
the primary keyhttp://njs375666635.iteye.com/blog/2242067

CodePudding user response:

Top, I also need to, mainly is the inside and outside the database synchronization backup to the network

CodePudding user response:

reference 5 floor tianfang reply:

network layer can build a VPN

Mysql's own synchronization
http://www.wjxfpf.com/2015/10/193047.html

Ali otter
https://github.com/alibaba/otter
http://blog.chinaunix.net/uid-15472411-id-3886795.html

To avoid repeating
the primary keyhttp://njs375666635.iteye.com/blog/2242067

Thank you for your reply

Ali otter second link failure, whether to have similar article, thank you