Re: [ADMIN] Hardware Configuration and other Stuff

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 03/18/2015 12:07 PM, Vivekanand Joshi wrote:


Here are few questions:

1.) I don't need a load balancing solution. It must be high availability
server and I can work with asynchronous replication. The most important
thing here would be recovery should be as fast as possible.

What approach would you recommend?

LinuxHA + Corosync/Pacemaker etc...


2.) Recommendations on indexes, WAL, table spaces. I am not asking about
on which key I need to make indexes, but an high level approach about
how to keep them? This might come out as a weird question to many but
please excuse me for being a novice.

This is too broad of a question without understanding the hardware it will be on.



*Most Important Question:*

3.) What would be the ideal hardware configuration for this requirement?
I know there is not a one-stop answer for this, but let's take it is a
starting point. We can come to a proper conclusion after a discussion.

What are the best on-line resources/books which can tell us about the
hardware requirements?

And see above. You need a consultant. I am sure you will get some decent responses but this isn't just about PostgreSQL, this is about architecture of a rather complex solution and a migration.

Sincerely,

Joshua D. Drake


--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc

Now I get it: your service is designed for a customer
base that grew up with Facebook, watches Japanese seizure
robot anime, and has the attention span of a gnat.
I'm not that user., "Tyler Riddle"



--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux