Web project setup

60 pts.
Tags:
Firewall appliances
Load balancer
MySQL
PostgreSQL
VPS
I am new the Linux servers but will be using CentOS servers.
I have a web application that was created in Java using a NoSQL database.
This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com.
We will have a public web site users will sign up for a subscription and then login into a User dashboard. From there they can add services to there user account and then go to the Web Site Creator were they create web site. After they save there work they will have the options to publish there web site to a web site to go live.
I am wondering what is the best server VPS layouts, should I have redundant servers with load balance or just have a new application server spin up if main server has to much use.
Should I put Firewall on all servers?
I was thinking 6 servers, but not sure.
  1. 1st two servers will be the admin dashboard and user dashboard
  2. 2nd two servers will be a database servers. I was thing MySql or PostgreSQL not sure what one will be best.
  3. 3rd two server will be our application servers. this will be the application user will use to create web sites.
Not sure bout load balance and firewall, and not sure about DNS setup.
Any help would be great.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Load balancing would be the best option for you where you require one server as a load balancer, three or more servers as per your requirement for load distribution and two database servers.

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    This sounds like something that should be hired or contracted out. Way too many analysis and implementation issues for anyone to give in an answer.
    32,380 pointsBadges:
    report
  • Subhendu Sen
    Focusing only on point no.2, it is better to go for mysql rather than postgresql. Why, cause in my company we are using mysql extensively and this is only my view of point that we are comfortable to use it. Next all your queries, it is best to install the same setups on other machine as a test server and run all necessary jobs from there to observe how it will behave. However, the test sever depends on if you will get necessary permission from your higher management.
    130,580 pointsBadges:
    report
  • ToddN2000
    I agree with Raven. The scope of this is to broad to make a guess as to the proper set-up. You want to make sure the roads you take do not cause bottle-necks and performance issues.
    125,840 pointsBadges:
    report
  • TheRealRaven
    As far as PostgreSQL vs. MySql is concerned, it depends on the kinds and volumes of data stored in and retrieved from the database. Without knowing table definitions and usage statistics, it's impossible to know which would be best. It could even be possible that both could be used, with specialized usage for one or the other.

    That's an example of why this is not suited for a question here. Good answers aren't possible.
    32,380 pointsBadges:
    report
  • sstepky
    OK so let me ask a more direct question about MySql and PostgreSQL.
    The database will be used to store customer user account information only. 
    I would like to have more them one database server. 
    Master database server and slave servers. 
    I would like to be able to get support if needed.

    60 pointsBadges:
    report
  • TheRealRaven
    If it's fairly common rows-and-columns, either would do. But MySQL is used more, so has more support options. If it will need to include documents that you might want to index and search and document size would often be large, then PostgreSql probably becomes a better choice.

    Those are simple guideline talking-points, though. Other factors can switch the balance. A full picture is needed for anything better than a guess.
    32,380 pointsBadges:
    report
  • Subhendu Sen
    Mysql is widely used, so you can get lots of help from good sources. As using now, it is easy to install and configure also even from command line. Though postgre has many more improvements nowadays.
    130,580 pointsBadges:
    report
  • ToddN2000
    I tend to use a lot of MySQL myself. IT suits most of my needs..
    125,840 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: