You are viewing lotso

SQL - pgpool-II (Step 2)

So, this is step 2 to getting replication + load balancing to work for postgresql.

I've already detailed the 1st step to getting Slony to work in a previous blog. (that was on a development machine/vmware image. When I tried it on the production/slave server, I was faced with some issues which I might elaborate in another post. It all boils down myself shooting my own foot. What to do, it was a time when I wasn't connected to the internet and thus, no googling privileges.)

So, here are my experience with pgpool and it's also a little bit like shooting myself in the foot (again!)

First off, I started out with using the _wrong_ version of pgpool. The newest version of pgpool-II (note that -> pgpool-II and not pgpool-I) is 2.0.1 and the newest version of pgpool found on the yum mirrors (I'm using centos4/5) was 2.01 (well, the numbers match don't they?) The only different was the one available on the yum mirrors was that of pgpool-I and not pgpool-II. However, since documentation on pgpool were sparse (I googled everywhere, read all the relevant and NON-relevant mailing list and found nothing much to go on by.)

It was not until I signed up to the pgpool mailing list (which was very low volume by the way) and interacting with one of the Japanese developer did I find out that I was in-fact using the OLD version of pgpool which was pgpool-I which, unfortunately had the same version as pgpool-II!
(I even downloaded the tarball from pgfoundry[but I _did_ download the _correct_ tarball] and searched through the source to figure out what was happening.)

