Re: PostgreSQL replication
От | Mauricio Breternitz |
---|---|
Тема | Re: PostgreSQL replication |
Дата | |
Msg-id | F138TVn2AI3F5Y0ZwBt00000d82@hotmail.com обсуждение исходный текст |
Ответ на | PostgreSQL replication (Oleg Bartunov <oleg@sai.msu.su>) |
Список | pgsql-hackers |
Oleg: I concur with this, and would like to collaborate as possible. [You may recall my messages from a couple weeks back. I'm looking at ways of implementing 'concurrent' PostGres on a NUMA machine that has both local memory and (a bit more costly) access to a shared memory]. Bettina Kemme's method relies on fast, reliable and ordered global communication, which is easily implemented on my target system, so her methods look a great fit. [Im my case, the 'replication' would only happen at the level of the buffer cache in each node, since all nodes have access to a shared file system]. Presently, per Tom Lane's suggestion, I'm looking at a different approach, in which I keep the shared memory segment in shared memory and check-in/check-out the buffers into local memory at proper times (which Tom suggested at the LockBuffer boundaries]. I'm open to suggestions/advice/... cheers Mauricio >From: Oleg Bartunov <oleg@sai.msu.su> >To: <pgsql-hackers@postgresql.org> >Subject: [HACKERS] PostgreSQL replication >Date: Thu, 3 May 2001 10:37:09 +0300 (GMT) > >Hi, > >here is an answer from Bettina Kemme - author of >Postgres-R - consisent replcation engine based on Postgres 6.4 >(URL of paper - http://citeseer.nj.nec.com/330257.html). >While I don't see much activity on replication topic I think it's >worth to discuss with Bettina design issue and co-ordinate >our plans for future release. > > Regards, > Oleg >_____________________________________________________________ >Oleg Bartunov, sci.researcher, hostmaster of AstroNet, >Sternberg Astronomical Institute, Moscow University (Russia) >Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ >phone: +007(095)939-16-83, +007(095)939-23-83 > >---------- Forwarded message ---------- >Date: Wed, 02 May 2001 18:26:58 -0400 >From: Bettina Kemme <kemme@cs.mcgill.ca> >To: Oleg Bartunov <oleg@sai.msu.su> >Subject: Re: Postgres-R question > >Oleg, > >we are currently working on producing a Postgres-R >version based on PostgreSQL 6.4 that can be released >for the public. Darren Johnson from sourcesoft institute is >actually working on this version right now. >Since PostgreSQL 7.1 has a quite different concurrency >control system than 6.4, upgrading Postgres-R to 7.1 is a bit more >difficult. >One of my students is going to work on this problem >during the summer (he is going to start next week, but at >the beginning he will have to do some reading to get familiar >with replicated etc). >We would be very happy to cooperate with the PostgreSQL >developers and make the replication part a part of PostgreSQL >(or at least an add-on feature). >The problem is that our approach requires, to a certain degree, >to change the underlying concurrency control method and >the transaction execution control. >That is, different to lazy replication schemes, it will >not be exclusively an add-on feature, but must be integrated into >existing code. Of course, >we are planning to design the system such that the user >(or system administrator) can choose between a replicated >and a non-replicated system. In the non-replicated system, >simply the original PostgreSQL will be executed. > >In the next days, I am going to have a closer look at >PostgreSQL 7.1 to figure out all the details. Again, >we are open for any kind of suggestions, support, cooperation >etc. > > Best > Bettina > >Oleg Bartunov wrote: > > > > Hello, > > > > I found your paper about database replication and your implementation > > based on Postgres. What's the status of your implementation ? > > Is't available for downloading ? I'm postgres developer and interested > > in database replication. Current version of PostgreSQL is 7.1 and > > it has much more feature than that of 6.4.2 but it still lacks >replication. > > I think your contribution would be very useful for other users. > > > > Regards, > > Oleg > > _____________________________________________________________ > > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > > Sternberg Astronomical Institute, Moscow University (Russia) > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > phone: +007(095)939-16-83, +007(095)939-23-83 > >-- >****************************************** >Bettina Kemme >School of Computer Science >McGill University Phone: +1 514 398 8930 >Montreal, Quebec Fax: +1 514 398 3883 >Canada E-mail: kemme@cs.mcgill.ca >http://www.cs.mcgill.ca/~kemme > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com
В списке pgsql-hackers по дате отправления: