How to handle sequences and replication?
От | Bill Gribble |
---|---|
Тема | How to handle sequences and replication? |
Дата | |
Msg-id | 1017773654.22299.75.camel@flophouse обсуждение исходный текст |
Список | pgsql-general |
I'm totally new to distributed databases and rather new to SQL in general (only worked with it 6-8 months). I am trying to set up a fault-tolerant system which will allow clients to operate in a disconnected mode, using a local database, when the network (and the primary DB server) is offline, and synchronize changes later. I know that write replication is part of the answer to this, and that there are some tools available already to help with postgres write replication. However, there are some pretty obvious holes needing filled (for example, the app depends on integer key columns using values supplied by a sequence, which seems obviously wrong when there could be multiple clients operating disconnected servers using the same rules) and I'm wondering if there are standard approaches to this kind of problem. Are there good resources out there to help with the design of fault-tolerant (i.e. network failure, server failure, client-peer failure) database apps for networks of clients and servers? books, web sites, HOW-TO, etc? Thanks, Bill Gribble
В списке pgsql-general по дате отправления: