Go Back   The Scream! > COMPUTER RELATED > General Software

Thread Tools Display Modes
Old 24-March-2013, 12:14
snoozy's Avatar
snoozy snoozy is offline
Join Date: May 2001
Location: oldgitshire
Posts: 381
Default mysql server replicate or forward?


I have the following scenario. I have a mysql server running in a LAN. The clients in the LAN do not have, and are not allowed, Internet access. They run a little app that uses the database and inserts records into a table. It works fine but..

I need the users to install the app at home too. The mysql server in the LAN does have Internet connectivity but will not accept incoming connections. (I am powerless to change this).

I set up an online mysql server which works with the app from home, but of course the two twin databases are not synchronised.

I wonder if it is possible to forward the SQL requests from the LAN through the local msql server to the online one, or is there a way to sync/replicate the databases? The records that are put into the table have an auto incremented primary key.

My name is snoozy and I am an sql newbie!
Reply With Quote
Old 24-March-2013, 22:08
snoozy's Avatar
snoozy snoozy is offline
Join Date: May 2001
Location: oldgitshire
Posts: 381
Default Re: mysql server replicate or forward?

If anyone else is struggling with this look at mysql proxy. It listens on port 4040 and redirects to a server of your choice. Will find out tomorrow if the one machine in the LAN with Internet access can get out on the default 3306 port.
Reply With Quote
Old 26-March-2013, 13:37
silver's Avatar
silver silver is offline
Join Date: Apr 2001
Location: Bournemouth, UK
Posts: 12,177
Default Re: mysql server replicate or forward?

I was going to suggest a proxy, if the mysql server will only accept clients that are within the LAN then a proxy running on the same LAN but with internet access will proxy the external requests and it will appear as though those requests are coming from the LAN side

however if you are able (allowed) to do that then why not open the mysql server to the internet

having said that a much more secure method would be to allow external users some form of vpn into the LAN and then you are protecting the network / mysql server etc and once the VPN is connected the external users will appear as though they are on the LAN side
Reply With Quote

forward, home, internet, key, line, network, online, port

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Staic IP, Port Forward, DMZ CanineKiller TalkTalk 4 03-April-2010 09:43
Darwin Streaming Server Onslo General Software 9 09-February-2007 16:17
Windows Vista, Server and IE 7 Betas crankykick News 1 17-December-2005 04:11
More Print Server problems! spawn_e_git Hardware 1 24-December-2004 02:10
Latest Windows Server Name Change to Avoid ".NET Confusion" silver General Software 0 10-January-2003 10:17

All times are GMT +1. The time now is 21:29.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright 1999-2014 The Scream!