By that little(big!) mistake I did, I was tearing my hair out for the past 3+ weeks. (well, I didn't play with it everyday and in-between my dayjob and such....) However, I did get pgpool-I to work properly with a little tweaking and I could get load-balancing to work, albeit it was not as advertise as in I can't get it to work without it functioning as replication as well. (of sorts anyway, which was the reason I can't deploy it as I was using slony)

So, after I found out my mistake last friday, I started to google for a new RPM of pgpool-II (newest version 2.0.1) but was unable to locate it in any place. The latest RPM I could find was that of version 1.3 which was _too_ old in a sense. (It's always better to have the latest stable version) So, I had to engineer a way to get a RPM from the tarball. Luckily, the tarball from pgfoundry also contained the pgpool.spec file, which was packaged by Devrim. Unfortunately for my, the spec file was a little old in that it refered to the 2.0 beta1 version. It wasn't too much of an issue as all it needed was a little hack here and a little hack there. (I was getting bad owner/group permission error which I narrowed down to the .spec file not having valid user/groups.)

After that was done a rpmbuild -ba pgpool.spec and I got an RPM.

After that, I just installed it, configured the pgpool.conf and got it up and running as advertised with replication mode off, master slave mode on and load balancing mode on.

Cool.. I'm rolling this to production on Monday.

So, this means I'll have 1x Master (1.7G celeron/768MB ram, 500G Raid1 with ~200GB of data), 1xSlave (1.7G celeron/512MB ram 3x160GB raid0). I still have another box sitting under my desk which has even poorer specs than the above, but I think it'll work out just fine.

Cool..Ultra Cool Even!!

If anyone wants the RPM or the modified spec file, do drop me a line and I'll post it to you or something.
Tags: ,

Comments

(Anonymous)

want to ask

hye there. im am new with pgpool-II. i want to ask u whether do i need to create my own schema to replicate my own database.

thanks.

el_nina5544@yahoo.com

(Anonymous)

iSUYijAkEdTJw

APyjuL f81tpvn7894323ndrx

(Anonymous)

zUvXZENaYPcM

tickets_3.txt;2;2

(Anonymous)

zqHqkkVPLEJRI

tickets_5.txt;2;2

(Anonymous)

FnNZlGsMzFpyv

this is be cool 8) tub doubletree hotel cheap internet rates qaxei

(Anonymous)

FnljjwLTBpd

i'm fine good work hotel and airfare packages accommodation cheap hotels majorca spain 638559

(Anonymous)

SFyHqWgSFIwcc

I love this site bank cheap hotels in nib
I just love this site, so many cheap gifts you can purchase for Valentine Day. My cheapest picks start at $2.
“ Melissa "Can I just tell you how much I LOVE your site. You are a woman after my own heart. I never seem to find the cool kids things I am looking for.
I never seem to find the cool kids things I am looking for. Then there they are on your site. " Wendy "Your blog is a daily "must read" for me.
And the important thing is if you can help them to spread the website out, you can earn up to for you purchase.
And the important thing is if you can help them to spread the website out, you can earn up to for you purchase.
When you start your website up, you start out thinking about how you want your site to look and what functionality you want it to have.
The last thing you do before you actually start going ahead and coding your web site is work out the visual design of it—the page layouts, and the colour scheme, etc.
I’m sure you can think of many more but since Valentine’s Day is on the 14th, this seems like a good number to stop in this particular list.
And the important thing is if you can help them to spread the website out, you can earn up to for you purchase.
I just love this site, so many cheap gifts you can purchase for Valentine Day. My cheapest picks start at $2.

(Anonymous)

lOTejdyJdaxfUOtPwpE

Thanks funny site cheap specials cheap hotels in cambridge ma :)))
Best Site Good Work cheap specials cheap hotels in cambridge ma . . . Bmqlryei said on AM. Best Site Good Work cheap specials cheap hotels in cambridge ma .
Com Ueqmuopc 2 July Cool site goodluck :) connected rooms cheap hotels in myrtle beach south carolina near family kingdom lrlgqh Dntyoevy 2 July Very Good Site offers cheap hotel rooms in indianapolis qiyuue Oicpvxwt 2 July Thanks funny site cheap specials cheap hotels in cambridge ma Sajidibz 2 July Gloomy tales vegas and hotel cheapest hotels london btxm Ndegfewc 2 July Jonny was here mrytle beach cheap hotels in maui hawaii xidhwj Smfwjors 2 July i'm fine good work for las vegas cheap flights with hotel accommodation to spain Cdylpwuh 1 July Thanks funny site vegas cheap flight hotel mdqnm abraham 28 June GvXZK9 fv9db5dgbnvybfv5 halowi 21 June You can order in us bank accounts, debit and credit cards we sell.
” Tzcpwkzw Says: It’s serious anal fissure diet June 29th, at pm Kcjivrfi Says: Hello good day analingus =-DD June 29th, at pm Jqkpcoae Says: magic story very thanks nuclear dna analyses June 29th, at pm Pdmgkism Says: real beauty page history of the panama canal xdgnx June 30th, at pm Ytpfsbsr Says: very best job william wordsworth poetry analysis :OOO June 30th, at pm Ndkmzgww Says: I love this site hot porno %DD June 30th, at pm Bctxijeu Says: magic story very thanks corinthian college swot analysis zlcjnu June 30th, at pm Qvazgkna Says: Best Site good looking xxx porn June 30th, at pm Prrnkxro Says: Best Site good looking kauai luxury hotels discount flights cheap domestic flights =P July 1st, at pm Enbdkbac Says: Excellent work, Nice Design accommodations cheap hotels in rocky point %P July 1st, at pm Rfiaokpy Says: It’s funny goodluck ibiza and hotel cheap maui car rental and hotel package July 2nd, at am Xqriqoki Says: good material thanks cheap deals cheap hotels in July 2nd, at am Kqfroaoa Says: I love this site cheap bed and breakfast or hotel cheap airline flights hotels luxury hotels July 2nd, at am Adzsfjtd Says: perfect design thanks in mexico cheap hotels in venice uje July 2nd, at am Gjnernbk Says: Very funny pictures portland or cheap russian hotels hmyba July 2nd, at am Choaoark Says: real beauty page benidorm cheap airline fares orlando hotels July 2nd, at am Qyteranc Says: Wonderfull great site hotels peronne cheap hotels usa July 2nd, at am Fnrpyceg Says: Gloomy tales california cheap hotel motels seattle nearaurora avenue north July 2nd, at am Xfkuhmkj Says: Best Site good looking discount hotels cheap hotels kcmo airport July 2nd, at am Ledeswod Says: Good crew it’s cool :) hotels by gatwick airport brussels cheap hotel July 2nd, at am Jjpaqwir Says: Very interesting tale rates sacramento cheap hotels or hostels =] July 2nd, at am Isteyvqj Says: Very Good Site lauderdale pointtravel compare travel deals discount hotels cheap vanmsb July 2nd, at pm Ocrqyhjf Says: hotels in venice cheap rates for hotels and motels =-OOO July 2nd, at pm Mukknxdd Says: Thanks funny site valley cheap taiwan hotels July 2nd, at pm Vmjucwyt Says: real beauty page malaga cheap hotels on oahu %-PPP July 2nd, at pm Iivspjjy Says: i’m fine good work florida cheapweeklyhotelrates %D July 2nd, at pm Ziaongym Says: It’s serious texas cheap vegas kldxe July 2nd, at pm Uoliwvch Says: Cool site goodluck :) rate on a luxury hotel cheap hotels birch run mi 8-D July 2nd, at pm Mnniotgk Says: Best Site Good Work hotels near olimpico stadium in rome cheap hotels near white haven pa July 2nd, at pm Wdvsxsdo Says: It’s funny goodluck laughlin hotels jakarta cheap hotel July 2nd, at pm Bazsxljl Says: Gloomy tales cheap specials cheap hotels in cambridge ma July 2nd, at pm Biijtbje Says: Very Good Site newyork hotels cheap hotel portland xdnb July 2nd, at pm Anbbajbh Says: It’s serious in london england cheap July 3rd, at am Bhtsjszg Says: Very interesting tale virginia beach va cheap hotels casa grande arizona %-PP July 3rd, at am Bhvpjoly Says: Jonny was here connected rooms best cheap hotels in san francisco July 3rd, at am Nxldjdpt Says: real beauty page miami cheap hotel July 3rd, at am Omqceqfl Says: I’m happy very good site teenage slang dictionary hebhs teens photes jki July 8th, at pm Citpgqsw Says: I love this site July 14th, at pm Соколыч Says: Да уж… Тут как говорится: Аппетит приходит во время еды :) September 25th, at am Leave a Reply Name (required) Mail (will not be published) (required) Website XHTML: You can use these tags:
[Error: Irreparable invalid markup ('<a [...] <b>') in entry. Owner must fix manually. Raw contents below.]

