1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

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:
    37
    Likes Received:
    3
    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:
    37
    Likes Received:
    3
    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