Re: [GENERAL] Re: replication
От | Aaron J. Seigo |
---|---|
Тема | Re: [GENERAL] Re: replication |
Дата | |
Msg-id | 99111612001404.18220@stilborne обсуждение исходный текст |
Ответ на | Re: [GENERAL] Re: replication (Jeff Hoffmann <jeff@propertykey.com>) |
Список | pgsql-general |
hi... > my favorite hack is to wrap the c/c++ api so you can set up a group of > mirror database connections and then calling the wrapped functions will > call the original function on each of the mirror database connections. > i've really never thought of it as something that should be part of the > library, though, since that's pretty easy to implement in the > application. very cool... but i too agree that this shouldn't necessarily be in the libraries... this needs to be in the back end... otherwise, if you have multiple people performing updates on different replicated servers, how can you guarentee concurancy? how do you manage the differences between read-only and updateable replicants? (this can be done using your wrapper method, but quickly gets clumsy) also, it would make maintaining replication simpler if it were part of the back end process... and not prone to some app that goes around your wrapped lib and defeats the replication scheme altogether... imo, it should be part of the transaction system.... =) -- Aaron J. Seigo Sys Admin
В списке pgsql-general по дате отправления: