Connect to a MariaDB database
MOSTLY AI can use a MariaDB database as a source for original data and deliver synthetic data to another MariaDB database. You can create separate connectors for the source and delivery of synthetic data.
Prerequisites
Obtain the MariaDB connection details.
- hostname
- port
- credentials
- database name
Steps
- From the Connectors tab, click Create connector.
The Create connector drawer appears on the right.
- On the Connect to database tab, select MariaDB.
- On the Create MariaDB connector page, configure the connector.
-
For Connector name, enter a name that you can distinguish from other connectors.
A combination of
MariaDB
+_DATABASE_
might help you identify this connector among other MariaDB connectors. -
For Connection type, select whether you want to use the connector as a source or destination.
You can select only data source connectors when you create a new catalog.
Similarly, you can select only data destination connectors when you configure a destination for the new synthetic dataset.
-
For Hostname, enter the MariaDB database hostname.
-
For Port, enter the database port.
By default, the port for MariaDB databases is 3306.
-
For Username and Password, enter your MariaDB database credentials.
-
For Database, enter the name of the database.
-
- Click Test connection to make sure the configuration is correct. If you see a successful connection message, then MOSTLY AI connected to your MariaDB database successfully and found the provided database and schema.
- Click Save to save your new MariaDB connector.
What's next
You can now use the MariaDB connector as a data source when you create a new catalog.
You can also use the MariaDB connector as a destination.
You can use different types of data sources and destinations for a synthetic dataset. For example, if your data source is a MariaDB database, you can deliver the generated synthetic to any of the supported databases or cloud storage providers.