{ Community }
  • Academy
  • Docs
  • Developers
  • Resources
    • Community Articles
    • Apigee on GitHub
    • Code Samples
    • Videos & eBooks
    • Accelerator Methodology
  • Support
  • Ask a Question
  • Spaces
    • Product Announcements
    • General
    • Edge/API Management
    • Developer Portal (Drupal-based)
    • Developer Portal (Integrated)
    • API Design
    • APIM on Istio
    • Extensions
    • Business of APIs
    • Academy/Certification
    • Analytics
    • Events
    • Hybrid
    • Integration (AWS, PCF, Etc.)
    • Microgateway
    • Monetization
    • Private Cloud Deployment
    • Insights
    • IoT Apigee Link
    • BaaS/Usergrid
    • BaaS Transition/Migration
    • Apigee-127
    • New Customers
    • Topics
    • Questions
    • Articles
    • Ideas
    • Leaderboard
    • Badges
  • Log in
  • Sign up

Get answers, ideas, and support from the Apigee Community

  • Home /
  • Private Cloud Deployment /
avatar image
1
Question by kkhanna · Jul 12, 2017 at 03:13 PM · 635 Views Portals - Drupalpostgresprivate cloud deploymentmaster-standby

Multiple Postgres databases for Apigee Developer Portal

Hi,

We want to use postgres in a master-slave mode for Developer Portal. While i can configure Postgres in a master-standby mode, how do i tell the Developer Portal about both database instances so that it can automatically failover.

Would the silent config file include both hosts in PG_HOSTS as shown ?

PG_HOST="$NODE5, $NODE6"

or

can we use these variables for DevPortal config files

PG_MASTER=$NODE5 
PG_STANDBY=$NODE6
Comment
Add comment
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Close

1 Answer

  • Sort: 
avatar image
0

Answer by Mohammed Zuber · Jul 13, 2017 at 06:02 PM

Hi @kkhanna,

As far as I know, we cannot do like the case that you have mentioned. If you want to do an HA of Postgres then you'll need to use a VIP(Virtual IP) in front of your Postgres cluster. Do a manual or automated failover to the standby and change the VIP to point to a standby that is promoted as Master.

Postgres doesn't provide this feature out of the box nor does Apigee. But you can explore other alternative ways to do it.

One of the most used is (DRBD, Pacemaker, and Corosync) combination which provides an automated failover to the standby nodes. You can explore this option or go with some of the Commercial tools which provide HA for Postgres.

Also, check this option using HA Proxy and governor script using etcd.

https://github.com/compose/governor

Hope this helps!

Comment
Add comment Show 4 · Link
10 |5000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by Apigeeks only
  • Viewable by the original poster
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image kkhanna · Jul 14, 2017 at 02:44 PM 0
Link

Thanks @Mohammed Zuber for the reply. Can you tell then what will the config file look like if we have multiple dev portals for HA.

avatar image Mohammed Zuber kkhanna · Jul 14, 2017 at 11:57 PM 0
Link

Hi @kkhanna, If you are going to use a VIP for HA, then the VIP should be configured in developer portal configuration else if you just want to use the Postgres in master/slave configuration and do a manual failover to standby Postgres then you should configure the Master Postgres IP. Please check the documentation here for more details.

avatar image kkhanna kkhanna · Jul 19, 2017 at 08:12 PM 0
Link

@Mohammed Zuber

I don’t WANT to use a master/slave configuration, our goal is for the failover to be automatic. I can configure a VIP infront of the two postgres databases and configure that in the Developer Portal. But then how do i make sure that the two database instances are in sync.

On a side note, i see a lot of documentation on how to use MySQL in master-master configuration with Developer portal but the newer versions of Dev Portal recommend using Postgres, updates to the documentation to reflect this would be very nice. @Anil Sagar

Do you have any updates regarding this for Private Cloud from 17.01 version. @gkoli@apigee.com

avatar image kkhanna kkhanna · Aug 01, 2017 at 07:11 PM 0
Link

Any updates regarding this ?

Thanks! :)

Follow this Question

Answers Answers and Comments

50 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

apigee dev portal installation issue: apigee-lb does not start 1 Answer

apigee postgres installation interface issue 1 Answer

Patching for the postgres server in apigee 0 Answers

Postgres data copy issue 0 Answers

Missing PG_STANDBY, can't proceed with the setup...exiting Error 1 Answer

  • Products
    • Edge - APIs
    • Insights - Big Data
    • Plans
  • Developers
    • Overview
    • Documentation
  • Resources
    • Overview
    • Blog
    • Apigee Institute
    • Academy
    • Documentation
  • Company
    • Overview
    • Press
    • Customers
    • Partners
    • Team
    • Events
    • Careers
    • Contact Us
  • Support
    • Support Overview
    • Documentation
    • Status
    • Edge Support Portal
    • Privacy Policy
    • Terms & Conditions
© 2019 Apigee Corp. All rights reserved. - Apigee Community Terms of Use - Powered by AnswerHub
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Post an idea
  • Spaces
  • Product Announcements
  • General
  • Edge/API Management
  • Developer Portal (Drupal-based)
  • Developer Portal (Integrated)
  • API Design
  • APIM on Istio
  • Extensions
  • Business of APIs
  • Academy/Certification
  • Analytics
  • Events
  • Hybrid
  • Integration (AWS, PCF, Etc.)
  • Microgateway
  • Monetization
  • Private Cloud Deployment
  • Insights
  • IoT Apigee Link
  • BaaS/Usergrid
  • BaaS Transition/Migration
  • Apigee-127
  • New Customers
  • Explore
  • Topics
  • Questions
  • Articles
  • Ideas
  • Members
  • Badges