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 ?
@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.
Thank you 
Anytime @AlayVakil , Keep us posted if any moving forward. Also, Don’t forget to accept answer if your query is fully resolved.
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.
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.