Re: Migrating to Postgresql and new hardware

От: Lars
Тема: Re: Migrating to Postgresql and new hardware
Дата: ,
Msg-id: E0B1224AD40B544B9DE1BCC6008E95220D1F192D50@UF05.unifaun.se
(см: обсуждение, исходный текст)
Ответ на: Re: Migrating to Postgresql and new hardware  (Andy Colson)
Список: pgsql-performance

Скрыть дерево обсуждения

Migrating to Postgresql and new hardware  (Lars, )
 Re: Migrating to Postgresql and new hardware  (Andy Colson, )
  Re: Migrating to Postgresql and new hardware  (Andy Colson, )
  Re: Migrating to Postgresql and new hardware  (Lars, )
 Re: Migrating to Postgresql and new hardware  ("Strange, John W", )
  Re: Migrating to Postgresql and new hardware  ("Mark Felder", )
  Re: Migrating to Postgresql and new hardware  (Lars, )
 Re: Migrating to Postgresql and new hardware  ("mark", )
  Re: Migrating to Postgresql and new hardware  (Lars, )
   Re: Migrating to Postgresql and new hardware  (Craig Ringer, )
    Re: Migrating to Postgresql and new hardware  (Andy Colson, )
     Re: Migrating to Postgresql and new hardware  (Scott Marlowe, )
   Re: Migrating to Postgresql and new hardware  (Greg Smith, )
    Re: Migrating to Postgresql and new hardware  (Lars, )
 Re: Migrating to Postgresql and new hardware  (Craig Ringer, )
 Re: Migrating to Postgresql and new hardware  (Scott Marlowe, )

> No idea what mysql thinks a shard is, but in PG we have read-only hot standby's.
I used sharding as an expression for partitioning data into several databases.
Each user in the system is unaware of any other user. The user never accesses the private data of another user. Each
usercould in theory be assigned their own database server. This makes it easy to split the 40000 users over a number of
databaseservers. There are some shared data that is stored in a special "shared" database. 

> The standby database is exactly the same as the master (save a bit of
> data that has not been synced yet.)  I assume you know this... but I'd
> really recommend trying out PG's hot-standby and make sure it works the
> way you need (because I bet its different than mysql's).

> Assuming the "shared" and the "sharded" databases are totally different
> (lets call them database a and c), with the PG setup you'd have database
> a on one computer, then one master with database b on it (where all
> writes go), then several hot-standby's mirroring database b (that
> support read-only queries).
As our data is easily partitioned into any number of servers we do not plan to use replication for load balancing. We
dohowever plan to use it to set up a backup site. 

>  Its pretty hard to guess what your usage pattern is (70% read,
>   small columns, no big blobs (like photos), etc)... and even then we'd
> still have to guess.
It's more like 40% read 60% write.

> Not only will I not compare apples to oranges, but I really wont compare
> apples in Canada to oranges in Japan. :-)
Hehe

/Lars


В списке pgsql-performance по дате сообщения:

От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: Running PostgreSQL as fast as possible no matter the consequences
От: Chris Browne
Дата:
Сообщение: Re: the XID question