” Tzcpwkzw Says: It’s serious anal fissure diet June 29th, at pm Kcjivrfi Says: Hello good day analingus =-DD June 29th, at pm Jqkpcoae Says: magic story very thanks nuclear dna analyses June 29th, at pm Pdmgkism Says: real beauty page history of the panama canal xdgnx June 30th, at pm Ytpfsbsr Says: very best job william wordsworth poetry analysis :OOO June 30th, at pm Ndkmzgww Says: I love this site hot porno %DD June 30th, at pm Bctxijeu Says: magic story very thanks corinthian college swot analysis zlcjnu June 30th, at pm Qvazgkna Says: Best Site good looking xxx porn June 30th, at pm Prrnkxro Says: Best Site good looking kauai luxury hotels discount flights cheap domestic flights =P July 1st, at pm Enbdkbac Says: Excellent work, Nice Design accommodations cheap hotels in rocky point %P July 1st, at pm Rfiaokpy Says: It’s funny goodluck ibiza and hotel cheap maui car rental and hotel package July 2nd, at am Xqriqoki Says: good material thanks cheap deals cheap hotels in July 2nd, at am Kqfroaoa Says: I love this site cheap bed and breakfast or hotel cheap airline flights hotels luxury hotels July 2nd, at am Adzsfjtd Says: perfect design thanks in mexico cheap hotels in venice uje July 2nd, at am Gjnernbk Says: Very funny pictures portland or cheap russian hotels hmyba July 2nd, at am Choaoark Says: real beauty page benidorm cheap airline fares orlando hotels July 2nd, at am Qyteranc Says: Wonderfull great site hotels peronne cheap hotels usa July 2nd, at am Fnrpyceg Says: Gloomy tales california cheap hotel motels seattle nearaurora avenue north July 2nd, at am Xfkuhmkj Says: Best Site good looking discount hotels cheap hotels kcmo airport July 2nd, at am Ledeswod Says: Good crew it’s cool :) hotels by gatwick airport brussels cheap hotel July 2nd, at am Jjpaqwir Says: Very interesting tale rates sacramento cheap hotels or hostels =] July 2nd, at am Isteyvqj Says: Very Good Site lauderdale pointtravel compare travel deals discount hotels cheap vanmsb July 2nd, at pm Ocrqyhjf Says: hotels in venice cheap rates for hotels and motels =-OOO July 2nd, at pm Mukknxdd Says: Thanks funny site valley cheap taiwan hotels July 2nd, at pm Vmjucwyt Says: real beauty page malaga cheap hotels on oahu %-PPP July 2nd, at pm Iivspjjy Says: i’m fine good work florida cheapweeklyhotelrates %D July 2nd, at pm Ziaongym Says: It’s serious texas cheap vegas kldxe July 2nd, at pm Uoliwvch Says: Cool site goodluck :) rate on a luxury hotel cheap hotels birch run mi 8-D July 2nd, at pm Mnniotgk Says: Best Site Good Work hotels near olimpico stadium in rome cheap hotels near white haven pa July 2nd, at pm Wdvsxsdo Says: It’s funny goodluck laughlin hotels jakarta cheap hotel July 2nd, at pm Bazsxljl Says: Gloomy tales cheap specials cheap hotels in cambridge ma July 2nd, at pm Biijtbje Says: Very Good Site newyork hotels cheap hotel portland xdnb July 2nd, at pm Anbbajbh Says: It’s serious in london england cheap July 3rd, at am Bhtsjszg Says: Very interesting tale virginia beach va cheap hotels casa grande arizona %-PP July 3rd, at am Bhvpjoly Says: Jonny was here connected rooms best cheap hotels in san francisco July 3rd, at am Nxldjdpt Says: real beauty page miami cheap hotel July 3rd, at am Omqceqfl Says: I’m happy very good site teenage slang dictionary hebhs teens photes jki July 8th, at pm Citpgqsw Says: I love this site July 14th, at pm Соколыч Says: Да уж… Тут как говорится: Аппетит приходит во время еды :) September 25th, at am Leave a Reply Name (required) Mail (will not be published) (required) Website XHTML: You can use these tags: <a href title <abbr title <acronym title <b> <blockquote cite <cite> <code> <del datetime <em> <i> <q cite <strike> <strong> « Now You Can Enjoy Videos Offline–How to Capture and Download Videos with Web Video Downloader.
Com Ueqmuopc 2 July Cool site goodluck :) connected rooms cheap hotels in myrtle beach south carolina near family kingdom lrlgqh Dntyoevy 2 July Very Good Site offers cheap hotel rooms in indianapolis qiyuue Oicpvxwt 2 July Thanks funny site cheap specials cheap hotels in cambridge ma Sajidibz 2 July Gloomy tales vegas and hotel cheapest hotels london btxm Ndegfewc 2 July Jonny was here mrytle beach cheap hotels in maui hawaii xidhwj Smfwjors 2 July i'm fine good work for las vegas cheap flights with hotel accommodation to spain Cdylpwuh 1 July Thanks funny site vegas cheap flight hotel mdqnm abraham 28 June GvXZK9 fv9db5dgbnvybfv5 halowi 21 June You can order in us bank accounts, debit and credit cards we sell.
Com Ueqmuopc 2 July Cool site goodluck :) connected rooms cheap hotels in myrtle beach south carolina near family kingdom lrlgqh Dntyoevy 2 July Very Good Site offers cheap hotel rooms in indianapolis qiyuue Oicpvxwt 2 July Thanks funny site cheap specials cheap hotels in cambridge ma Sajidibz 2 July Gloomy tales vegas and hotel cheapest hotels london btxm Ndegfewc 2 July Jonny was here mrytle beach cheap hotels in maui hawaii xidhwj Smfwjors 2 July i'm fine good work for las vegas cheap flights with hotel accommodation to spain Cdylpwuh 1 July Thanks funny site vegas cheap flight hotel mdqnm abraham 28 June GvXZK9 fv9db5dgbnvybfv5 halowi 21 June You can order in us bank accounts, debit and credit cards we sell.
Com Ueqmuopc 2 July Cool site goodluck :) connected rooms cheap hotels in myrtle beach south carolina near family kingdom lrlgqh Dntyoevy 2 July Very Good Site offers cheap hotel rooms in indianapolis qiyuue Oicpvxwt 2 July Thanks funny site cheap specials cheap hotels in cambridge ma Sajidibz 2 July Gloomy tales vegas and hotel cheapest hotels london btxm Ndegfewc 2 July Jonny was here mrytle beach cheap hotels in maui hawaii xidhwj Smfwjors 2 July i'm fine good work for las vegas cheap flights with hotel accommodation to spain Cdylpwuh 1 July Thanks funny site vegas cheap flight hotel mdqnm abraham 28 June GvXZK9 fv9db5dgbnvybfv5 halowi 21 June You can order in us bank accounts, debit and credit cards we sell.

