You can translate the question and the replies:

Metadata repository

Can i have one metadata repository for 2 vdp server . we have Dev environment with 2 vdp servers on it. will i face any performance issue in this case.
#metadata
user
29-10-2021 09:51:04 -0400
code

3 Answers

Hi, Generally, starting from Denodo Platform 8.0, you could **store** the Metadata of Virtual DataPort instances to an External Database and the Virtual DataPort servers in a cluster can **share** the same external database. With this feature, you can increase the number of concurrent requests in the Development environment. Further, storing the metadata on an external database is recommended only in Development and Sandbox environments where changes in elements are not done in a controlled way. For more information, please refer to [Storing the Metadata on an external Database](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/storing_catalog_on_external_database/storing_catalog_on_external_database#storing-the-metadata-on-an-external-database) section under Virtual DataPort Administration Guide. Hope this helps!
Denodo Team
01-11-2021 06:24:38 -0400
code
thanks for the answer. I have extension to that questions. what if i have one derby database which is storing Dev and QA metadata both. Is there an issue when i export and promote the code to next environment.
user
02-11-2021 22:57:53 -0400
Hi, Generally, you could use the same Apache Derby database to store the metadata of both development and testing environment. However, this is not recommended for large data sets or on production environment. You can refer to the [Promotions](https://community.denodo.com/docs/html/browse/latest/en/solution_manager/administration/promotions/promotions) section of the Solution Manager Administration Guide which contains detailed steps listed to maintain the same metadata on different servers. Kindly **note**, in case of the Apache Derby database which is provided by default, you could use an external database for cache and point your servers to the same cache for sharing. Please refer to the [Using Apache Derby as cache](https://community.denodo.com/kb/en/view/document/Using%20Apache%20Derby%20as%20cache?category=Performance+%26+Optimization) Knowledge Base article for more information. Hope this helps!
Denodo Team
03-11-2021 03:36:39 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here