What information lives in the MySQL database related to the developer portal ?

Not applicable

It is clear that Drupal uses that MySQL instance to store its roles , views , etc. However, In context of APIGEE Edge what all data is stored on that MySQL instance ?

Solved Solved
0 8 578
1 ACCEPTED SOLUTION

@AlayVakil , In the context of Apigee Edge following data is stored in MySQL database,

  • User (Developer) information - It's synced between edge & portal. Developer & Developer attributes are stored both in portal & in edge.
  • dc_dev_app_previous_status - Developer App Previous Status - Used to send notifications if developer app is updated in edge.
  • dc_api_product - Caches API Product info. Api products are cached in MySQL
  • smartdocs related metadata cached in MySQL database

Apps information & keys are never stored / cached in MySQL. Always fetched directly from Apigee Edge using Management APIs.

Hope it helps.

View solution in original post

8 REPLIES 8

@AlayVakil , In the context of Apigee Edge following data is stored in MySQL database,

  • User (Developer) information - It's synced between edge & portal. Developer & Developer attributes are stored both in portal & in edge.
  • dc_dev_app_previous_status - Developer App Previous Status - Used to send notifications if developer app is updated in edge.
  • dc_api_product - Caches API Product info. Api products are cached in MySQL
  • smartdocs related metadata cached in MySQL database

Apps information & keys are never stored / cached in MySQL. Always fetched directly from Apigee Edge using Management APIs.

Hope it helps.

Thank you for your quick and clinical answer . Is there a document that delves into the MySQL database in more detail ?

@AlayVakil , Can you please clarify what exactly you mean "Is there a document that delves into the MySQL database in more detail ?" in developer portal context ?

Yeah in the developer portal context. Regarding what are the tables and what they store respectively.

Drupal / Developer portal needs many tables to run. 200 + tables auto installed by various module. If you know Drupal, It's a cake walk to find out table meta information. It's pretty much self-explanatory.

PS: Never ever work directly with MySQL with running SQL queries like update / delete. All the database related actions has to go through custom drupal modules / drupal APIs.

Hope it helps.

Thank you 🙂

Anytime @AlayVakil , Keep us posted if any moving forward. Also, Don't forget to accept answer if your query is fully resolved.

Hello, Is there any way to connect apigee edge with mysql database. I tried it by deploying a node application into apigee that connects to mysql database but that is not working in edge. can anyone suggest me the way to work on it.