{ 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
    • Adapter for Envoy
    • 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 /
  • Developer Portal (Drupal-based) /
avatar image
0
Question by Abiram Radhakrishnan · Nov 15, 2019 at 09:00 PM · 479 Views postgresdrupal developer portaldrupal 8mysqldbmariadb

PostgreSQL Vs other DB for Drupal 8

Per our analysis/discussion following are information about POSTgreSQL with respect to Drupal 8 Portal


1.Below link created on 2015 & updated until Aug-2019 lists the issues of PostgreSQL DB that should be fixed in terms of performance, security

https://www.drupal.org/node/2564307


2.In the below link, we see that Drupal 8 listed with Apigee Edge On Premise (or Private Cloud is also same as On premise) does not lists PostgresSQL under “# Install database”


https://www.drupal.org/docs/8/modules/apigee-developer-portal-kickstart/use-kickstart-with-apigee-edge-for-private-cloud#s-install-database


3. Lists MYSQL 5.5.3 as one of recommended DB


https://www.drupal.org/docs/8/system-requirements/database-server

Overall the above link hints about having issues with PostgrSQL with Drupal 8 .

We are trying to evaluate the DB for Drupal 8 (On premise) with Apigee 4.19.06 (On premise)

Would like to know, your experience with PostgreSQL or better to go with MYSQL/MariaDB for Drupal8 Portal

Based on above usage of PostgreSQL is discouraged with Drupal 8, any one had experienced similar judgment or experienced same ? please comment.

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

4 Answers

  • Sort: 
avatar image
0

Answer by Chris Novak · Dec 12, 2019 at 05:50 PM

The reason we put MySQL in the Kickstart is because of the Remaining Drupal 8 PostgreSQL issues issue on Drupal.org. We do have automated tests running for Apigee Edge Drupal module, but you could still run into issues if you use contributed modules that are not yet ready for PostgreSQL.

That said, we would like to spend more time ensuring that you can use PostgreSQL since that database is installed by Edge private cloud installations, and it would be easier to maintain one type of database versus two different kinds.

You would be safer with MySQL, but if you could test out PostgreSQL with your install and make sure it works, with the fallback of migrating to MySQL if you ever run into issues installing a module or configuration that causes issues.

Comment
Add comment Show 1 · 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 umair hanif · Oct 01, 2020 at 12:08 PM 0
Link

hi Chris,

Apigee Kickstart uses MariaDB, either MariaDB runs on active-passive (master, slave strategy)?Is there any proper guide of Apigee kickstart at apigee docs or the proper guide of apigee docs to move PostgreSQL to MariaDB and MYSQL?

avatar image
0

Answer by Chris Novak · Oct 01, 2020 at 10:09 PM

This script should work, or try using the Drupal Migrate module.

Comment
Add comment · 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
0

Answer by Jinesh Thakkar · Feb 05 at 08:00 AM

Hi Chris,

Does Apigee Drupal 8 Dev Portal support AWS managed service for MySQL or MySQL needs to be installed on EC2 instance?

Many Thanks,

Jinesh Thakkar

Comment
Add comment Show 1 · 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 Chris Novak ♦ · Feb 09 at 08:11 AM 0
Link

It looks like AWS RDS uses standard MySQL versions, so you should not run into any issues using it instead of installing yourself: https://aws.amazon.com/rds/mysql/

avatar image
0

Answer by Jinesh Thakkar · Feb 09 at 08:15 AM

Thank you Chris. Appreciate it

Comment
Add comment · 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

Follow this Question

Answers Answers and Comments

78 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 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

Using MySQL with Developer portal on 4.17 0 Answers

How can we encrypt Apigee hybrid connection details in Drupal 8 Devportal? 0 Answers

changing type of installation of developer portal from apache to ngnix , mysql to postgres 1 Answer

Can apigee export custom attributes for app developer in csv file? 1 Answer

Drupal 8|9 - API Doc Settings screen gives error 0 Answers

  • 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
© 2021 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
  • Adapter for Envoy
  • 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
  • Badges