1. Hi Guest
    We are running a survey about laptop service in India, and we'd love your inputs. Please help us improve the quality of laptop servicing, and if you've had any bad experiences, now is the time to be heard.
    Take the survey

Database and Application Server Setup

Discussion in 'Networking' started by amruth kiran, Sep 11, 2018.

  1. amruth kiran

    amruth kiran food-football-g(f)aming?!

    Joined:
    Dec 11, 2011
    Messages:
    330
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bengaluru
    Hey Forum members!

    I was wondering what would be the ideal technique to setup a server for a small enterprise organisation? This would be hosted online with low-medium users approx 500 at a time.

    Should I attempt a simple XAMPP/WAMP/LAMP setup along with PostgreSQL all on the same system? or would a separate Database and Application Server be more efficient for scalability issues?

    Any suggestions would be welcome,
    Thanks!
     
  2. mobo

    mobo Member

    Joined:
    Jan 5, 2013
    Messages:
    91
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Hyderabad, Delhi
    Server engineering is above my paygrade, but of course multiple servers are always more scalable.
    But if you are sure you won't need more than what a single machine is capable of, then the added complexity and possible performance hit may not be worth it.

    LAMP is probably the best choice, but you may also want to consider Elastic as DB. It can be very effective for certain types of workloads. Node.js might be more convenient to develop with if you are already offering rich client side functionality.

    The right answer can vary wildly depending on the the exact workload. Sadly, it's near impossible to simulate a real world load. If you are looking to add more servers later, then I guess you can always decouple your services when you do that.
     
    amruth kiran likes this.
  3. OP
    OP
    amruth kiran

    amruth kiran food-football-g(f)aming?!

    Joined:
    Dec 11, 2011
    Messages:
    330
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bengaluru
    Thank you for your quick reply @mobo !

    I was hoping to use WAMP along with PostgreSQL on the server side with PHP and Python as the scripting language to handle all transactions, but Node.js seems to be better at higher order/multi client requests ( still figuring this out, correct me if I'm wrong). The project is to just visualise and probably analyse some satellite imagery data ( Remote Sensing and GIS ) so I can't put a number on the complexity yet.

    " If you are looking to add more servers later, then I guess you can always decouple your services when you do that" What do you mean by decoupling?

    Thanks!
     
  4. mobo

    mobo Member

    Joined:
    Jan 5, 2013
    Messages:
    91
    Likes Received:
    11
    Trophy Points:
    8
    Location:
    Hyderabad, Delhi
    I just meant that if you go with a single machine setup now, and plan to add more later, you can always move the DB to its own separate system then.

    I don't know what all functionality postgres offers, but do look into elasticsearch. It has some features specifically for geolocation. It is not SQL compliant though, so it may not be suitable for more typical RDBMS data sets.
     
  5. OP
    OP
    amruth kiran

    amruth kiran food-football-g(f)aming?!

    Joined:
    Dec 11, 2011
    Messages:
    330
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bengaluru
    Thank you so much for the suggestion @mobo ! Elasticsearch seems very interesting for my work. Hopefully I'll be able to cook up something.
    Cheers!
     

Share This Page