Learn Gluesync
Step-by-step guides for the tasks Gluesync users ask about most. Each guide was run end to end on a real Gluesync, and its screenshots come from that run. Pick a topic, or use the search at the top of the page.
Install and upgrade
Put Gluesync on a server, keep it current, and move it between environments.
-
Install Gluesync on Linux and size the host
Check a Linux server, open the right ports, install Gluesync online or offline with Gluesync Control, sign in to the Control Plane and size the host. -
Install and run Gluesync on Windows Server
Choose the right Windows installer, add antivirus exclusions, install Gluesync, sign in, start and stop it, update offline, and collect a support bundle. -
Upgrade Gluesync safely
Back up, upgrade Gluesync from the Control Plane, Gluesync Control or an offline package, check that pipelines resume, and roll back if needed. -
Back up, restore and move Core Hub
What to back up on a Gluesync Linux server, how to schedule it, restore after a loss or from a VM backup, and move to a new host without losing changes. -
Promote pipelines from QA to production
Export a pipeline from a QA Core Hub, remap hosts, passwords and schemas, import it into production, start it, clone entities and fix the common import errors.
Build pipelines
Start, filter and key your replication, and change it safely while it runs.
-
Start a snapshot and CDC replication from the Control Plane
Start an entity with an initial snapshot then CDC, CDC only, or a one-time snapshot, pause and resume it, and prove each result with SQL on the target. -
Filter rows with a snapshot WHERE clause and target filters
Replicate only the rows you need: set a snapshot WHERE clause and target filters, use every operator including in, and see what each does to live changes. -
Choose keys for tables without a primary key
Pick a logical key, or on IBM i the RRN or the DDS keys, for a table with no primary key, and see what duplicate or NULL key values do on the target. -
Choose a key strategy for your tables: physical, logical, RRN or computed
Choose a physical, logical, RRN, ROWID or computed key, build the matching unique index on SQL Server, and stop duplicate rows on the target. -
Write and test a UDF to convert dates, times, and names
Write a UDF that parses dates in several formats, formats a TIME as text, and splits one field into two columns, then test it and verify the target. -
Handle schema changes on a live replication
Change columns, types, keys and tables of a replicated database without losing data: what to do on the source, the target and the Control Plane, in what order. -
Set up bidirectional replication with recursion protection
Keep two PostgreSQL databases or two IBM i systems in sync both ways, enable recursion protection, prove nothing bounces back, and handle conflicts and pauses. -
Move a DBMoto or Syniti Replicate setup to Gluesync
Convert a DBMoto or Syniti Replicate metadata XML into Gluesync entities, learn what carries over and what you must finish by hand.
Connectors
Prepare a source or target database and fix the errors that are specific to it.
-
Set up Oracle LogMiner CDC end to end
Prepare Oracle for LogMiner, create least-privilege users, build a pipeline to PostgreSQL, and recover from missing grants, lost redo logs and restarts. -
Set up MySQL and MariaDB CDC and fix binlog errors
Prepare MySQL or MariaDB binlogs, create a least-privilege user, replicate to PostgreSQL and fix missing grants, purged binlogs and zero dates. -
Troubleshoot IBM i journals and receivers
Fix IBM i CDC problems: table not journaled, receiver deleted before it was read, restart position, receiver number wrap, dedicated reader and work library. -
Map IBM i data types to PostgreSQL without losing text, digits or dates
Check how IBM i text, CCSID 65535, binary, decimal and timestamp columns reach PostgreSQL, fix hex text and truncation, and verify the result with SQL. -
Prepare a SQL Server target so snapshots and CDC run without truncation or type errors
Grant SQL Server permissions, create or check target tables, map types, and fix truncation, reserved-word, type-pair and collation errors. -
Replicate a database to a data lake on S3 or Azure Data Lake Storage
Replicate a PostgreSQL table to an S3 bucket as Parquet files, read the inserts, updates and deletes, and query the latest state with DuckDB.
Monitor and troubleshoot
See what your pipelines are doing, get alerted, and recover when something stops.
-
Diagnose and recover a stalled pipeline or entity
Find out why a pipeline or entity stopped replicating, tell a real stall from a stale error, and recover with pause and resume, Full copy or maintenance mode. -
Find and fix row differences between source and target
Count rows on both sides, compare an entity with Validator, find why rows differ, and fix them with Reconcile or a one-table resync. -
Read Gluesync logs and diagnose errors
Find every Gluesync log, read a log line, filter by pipeline, entity and agent, fix the time zone and the log level, and look up common errors. -
Tune snapshot and CDC throughput safely, one setting at a time
Measure a baseline, find the limiting side, then change one snapshot, CDC, connection or memory setting at a time and keep or revert it by its measured effect. -
Free disk space and manage cache and logs
Find what fills the Gluesync disk, cap logs and the source cache, recover from a full disk in the right order, and keep updates from failing. -
Monitor pipelines in Grafana with the Core Hub metrics dashboard
Open Metrics & Insights, find the Core Hub metrics dashboard, filter it by pipeline and entity, and read throughput, latency, connection and JVM panels. -
Set up email alerts for platform events
Configure the Core Hub SMTP client, choose which platform events trigger alerts, send a test email, and confirm a real alert reaches your mailbox. -
Send platform events to webhooks
Send Gluesync platform events to an HTTP endpoint: create a webhook, filter events, test it, read the payloads, and recover failed deliveries.
Automate and query
Drive Gluesync from schedules, scripts and AI agents, and query the replicated data.
-
Automate pipeline actions with schedules, chained events, and webhooks
Schedule snapshots with cron, chain actions in order, start jobs with an inbound webhook, and send Gluesync events to an outbound webhook. -
Automate Gluesync with the REST API, MCP, and webhooks
Call the Core Hub REST API with a Personal API Token, route platform webhooks through n8n, and connect an MCP client, even behind a custom hostname. -
Query pipeline data with Query Studio and control who can access it
Run SQL on a pipeline’s source or target in Query Studio, export and edit results, then limit which tables each user can query and see unmasked.
Security and access
Control who signs in and what they can do, encrypt traffic, and answer security reviews.
-
Manage users, groups, and roles in Gluesync
Create Gluesync users, assign Viewer, Monitor, Manager, or Super Admin roles, group users for query data access, and test what each role can do. -
Configure single sign-on with OIDC and map identity provider groups to Gluesync roles
Register Gluesync in your identity provider, map IdP groups to Viewer, Monitor, or Manager, block groups, test sign-in and logout, and keep a local admin. -
Enable HTTPS with your own certificate and TLS to your databases
Put a certificate from your own CA on the Gluesync Control Plane, find out why the old one stays, and secure MySQL, IBM i and old databases with TLS. -
Answer a security review of your Gluesync deployment
Scan the Gluesync images with Trivy or Grype, read the findings, ask MOLO17 about a CVE, answer pen-test findings and harden the kit before a security review.
Get help
Reach MOLO17 support and watch the video tutorials.
-
How to create a support ticket
Step-by-step guide on how to create a support ticket on MOLO17’s Gluesync support portal. -
Video tutorials
Access our comprehensive video tutorial playlist on YouTube to learn Gluesync through step-by-step visual guides.