Featured post
Can local intranet application (built on php) query mysql database stored in offsite location? -
i have local intranet application runs off basic wamp server in our offices. every morning, 1 of our team members manually syncs our internal mysql db our external mysql db (where our online enrollments occur). if change made during day on intranet application, not reflected on external db until following day.
i wondering if possible (essentially) tunnel external mysql connection wamp or xampp server within our offices , work in 'real-time'.
anybody had luck or advice?
replication enables data 1 mysql database server (the master) replicated 1 or more mysql database servers (the slaves). replication asynchronous - slaves need not connected permanently receive updates master. means updates can occur on long-distance connections , on temporary or intermittent connections such dial-up service. depending on configuration, can replicate databases, selected databases, or selected tables within database.
if use external server directly, performance suffer. gigabit lan might thousand times faster internet connection - particularly upload speed of adsl connection.
- Get link
- X
- Other Apps
Comments
Post a Comment