Results 1 to 4 of 4

Thread: LAP & LM (as in LAMP)

  1. #1
    Join Date
    May 2011
    Beans
    159
    Distro
    Xubuntu

    LAP & LM (as in LAMP)

    Thinking about separating apache+php and mysql on two different virtual servers. Is this a good idea? Possibly multiple apache+php servers connecting to a single mysql server.

  2. #2
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    12,057
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: LAP & LM (as in LAMP)

    Quote Originally Posted by a2j View Post
    Thinking about separating apache+php and mysql on two different virtual servers. Is this a good idea? Possibly multiple apache+php servers connecting to a single mysql server.
    Only if the MySQL server is reliable enough; otherwise it constitutes a "single point of failure" that will take down all the sites that use it. Apache+PHP isn't really very resource intensive. Does the current server display high load averages just from serving web pages? Do your sites exhibit unreasonable delays?

    That said, I wouldn't have a problem doing this with one of my Linode VMs since they've been rock-solid for months now. I also spend the extra few bucks a month to create snapshot backups every night just for the warm and fuzzy feeling they provide.

    If you run sites that use session cookies to track users, you'll have to ensure that PHP uses the database to store the cookie information if you have multiple front-ends. Otherwise the session information won't be available if server 1 answers the original request, then server 2 answers the next one. This can happen if you use round-robin DNS to distribute the load across the front ends.

  3. #3
    Join Date
    Oct 2009
    Beans
    Hidden!
    Distro
    Ubuntu 16.04 Xenial Xerus

    Re: LAP & LM (as in LAMP)

    It might be good for separation of services - like if your apache server gets owned, your databases would be ok.

    It might be a bit of a pain to configure, and as, Seiji said, single point of failure would be the SQL server.
    Come to #ubuntuforums! We have cookies! | Basic Ubuntu Security Guide

    Tomorrow's an illusion and yesterday's a dream, today is a solution...

  4. #4
    Join Date
    Jun 2011
    Location
    Atlanta Georgia
    Beans
    1,771
    Distro
    Ubuntu 10.04 Lucid Lynx

    Re: LAP & LM (as in LAMP)

    I would consider using a failover DBMS but separating them isn't a bad idea multiple sites into one DBMS can cause problems though.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •