On Tue, Apr 19, 2011 at 9:51 AM, Michael Janapin <[email protected]> wrote: > Hello, > I just want to ask the best way to do this. > We have a MySQL server that is accessible only within our local subnet, > which is of course, behind a firewall. > Now we have a website hosted abroad where I'm planning to put some php pages > to access our database after a secure login process. > I have three options right now that I can think of. > 1. Use our web host's MySQL server as a slave server. > 2. Use another machine within our local subnet as a slave mysql server and > configure the firewall to port forward mysql connection to this machine. > 3. Just configure the firewall to port forward to our MySQL server.
4. You could also run the MySQL on the firewall, on default settings :P Kidding aside, #1 is good as most people already say, if you're letting the scripts mostly read (and not write or update) data off the database. #2 and #3 are just two ways to of doing the same port forwarding; they're good too, just make sure you're also protecting the connection using means like SSL. -- Zak B. Elep || zakame.net 1486 7957 454D E529 E4F1 F75E 5787 B1FD FA53 851D _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
