All Products
Search

This Product

    DataWorks:MariaDB

    Document Center

    DataWorks:MariaDB

    Last Updated:Mar 26, 2026

    DataWorks provides MariaDB nodes for developing and scheduling MariaDB SQL tasks as part of a recurring pipeline.

    Note

    MariaDB nodes support only MariaDB data sources created using a Java Database Connectivity (JDBC) connection string.

    Background information

    MariaDB is an open source relational database management system (RDBMS) that is highly compatible with MySQL. MariaDB can seamlessly replace MySQL. You can uninstall MySQL and install MariaDB in its place without changing your application code. For more information, see MariaDB.

    Supported regions

    China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Hong Kong), Singapore, Malaysia (Kuala Lumpur), Germany (Frankfurt), US (Silicon Valley), and US (Virginia).

    Prerequisites

    Before you begin, make sure you have:

    Requirement Required Details
    A Business Flow Required DataStudio organizes development by Business Flows. See Create a workflow.
    A MariaDB data source (JDBC) Required Create a data source using a JDBC connection string. See Data Source Management and MariaDB data sources.
    Network connectivity Required The data source must be able to reach the resource group. See Network connection solutions.
    Workspace role (RAM users only) Optional Add the RAM user to the workspace with the Develop or Workspace Administrator role. Grant the Workspace Administrator role with caution due to its high privileges. See Add members to a workspace.

    Step 1: Create a MariaDB node

    1. Go to the DataStudio page. Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose Data Development and O&M > Data Development. On the page that appears, select the desired workspace from the drop-down list and click Go to Data Development.

    2. Right-click the target Business Flow and choose Create Node > Database > Mariadb.

    3. In the Create Node dialog box, set the Name parameter and click Confirm.

    Step 2: Develop the MariaDB task

    (Optional) Select a data source

    If your workspace has multiple MariaDB data sources, select the appropriate one on the node configuration tab. If only one MariaDB data source exists, it is used by default.

    Write SQL

    Use the code editor to write the SQL to run. The following example queries all rows from a table:

    SELECT * FROM usertablename;

    Use scheduling parameters to pass dynamic values at runtime

    Use scheduling parameters to inject dynamic values—such as dates or environment identifiers—into your SQL at runtime. Define variables in your code using the ${variable_name} format, then assign values in the Scheduling Parameters section on the Schedule tab.

    SELECT '${var}'; -- Use with scheduling parameters.

    For supported formats and configuration details, see Formats of scheduling parameters and Configure and use scheduling parameters.

    Step 3: Configure task scheduling

    Click Scheduling Configuration on the right-side panel and set the scheduling properties. For more information, see Overview.

    Important

    Configure the Rerun Property and Upstream Dependent Node before submitting the task.

    Step 4: Debug the task

    1. (Optional) Select a resource group and assign parameter values for debugging. Click the 高级运行 icon in the toolbar. In the Parameters dialog box, select a resource group and assign values to any scheduling parameters. For details on parameter assignment logic, see Task debugging process.

    2. Save and run the task. Click the 保存 icon to save, then click the 运行 icon to run.

    3. (Optional) Run a smoke test to verify execution in the development environment. For more information, see Perform smoke testing.

    Step 5: Submit and publish the task

    1. Click the 保存 icon to save the node.

    2. Click the 提交 icon to submit the node. In the Submit dialog box, enter a Change Description and select code review options.

      Note

      • Configure the Rerun Property and Upstream Dependent Node before submitting.

      • If code review is enabled, a reviewer must approve the code before it can be published. For more information, see Code review.

    3. In standard mode workspaces, click Publish in the upper-right corner to deploy to production. For more information, see Publish tasks.

    What's next

    After the task is published, it runs on the schedule you configured. Click O&M in the upper-right corner of the node configuration tab to open Operation Center, where you can monitor the scheduling and execution status of recurring tasks. For more information, see Manage recurring tasks.