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 protected], 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 protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
