autoscale cluster

--001485f44a847e7f82048434c81c
Content-Type: text/plain; charset=ISO-8859-1

hi everyone,

I'm looking for info about autoscale a cluster. I mean...with amazon you can
generate automatically virtual machine as far as you need...if you configure
that when the machine get 90% busy a new one will be created. The thing is
that i'd like to do something like that for my database...whem my datbase
get 90% busy...automatically another machine is created to share the charge.


I dont know if it is possible..can anyone give some piece of advice???

thanks

--001485f44a847e7f82048434c81c
Content-Type: text/html; charset=ISO-8859-1

hi everyone,



I'm looking for info about autoscale a cluster. I mean...with amazon
you can generate automatically virtual machine as far as you need...if
you configure that when the machine get 90% busy a new one will be
created. The thing is that i'd like to do something like that for my
database...whem my datbase get 90% busy...automatically another machine
is created to share the charge.





I dont know if it is possible..can anyone give some piece of advice???



thanks

--001485f44a847e7f82048434c81c--

Re: autoscale cluster

On Wed, Apr 14, 2010 at 10:22 AM, Jesus arteche wrote:
> hi everyone,
>
> I'm looking for info about autoscale a cluster. I mean...with amazon you can
> generate automatically virtual machine as far as you need...if you configure
> that when the machine get 90% busy a new one will be created. The thing is
> that i'd like to do something like that for my database...whem my datbase
> get 90% busy...automatically another machine is created to share the charge.

Auto-creating a new app server is a whole different idea than
autogenerating another database server.

An app server is a relatively independent processing unit. Requests
go in, get processed, and results are spit back out. Each request is
independent of the other requests.

A database is a storage engine that ensures that each unit of
information put into it fits within all the proper constraints of all
the other data already in place, and that updates and changes happen
in whole or none at all.

How do you just "throw another db" at a problem? You cluster it.
That's a complex problem to solve in comparison to app servers.

> I dont know if it is possible..can anyone give some piece of advice???

You can most certainly using clustering to increase db performance for
many work loads. Whether a certain method works for you or not
depends on what you're doing. Making it automagically create new
virtual cluster members sounds like a really cool feature that would
make you pull your hair out developing it.

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

amazon ec2

Hi all

Just curious to find out if anybody is running pdsql on amazon aws and what=
kind of backup features you use.

Thanks,

Vitaly Burshteyn
Senior Network Engineer
Broadway.com, Theatre Direct International
729=A0 7th Avenue
New York, New York 10019
Phone: 212.817.9117
Cell# 917-701-5732

____________________________________=0D
The information contained in this transmission may contain privileged =0D
and confidential information. It is intended only for the use of the =0D
person(s) named above. If you are not the intended recipient, you are =0D
hereby notified that any review, dissemination, distribution or =0D
duplication of this communication is strictly prohibited. If you are =0D
not the intended recipient, please contact the sender by reply email =0D
and destroy all copies of the original message.

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

Re: amazon ec2

On Wed, Apr 14, 2010 at 2:16 PM, Vitaly Burshteyn
wrote:
> Just curious to find out if anybody is running pdsql on amazon aws and what kind of backup features you use.

For one group's experience, consider the following:



rls

--
:wq

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

Re: amazon ec2

This is a multi-part message in MIME format.

------_=_NextPart_001_01CADC1E.2BAD7A96
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: base64

VGhhbmtzIGZvciB0aGUgZmFzdCByZXNwb25zZS4NCg0KV2UgYXJlIGN1cnJl
bnRseSBzaGlwcGluZyBXQUwgZmlsZXMgd2l0aCBza3l0b29scyBXQUxNR1Ig
YW5kIEkgd2FzIGp1c3Qgd2FuZGVyaW5nIGlmIHRoZXJlIGFyZSBvdGhlciwg
ZWFzaWVyIHdheSBvZiBkb2luZyB0aGluZ3MuDQoNCg0KDQotLS0tLSBPcmln
aW5hbCBNZXNzYWdlIC0tLS0tDQpGcm9tOiBSb3NzZXIgU2Nod2FyeiA8cm9z
c2VyLnNjaHdhcnpAZ21haWwuY29tPg0KVG86IFZpdGFseSBCdXJzaHRleW4N
CkNjOiBwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZyA8cGdzcWwtYWRtaW5A
cG9zdGdyZXNxbC5vcmc+DQpTZW50OiBXZWQgQXByIDE0IDE3OjU4OjE5IDIw
MTANClN1YmplY3Q6IFJlOiBbQURNSU5dIGFtYXpvbiBlYzINCg0KT24gV2Vk
LCBBcHIgMTQsIDIwMTAgYXQgMjoxNiBQTSwgVml0YWx5IEJ1cnNodGV5bg0K
PHZidXJzaHRleW5AYnJvYWR3YXkuY29tPiB3cm90ZToNCj4gSnVzdCBjdXJp
b3VzIHRvIGZpbmQgb3V0IGlmIGFueWJvZHkgaXMgcnVubmluZyBwZHNxbCBv
biBhbWF6b24gYXdzIGFuZCB3aGF0IGtpbmQgb2YgYmFja3VwIGZlYXR1cmVz
IHlvdSB1c2UuDQoNCkZvciBvbmUgZ3JvdXAncyBleHBlcmllbmNlLCBjb25z
aWRlciB0aGUgZm9sbG93aW5nOg0KDQo8aHR0cDovL2Jsb2cuZW5kcG9pbnQu
Y29tLzIwMTAvMDIvcG9zdGdyZXNxbC1lYzItZWJzLXJhaWQwLXNuYXBzaG90
Lmh0bWw+DQoNCnJscw0KDQotLSANCjp3cQ0KCl9fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fXw0KVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5l
ZCBpbiB0aGlzIHRyYW5zbWlzc2lvbiBtYXkgY29udGFpbiBwcml2aWxlZ2Vk
IA0KYW5kIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbi4gIEl0IGlzIGludGVu
ZGVkIG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIA0KcGVyc29uKHMpIG5hbWVk
IGFib3ZlLiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50
LCAgeW91IGFyZSANCmhlcmVieSBub3RpZmllZCB0aGF0IGFueSByZXZpZXcs
IGRpc3NlbWluYXRpb24sIGRpc3RyaWJ1dGlvbiBvciANCmR1cGxpY2F0aW9u
IG9mIHRoaXMgY29tbXVuaWNhdGlvbiBpcyBzdHJpY3RseSBwcm9oaWJpdGVk
LiBJZiB5b3UgYXJlIA0Kbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHBs
ZWFzZSBjb250YWN0IHRoZSBzZW5kZXIgYnkgcmVwbHkgZW1haWwgDQphbmQg
ZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmlnaW5hbCBtZXNzYWdlLgo=

