Re: deployment advice
Re: deployment advice
- Subject: Re: deployment advice
- From: Þór Sigurðsson <email@hidden>
- Date: Tue, 24 Sep 2013 07:57:56 +0000
- Thread-topic: deployment advice
On 23.9.2013, at 14:48, Theodore Petrosky wrote:
> I have an app that is running quite nicely on a mac mini OS X 10.6.8 with postgresql running on the same box.
>
> I am writing a companion app that needs to access this same database and with ERJGoups connect with the first app.
>
> All my pretesting deployment is being done on a second box. Again a mac mini but with Centos 6.2 and postgresql running on the same box.
>
> I just started to think, maybe I could just point the app on box number 2 (Centos box) to the postgresql implementation on box 1 and set the ERJGroups IP to box one and be done. I already set the pg_hba.conf to permit box 2 to talk to box 1 postgresql implementation so this shouldn't be an issue.
>
> Let each app live on its own box.
>
> Keep in mind that these apps will have little real usage. Half a dozen users on each box banging all day long.
>
> Is there any reason I shouldn't do this?
One reason why you should not, plenty of reasons why you should.
Why not:
Using the same data[base] for development and betatesting/production means at some point the development screws up and mangles the data[base] for the user ==> negative user/tester experience.
Why:
Using the same database server but _separate_ databases (eg: mydata and mydata_dev ) saves cpu cycles - no need to have two separate servers running unless you want replication or load balancing.
Half a dozen users is no measure - the size of the request and result set is a better measure - as well as the [explain]. But - for a "normal" web application, a dozen users should pose as a zero-threat to the database :)
It is less time-consuming to manage one database than two.
FWIW - I recommend having the db running on the Centos box rather than the OS X box. Get http://sourceforge.net/projects/autopgsqlbackup/ and configure it - you'll be glad if/when something happens to your data (make sure you have enough disk space).
/Þór
________________________________
Sameinaðir kraftar í lofti, láði og legi
Þann 1. júlí 2013 tók Samgöngustofa til starfa. Með stofnun hennar sameinast stjórnsýsla og eftirlit samgöngumála og þangað færast öll verkefni Flugmálastjórnar Íslands og Umferðarstofu auk stjórnsýslu- og eftirlitsverkefna Siglingastofnunar Íslands og Vegagerðarinnar.
Starfstöðvar fyrrum Umferðarstofu, Siglingastofnunar og Flugmálastjórnar Íslands munu haldast óbreyttar fyrst um sinn.
Samgöngustofa, pósthólf 470, 202 Kópavogur, sími 480 6000 - email@hidden, http://www.samgongustofa.is
________________________________
Fyrirvari á tölvupósti / e-mail disclaimer
http://ww2.us.is/fyrirvari
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden