0

I am considering a scenario where different partitions/tablespace are replicated on different slaves. Is it possible to achieve this? If so, by which possible schemes.

Thanks.

Kabira K
  • 1,916
  • 2
  • 22
  • 38

1 Answers1

0

Your question is already tagged with "slony", so which problems have you encountered with it?

One of slony's drawbacks - and that is even quoted here - is the complex setup.

So another possibility is: Replicate all your data without partitioning using something like HA-JDBC, and distribute the "read only" load in the cluster.

Depending on your scenario (new system vs. handling with and existing performance bottleneck, using ORM or not), there might be different answers.

Chris
  • 5,584
  • 9
  • 40
  • 58
Beryllium
  • 12,808
  • 10
  • 56
  • 86
  • Thanks for taking a look. I went through slony documentation (the link you provided leads to empty page) but couldn't figure how to achieve this. I won't be able to replicate all of data on all slaves. – Kabira K May 22 '13 at 14:13
  • Thanks. Slony has concept of sets that allows for replicating a subset of data. – Kabira K May 22 '13 at 21:48