Replicating JDBC proxy
| От | henk53602@hotmail.com (henk53) |
|---|---|
| Тема | Replicating JDBC proxy |
| Дата | |
| Msg-id | 135a85f7.0405140438.7837b73c@posting.google.com обсуждение |
| Ответы |
Re: Replicating JDBC proxy
|
| Список | pgsql-jdbc |
I would like to have a constantly updated copy of my DB. In order to realize this I have though of the following scheme: A server is equiped with 3 NICs and is running a special 'proxy' JDBC implementation. The only thing this JDBC proxy does is: 1) Forwarding every update request on both ports. On each port a server is running a JDBC compliant DB (in my case, postgresql) 2) Forwarding every select request on only 1 port. Theoretically, this would give me a total synchronized DB, wouldn't it? However, this sounds relative simple to implement. I've seen a couple of replication efforts undertaken for postgresql that seems to take forever to finish. Am I overlooking something?
В списке pgsql-jdbc по дате отправления: