MySQL

MySQL is the world's most widely adopted open-source relational database management system, serving as the backbone for millions of web applications, enterprise systems, and embedded solutions worldwide.

Supported Versions and Architectures

• Versions: 5.x, 8.x, 9.x
• Architectures: Single-node or primary-replica

Supported Data Types

Category	Data Types
String	CHAR, VARCHAR, TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT, BINARY, VARBINARY
Integer	TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT
Numeric	DECIMAL, FLOAT, DOUBLE
Date/Time	DATE, TIME, DATETIME, TIMESTAMP, YEAR
Binary Large Objects	TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB
Spatial Data	POINT, LINESTRING, POLYGON, GEOMETRY, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMCOLLECTION
Other	BIT, ENUM, SET, JSON

Quick Setup Guide

1. Create Database User

MySQL 5.x

CREATE USER 'xpipes'@'%' IDENTIFIED BY 'your_password';

MySQL 8.x and above

CREATE USER 'xpipes'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';

2. Grant Permissions

Full sync only

GRANT SELECT ON your_database.* TO 'xpipes'@'%';

Full + incremental sync

GRANT SELECT ON your_database.* TO 'xpipes'@'%';
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'xpipes'@'%';

3. Enable Binary Logging (for incremental sync)

Add to my.cnf:

server_id = 1
log_bin = mysql-bin
binlog_format = row
binlog_row_image = full

Restart MySQL after configuration changes.