asp.net - Can web app and database be hosted on different servers (remote and local)? -

-

i apologize right away if misuse right ask questions here. yet, being tyro in web development , asp.net beginner, need advice experts.

i have developed asp.net webforms application deploy remote hosting server. application queries , updates database due purpose of being document registration system. sold different institutions i've imagined following scenario: host app on same server institutions , have databases on different server or on multiple different servers. have considered option because data amount expands storage provided hosting companies may insufficient.

my question is: possible accomplish scenario , if yes risks , how should it?

thank much!

yes, normal way it. however, need fast network connection between web server , database server. need consider service level (ie percentage up-time) , how redundancy needed achieve that.

there's easy way , harder way achieve this.

the easy way host application in microsoft azure. fast implement , flexible.

you can host database in sql azure database, microsoft recommend new development. can scaled small (and low cost) powerful (more cost).

similarly web application can scaled. can scale vertically, making machine more powerful, , horizontally adding more machines.

for both database , web application, scaling can changed or down in few minutes.

the harder way host application on virtual machines. need lot of knowledge configure , maintain this. instance, might need configure sql server alwayson.

this screen picture shows how can select pricing tier web application hosted in microsoft azure. (prices in gbp.)

enter image description here

you should host web app , database in same data centre ensure there fast network connections between them. can make them belong same "resource group", tells azure work together.

this shows how can select level sql azure database. (prices in gbp.)

enter image description here

see microsoft azure > azure pricing: https://azure.microsoft.com/en-gb/pricing/


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more