MySQL is an open source relational database that is customizable and configurable. All of the functionality that Connect CDC requires to support replication is available in MySQL. MySQL provides the following features that are relevant to Connect CDC:
-
Full transactional support to maintain database consistency including commit, rollback and transactional control.
-
The following transaction isolation levels are supported:
-
REPEATABLE READ
-
READ COMMITTED
-
READ UNCOMMITTED
-
SERIALIZABLE
-
Row level locking.
-
Snapshot queries that do not retain locks, comparable to Oracle’s.
-
An advanced JDBC driver that supports the 4.0 standard.
-
A load utility for copying data.