Bruce, A few questions... 1) Are you going to have a single web server or multiple web servers? 2) If Multiple, do they each need their own MySQL instance or can they share one? 3) What is the load on the web servers and on the MySQL server?
If all this is a single web server then, depending on the load on the web server, I would run the MySQL instance on a secure box behind your firewall (but possibly firewalled off from the rest of your network. Then open port 3306 from the Web server to the MySQL server. This gives you the greatest flexibility and the best way to be able to scale for load. If it turns our your web/php servers are the bottleneck you can add additional instances that (possibly) share the single MySQL DB. If you DB is the bottleneck then you can either beef it up (add RAM, faster and/or additional CPUs, and faster storage) or even add additional DB servers. I'll be happy to have a discussion about this if you want. Just let me know. Andy On Fri, Oct 24, 2014 at 1:31 PM, Curt Lundgren <[email protected]> wrote: > 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. > -- -- 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.
