Recently I am been testing few pieces of Storage projects of OpenSolaris with PostgreSQL.
One of tests involves using an iSCSI disk with
PostgreSQL. Unfortunately the storage that's available
is in Colorado while my PostgreSQL server is
located in Massachusetts. Latency will definitely be one of my
top problems since storage is halfway across the country
(in Colorado). Plus the fact that I will be running a database
server on my end doesn't really sound like a good idea.
Come to think about it, this could be a more common problem
nowadays since Cloud Storage (for example Amazon S3 Webservice )
could be optimistically half way across the country
and pessimistically be on the other side of the world.
So what are my options to solve such problems? …[Read more]