Configure MySQL Connection Details

MySQL is an open-source relational database management system (RDBMS) known for its reliability, ease of use, and widespread adoption. It supports structured query language (SQL) and is commonly used for web applications and various data-driven projects.

After you save the connection details for your MySQL RDBMS , you can start using it as a data source in your data pipelines.

The Lazsa Platform offers various options for retrieving database credentials to establish a secure connection. You can either directly provide the credentials within the connection details, where they are securely stored in the Lazsa-managed secret manager. Alternatively, you can choose to retrieve credentials programmatically from your designated secrets management tool.

To configure the connection details of your MySQL RDBMS, do the following:

1. Sign in to the Lazsa Platform and click Configuration in the left navigation pane.
2. On the Platform Setup screen, on the Cloud Platform, Tools & Technologies tile, click Configure.
3. On the Cloud Platform, Tools & Technologies screen, in the Databases and Data Warehouses section, click Configure.
   (After you save your first connection details in this section, you see the Modify button here.)
   

4. In the list of available database and data warehouse options, click .

5. On the RDBMS screen, do the following:

   1. In the Details section, provide the following details:

      Field	Description
      Name	Give a unique name to your MySQL configuration. This name is used to save and identify your specific MySQL connection details within the Lazsa Platform.
      Description	Provide a brief description that helps you identify the purpose or context of this MySQL configuration.

   2. In the Configuration section, provide the following information:

      Field	Description
      Select RDBMS Subtype	Select MySQL from the dropdown list.
      Host	Specify the host or IP address of the server where your MySQL RDBMS is running.
      Port	Enter the port number on which your MySQL is listening for connections.
      Database Name	Provide the name of a specific database within your MySQL RDBMS that you want to connect to.

   3. Depending on how you want to retrieve the credentials to connect to your MySQL RDBMS, do one of the following:

      Field	Description
      Connect using Lazsa Orchestrator Agent	Turn on this toggle to use Lazsa Orchestrator Agent to programmatically resolve your MySQL credentials stored in your secrets management tool within your private network and to establish communication with the MySQL instance. In the Lazsa Orchestrator Agent dropdown list, all your configured agents are displayed. Select the one you want to use to connect to your MySQL instance. The secrets management tool that the selected Orchestrator Agent is authorized to access for retrieving secrets is auto-selected. Currently, we support AWS Secrets Manager and Azure Key Vault. Specify the details of MySQL secrets that the agent should retrieve from the secrets management tool. For AWS Secrets Manager, provide the secret name, username key, and password for your My SQL credentials. For Azure Key Vault, provide the vault name, username secret, and password secret for your MySQL credentials.
      Select Secret Manager	If you don't use the Lazsa Orchestrator Agent, you can directly provide the credentials in the configuration, or retrieve them from a secrets management tool of your choice (such as AWS Secrets Manager or Azure Key Vault). Do one of the following: Select Lazsa and type your MySQL username and password. In this case, the user credentials are securely stored in the Lazsa-managed secrets store.   Select AWS Secrets Manager. In the Secrets Management Tool dropdown list, the AWS Secrets Manager configurations that you save and activate in the Secret Management section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Secret Name, Username Key, and the Password Key for the Lazsa Platform to retrieve the secrets for your MySQL RDBMS. Select Azure Key Vault. In the Secrets Management Tool dropdown list, the Azure Key Vault configurations that you save and activate in the Secret Management section on the Cloud Platform, Tools & Technologies screen are listed for selection. Select the configuration of your choice. Provide the Vault Name, Username Secret, and Password Secret for the Lazsa Platform to retrieve the credential values.

   4. Use SSL
      This toggle allows you to enable or disable a secure connection using SSL (Secure Sockets Layer) for communication between the Lazsa Platform and MySQL. Enabling SSL enhances the security of data transmission by encrypting the communication channel.  To enable SSL, do one of the following:

   Option	Description
   Without using certificate	Clear the Use Certificate check box to use SSL without certificates.
   Use Certificate	To use SSL with certificates, use one of the following options: Use Existing Certificate Choose the storage type where you have stored your SSL certificate. Currently, the following storage options are supported: Databricks File System (DBFS) AWS S3 Upload New Certificate Browse to a location and upload an SSL certificate or drop an SSL certificate for upload. The supported file type is .PEM and the maximum permissible file size is 2 MB.

   5. JDBC String Parameters (Optional)
      JDBC (Java Database Connectivity) is a Java-based API that enables a client to interact with relational databases. You can specify the parameters that you want to pass in the JDBC string. This forms a URL-like string that provides the necessary details for establishing a connection to MySQL from the Lazsa Platform.
      Here is an example of a JDBC string:
   
   

   Based on the inputs that you provide, the Generated JDBC Connection String is displayed. The string consists of: host, port, database name, JDBC string parameters.

   

   

   6. Test Connection
      Click Test Connection to validate whether you have configured the correct connection details and you can connect to MySQL successfully.
   7. Secure configuration details with a password
      To password-protect your MySQL connection details, turn on this toggle, enter a password, and then retype it to confirm. This is optional but recommended. When you share the connection details with multiple users, password protection helps you ensure authorized access to the connection details.
      

   8. Click Save Configuration. The configured connection details, you can see the configuration listed on the Databases and Data Warehouses screen.
      
      

Recommended Topics

What's next? Data Visualization