------_=_NextPart_001_01CADC1E.2BAD7A96
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8v
RU4iPg0KPEhUTUw+DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRl
bnQtVHlwZSIgQ09OVEVOVD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4N
CjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0iTVMgRXhjaGFuZ2Ug
U2VydmVyIHZlcnNpb24gNi41Ljc2NTEuNTkiPg0KPFRJVExFPlJlOiBbQURN
SU5dIGFtYXpvbiBlYzI8L1RJVExFPg0KPC9IRUFEPg0KPEJPRFk+DQo8IS0t
IENvbnZlcnRlZCBmcm9tIHRleHQvcGxhaW4gZm9ybWF0IC0tPg0KDQo8UD48
Rk9OVCBTSVpFPTI+VGhhbmtzIGZvciB0aGUgZmFzdCByZXNwb25zZS48QlI+
DQo8QlI+DQpXZSBhcmUgY3VycmVudGx5IHNoaXBwaW5nIFdBTCBmaWxlcyB3
aXRoIHNreXRvb2xzIFdBTE1HUiBhbmQgSSB3YXMganVzdCB3YW5kZXJpbmcg
aWYgdGhlcmUgYXJlIG90aGVyLCBlYXNpZXIgd2F5IG9mIGRvaW5nIHRoaW5n
cy48QlI+DQo8QlI+DQo8QlI+DQo8QlI+DQotLS0tLSBPcmlnaW5hbCBNZXNz
YWdlIC0tLS0tPEJSPg0KRnJvbTogUm9zc2VyIFNjaHdhcnogJmx0O3Jvc3Nl
ci5zY2h3YXJ6QGdtYWlsLmNvbSZndDs8QlI+DQpUbzogVml0YWx5IEJ1cnNo
dGV5bjxCUj4NCkNjOiBwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZyAmbHQ7
cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcmZ3Q7PEJSPg0KU2VudDogV2Vk
IEFwciAxNCAxNzo1ODoxOSAyMDEwPEJSPg0KU3ViamVjdDogUmU6IFtBRE1J
Tl0gYW1hem9uIGVjMjxCUj4NCjxCUj4NCk9uIFdlZCwgQXByIDE0LCAyMDEw
IGF0IDI6MTYgUE0sIFZpdGFseSBCdXJzaHRleW48QlI+DQombHQ7dmJ1cnNo
dGV5bkBicm9hZHdheS5jb20mZ3Q7IHdyb3RlOjxCUj4NCiZndDsgSnVzdCBj
dXJpb3VzIHRvIGZpbmQgb3V0IGlmIGFueWJvZHkgaXMgcnVubmluZyBwZHNx
bCBvbiBhbWF6b24gYXdzIGFuZCB3aGF0IGtpbmQgb2YgYmFja3VwIGZlYXR1
cmVzIHlvdSB1c2UuPEJSPg0KPEJSPg0KRm9yIG9uZSBncm91cCdzIGV4cGVy
aWVuY2UsIGNvbnNpZGVyIHRoZSBmb2xsb3dpbmc6PEJSPg0KPEJSPg0KJmx0
OzxBIEhSRUY9Imh0dHA6Ly9ibG9nLmVuZHBvaW50LmNvbS8yMDEwLzAyL3Bv
c3RncmVzcWwtZWMyLWVicy1yYWlkMC1zbmFwc2hvdC5odG1sIj5odHRwOi8v
YmxvZy5lbmRwb2ludC5jb20vMjAxMC8wMi9wb3N0Z3Jlc3FsLWVjMi1lYnMt
cmFpZDAtc25hcHNob3QuaHRtbDwvQT4mZ3Q7PEJSPg0KPEJSPg0KcmxzPEJS
Pg0KPEJSPg0KLS08QlI+DQo6d3E8QlI+DQo8L0ZPTlQ+DQo8L1A+DQoNCgo8
L0JPRFk+DQo8L0hUTUw+

------_=_NextPart_001_01CADC1E.2BAD7A96--