You can certainly run MySQL on a separate machine. Make sure port 3306 is open on its firewall. Whether to run it on a separate machine is a performance & load question.
If I was setting this up, I'd have both machines on a private subnet behind a firewall. Curt On Fri, Oct 24, 2014 at 12:24 PM, Bruce W. Martin <[email protected]> wrote: > A couple of months ago I posted questions about PHP and web servers. > > I ended up setting up a Virtual Machine for the developers with PHP Apache > and MySQL install along with other things that were requested. All of these > were installed from the regular CentOS6 distribution sources ( so far I > hate CentOS7). > > Now the developers are ready to deploy the new website. I am wondering if > having MySQL running on a separate machine is a good idea and if it could > be a machine on a private subnet rather than the public subnet the Web > server will be on. Or would both machines need to be on a public IP subnet? > I am leaving the configuration of the MySQL server up to the developers as > they have more experience with MySQL than any one else in the department. > It is something that I wanted to learn but never had the time to completely > wrap my head around and take the time to dive into. Old Dog, New Tricks (at > least for the dog) problem. > > Suggestions? Insight? > > Bruce > > -- > Bruce W. Martin, KQ4TV > Mt. Juliet, TN > EM66sf > > -- > -- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nlug-talk?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "NLUG" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- -- You received this message because you are subscribed to the Google Groups "NLUG" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nlug-talk?hl=en --- You received this message because you are subscribed to the Google Groups "NLUG" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