(Anonymous)

dsxuBJquTPnEO

perfect design thanks

(Anonymous)

JFTDwjHQzngd

1nQOUy hi! hice site!

(Anonymous)

SJOwYfPbeBmVSTzsdWe

ZGMhkX hi! hice site!

(Anonymous)

need documentation on Pg pool

hey..

I am looking for PG pool documentation... Can you tell me how do I find out..

Email me at megha1983us@gmail.com

Thanks

(Anonymous)

adobe creative suite 4 design premium for mac

http://updatesoftonline.com/brand/adobe/creative_suite_5_web_premium/ creative suite 5 web premium
http://updatesoftonline.com/brand/altrasoft/altrasoft_icon_editor_1_0_windows/ altrasoft icon editor 1 0 windows
http://updatesoftonline.com/brand/flexera_software/flexera_software_installshield_2008_windows/ flexera software installshield 2008 windows
http://updatesoftonline.com/brand/cyberlink/truetheater_enhancer_1_0_1314/ truetheater enhancer 1 0 1314
http://updatesoftonline.com/brand/focus_multimedia/focus_multimedia_britannica_ultimate_2009_win_mac/ focus multimedia britannica ultimate 2009 win mac
http://updatesoftonline.com/brand/corel/wordperfect_office_x5/ wordperfect office x5
http://updatesoftonline.com/brand/slysoft/any_dvd_converter_pro_4_1_0/ any dvd converter pro 4 1 0
http://updatesoftonline.com/brand/lynda/photoshop_cs4_selections_in_depth/ photoshop cs4 selections in depth
http://updatesoftonline.com/brand/propellerheads/recycle_2_1/ recycle 2 1
http://updatesoftonline.com/brand/adobe/adobe_framemaker_server_9_0_windows/ adobe framemaker server 9 0 windows
http://updatesoftonline.com/brand/avast/avast_professional_4_8_windows/ avast professional 4 8 windows
http://updatesoftonline.com/brand/microsoft/project_pro_2010_beta_1/ project pro 2010 beta 1
http://updatesoftonline.com/brand/originlab/origin_pro_7_5/ origin pro 7 5
http://updatesoftonline.com/brand/premier_system/premier_system_premier_12_3_windows/ premier system premier 12 3 windows
http://updatesoftonline.com/brand/paragon/ntfs_for_mac_os_x_7_0_3/ ntfs for mac os x 7 0 3

April 2009

S M T W T F S
   1234
567891011
12131415161718
19202122232425
2627282930  
Powered by LiveJournal.com