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-config folder for JAR files.
If you are using a shared external configuration folder, you can copy the JAR to that single folder. For example, you might copy this to G:\PrestoConfig\lib on a Windows system or /mountA/home/PrestoConfig/lib on Linux, Mac OS X or UNIX systems.
If you are not sharing a configuration folder across the cluster, you must copy the JAR to
web-apps-home/presto/WEB-INF/lib for each
MashZone NextGen Server that uses this
MashZone NextGen Repository. See
Setting Up an External
MashZone NextGen
Configuration Folder for more information.
4. Copy the rdsJdbc.properties file to the MashZoneNG-config folder for the entire cluster or to each MashZone NextGen Server in the cluster.
If you are using a shared external
MashZone NextGen configuration folder, both of these files are already in the list of property files that you place in this folder. See
Setting Up an External
MashZone NextGen
Configuration Folder for more information.
6. If the MashZone NextGen Repository is hosted in Microsoft SQL Server, MySQL or Oracle, change the repository JAR in the MashZone NextGen Server.
7. Restart each MashZone NextGen Server in the cluster.