Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Troubleshooting
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Data outputs
Data transformation
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Amazon S3 connection
Amazon Kinesis connection
Amazon Redshift connection
Amazon Athena connection
Amazon S3 over SQS connection
Google Storage connection
Azure Blob storage connection
Snowflake connection
MySQL connection
Elasticsearch connection
HDFS connection
Qubole connection
PostgreSQL connection
Microsoft SQL Server connection
Spotinst Private VPC connection
Kafka connection
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By
GitBook
MySQL connection
This article provides a guide on creating a MySQL connection in Upsolver.
Create a MySQL connection
1. Enter the
connection string
in the following format:
jdbc:mysql://HOST:PORT/DB_NAME
where:
HOST
= host name (e.g. database instance endpoint in AWS RDS)
PORT
= port number
DB_NAME
= database name
See:
MySQL JDBC connection URL syntax
​
2. Enter your MySQL database
username
.
3. (Optional) Enter the corresponding
password
.
4.
Name
this connection.
5. (Optional) Enter in the number of
concurrent connections
.
If you have
trouble connecting
, it may be a
network and security
issue
. To fix this in AWS RDS, you can:
1.
make your instance
publicly accessible
under the
Properties
tab
2.
reconfigure the
inbound rules
for your instance's VPC security group (allow all traffic from all sources)
For a more secure option, you can also choose to implement
VPC peering
.
Previous
Snowflake connection
Next
Elasticsearch connection
Last modified
1yr ago
Copy link