Skip to main content

mkpipe-loader-mariadb

MariaDB loader plugin for MkPipe. Writes Spark DataFrames into MariaDB tables via JDBC.

Documentation

For more detailed documentation, please visit the GitHub repository.

License

This project is licensed under the Apache 2.0 License - see the LICENSE file for details.


Connection Configuration

connections:
  mariadb_target:
    variant: mariadb
    host: localhost
    port: 3306
    database: mydb
    user: myuser
    password: mypassword

Table Configuration

pipelines:
  - name: pg_to_mariadb
    source: pg_source
    destination: mariadb_target
    tables:
      - name: public.orders
        target_name: stg_orders
        replication_method: full
        batchsize: 10000

Write Strategy

Control how data is written to MariaDB:

      - name: public.orders
        target_name: stg_orders
        write_strategy: upsert       # append | replace | upsert | merge
        write_key: [id]              # required for upsert/merge
Strategy MariaDB Behavior
append Plain INSERT via JDBC (default for incremental)
replace Drop and recreate table, then insert (default for full). With if_exists: append: truncate + insert (preserves schema/indexes)
upsert INSERT ... ON DUPLICATE KEY UPDATE via temp table
merge Same as upsert for MariaDB

Write Parallelism & Throughput

      - name: public.orders
        target_name: stg_orders
        replication_method: full
        batchsize: 10000
        write_partitions: 4
  • batchsize: rows per JDBC batch INSERT.
  • write_partitions: reduces concurrent JDBC connections via coalesce(N).

All Table Parameters

Parameter Type Default Description
name string required Source table name
target_name string required MariaDB destination table name
replication_method full / incremental full Replication strategy
batchsize int 10000 Rows per JDBC batch insert
write_partitions int — Coalesce DataFrame to N partitions before writing
write_strategy string — append, replace, upsert, merge
write_key list — Key columns for upsert/merge (required)
if_exists string — replace (drop+create) or append (preserve table, truncate+insert). Inherits from settings
dedup_columns list — Columns used for mkpipe_id hash deduplication
tags list [] Tags for selective pipeline execution
pass_on_error bool false Skip table on error instead of failing

Metadata

Release files for mkpipe-loader-mariadb 0.7.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for mkpipe-loader-mariadb 0.7.0
File Size Uploaded Provenance
mkpipe_loader_mariadb-0.7.0.tar.gz 7.0 kB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for mkpipe-loader-mariadb 0.7.0
File Interpreter ABI Platform
mkpipe_loader_mariadb-0.7.0-py3-none-any.whl Python 3 none any Details

Total release size: 14.6 kB

Release files / mkpipe_loader_mariadb-0.7.0.tar.gz

Download URL mkpipe_loader_mariadb-0.7.0.tar.gz
Size 7.0 kB
Tags Source
SHA-256 checksum
How to use checksums
89ed85eebf18168007011d6c80688f42f3fd132c3a858f118a902b44220c2a5f
BLAKE2b-256 checksum
How to use checksums
84315e43d28369c4b1f0cc5a8d3548e3b144912f3907039ac435e8731f31ba2f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.11.15

Release files / mkpipe_loader_mariadb-0.7.0-py3-none-any.whl

Download URL mkpipe_loader_mariadb-0.7.0-py3-none-any.whl
Size 7.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
2bbbf9cbf8f6047037d646245b8891c65a346d5ecc23c3d3182958299f9a1818
BLAKE2b-256 checksum
How to use checksums
60d9e7c4094523b4be991127957194242453eeeb6b44f7002e16a59cd0e195a5
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.11.15

Security for mkpipe-loader-mariadb 0.7.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page