Register an external database
Create the external RDBMS instance and database and then register it with Cloudbreak.
Once you have the database instance running, you can:
- Register it in Cloudbreak web UI or CLI.
- Once registered, the database will now show up in the list of available databases when creating a cluster under advanced External Sources > Configure Databases. You can use it with one or more clusters.
If you are planning to use an external MySQL or Oracle database, you must download the JDBC connector’s JAR file and place it in a location available to the cluster host on which Ambari is installed. The steps below require that you provide the URL to the JDBC connector’s JAR file.
If you are using your own custom image, you may place the JDBC connector’s JAR file directly on the machine as part of the image burning process.
- From the navigation pane, select External Sources > Database Configurations.
- Select Register Database Configuration.
- Provide the following information:
Parameter Description Name Enter the name to use when registering this database to Cloudbreak. This is not the database name. Type Select the service for which you would like to use the external database. If you selected “Other”, you must provide a special blueprint. JDBC Connection Select the database type and enter the JDBC connection string (HOST:PORT/DB_NAME). Connector’s JAR URL (MySQL and Oracle only) Provide a URL to the JDBC connector’s JAR file. The JAR file must be hosted in a location accessible to the cluster host on which Ambari is installed. At cluster creation time, Cloudbreak places the JAR file in the /opts/jdbc-drivers directory. You do not need to provide the “Connector’s JAR URL if you are using a custom image and the JAR file was either manually placed on the VM as part of custom image burning or it was placed there by using a recipe. Username Enter the JDBC connection username. Password Enter the JDBC connection password.
- Click Test Connection to validate and test the RDS connection
information.NoteThe Test Connection* option:In these cases, ignore the error and proceed with cluster installation.
- Does not work when an external authentication source uses LDAPS with a self-signed certificate.
- Might not work if Cloudbreak instance cannot reach the LDAP server instance.
- Once your settings are validated and working, click REGISTER to save the configuration.
- The database will now show up on the list of available databases when creating a
cluster under advanced External Sources > Configure Databases. You can
select it and click Attach each time you would like to use it for a