Server/Application Architecture Help

Discussion in 'ASP.NET / ASP.NET Core' started by TomWoods, Oct 23, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. TomWoods

    TomWoods

    Guys, I?m at a critical juncture working on my application. I?m building an online retail store. We are a start up and very small. I would like to find out the optimal solution for hosting at your site and running the business from a remote location. If this thing gets off the ground in any way I foresee us moving to dedicated servers, but for now I have shared server hosting with DiscountASP plus two SQL databases. I would like to know how best to architect the application for optimal performance and security. Right now I am considering the following scenario which seems high risk:</o:p>
    </o:p>
    <UL style="MARGIN-TOP: 0in" type=disc>
    <LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level1 lfo1; tab-stops: list .5in">One web server that has the following:</o:p>
    <UL style="MARGIN-TOP: 0in" type=circle>
    <LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level2 lfo1; tab-stops: list 1.0in">1 Public facing website</o:p>
    <LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level2 lfo1; tab-stops: list 1.0in">1 sub-domain supporting the backend (internal) business backend</o:p>
    <LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level2 lfo1; tab-stops: list 1.0in">1 database for customer service live chat, etc?</o:p>
    <LI class=MsoNormal style="MARGIN: 0in 0in 0pt; mso-list: l0 level2 lfo1; tab-stops: list 1.0in">1 database for online catalog and other backend tables.</o:p>[/list][/list]
    </o:p>
    I want to know if operating out of a single database for both the public facing site and the internal application site is a big no no. If so, for performance/security/etc?, then what would be the best architecture to follow? Backend tables for internal corporate separated into another database? How does the public facing site tap inventory? Separate database?

    If anyone has either documents or advice on a good basic architecture for a public website, internal company site and associated databases please advise.

    Thanks!
    Tom
    </o:p>
    </o:p>
     
    TomWoods, Oct 23, 2007
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    This is quite simple. You can use the DNS manager in the control panel to point sub domain to the IP of your business backend.


    This is really hard to say. If you application is secure and the SQL server housing the DB is secure, you should not have too much of a security issue. Performance wise, it really depends on what kind of query your site and your business logic will run against the database. Distance between the network housing the database and webserver and your office is also a factor.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Oct 24, 2007
    #2
  3. raymondp

    raymondp

    Will the databases have some kind of relationships with each other. Since databases addon have there own unique login, I don't one database will be able to connect to another database even though they are on the same server. If that is the case you will have no choice but to keep everything under one database.

    rcp
    DiscountASP.NET
    www.DiscountASP.NET
     
    raymondp, Oct 24, 2007
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page