MashZone NextGen 10.2 | Appendix | Administration | MashZone NextGen Server Administration | Deploying MashZone NextGen Instances, Clusters or Artifacts | Sharing the MashZone NextGen Repository in Clustered Environments | Create and Share a New MashZone NextGen Repository
 
Create and Share a New MashZone NextGen Repository
* To create a new shared repository
1. Create a new MashZone NextGen Repository in the appropriate database for your environment.
Using the SQL tool for the database that will be host, add MashZone NextGen Repository tables with the scripts shown below from the corresponding folder in MashZoneNG-install/prestorepository:
Database
Folder
SQL Scripts
Microsoft SQL Server
mssqldb
*createDBTables.txt for MetaData and the default User Repository
*createSnapsTables.txt for Snapshots
*createSchedulerTables.txt for Scheduler
MySQL
mysqldb
Oracle
oracledb
PostgreSQL
postgresdb
There are also scripts to drop the corresponding MashZone NextGen Repository tables in these folders, if needed.
2. Copy the JAR file for the JDBC driver for your database to the MashZoneNG-install/apache-tomcat/lib folder on all cluster nodes.
3. If this is a new cluster, update configuration information for the MetaData, User and Snapshot repositories for one MashZone NextGen Server in the cluster. See steps 3 onward in Move the MashZone NextGen repository to a robust database solution for instructions.
4. Enable distributed caching for artifacts (required) and optionally distributed caching for mashable/mashup responses. See Configure BigMemory Servers for MashZone NextGen Caching and In-Memory Stores for more information and instructions.
5. If the MashZone NextGen Repository is hosted in Microsoft SQL Server, MySQL or Oracle, change the repository JAR in the MashZone NextGen Server.
6. Restart each MashZone NextGen Server in the cluster.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release