MariaDB flashback by example Posted on February 28, 2026 , Modified on February 12, 2026 , by Yannick JaquierTable of contents Preamble Flashback test case Flashback testing References Read more MariaDB Administration, Flashback Leave a comment
Debezium to stream data from Oracle to MariaDB Posted on February 20, 2026 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Apache Kafka installation Apache Kafka Connect configuration Debezium Connector for Oracle configuration Debezium connector for JDBC configuration UI for Apache Kafka Issues encountered Failed to process record: Failed to resolve column type for schema: STRUCT io.debezium.DebeziumException: The db history topic is missing. You may attempt to recover it by reconfiguring the connector to recovery. References Read more Databricks, Linux, MariaDB, Oracle Kafka 1 comment
GoldenGate 23ai configuration for Oracle to MariaDB replication Posted on January 30, 2026 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Oracle GoldenGate 23ai for a MySQL database installation MariaDB target database preparation GoldenGate 23ai for MySQL compatible database configuration GoldenGate 23ai replicat process for MySQL deployment Initial loading Issues encountered OGG-05125 The specified GGSCHEMA name 'ggadmin' in the GLOBALS file does not exist in the database or the user does not have permission to use it OGG-00768 Oracle GoldenGate Delivery for MySQL References Read more MariaDB GoldenGate Leave a comment
How to protect your database code from SQL injections Posted on December 30, 2025 , Modified on January 5, 2026 , by Yannick JaquierTable of contents Preamble Data model MariaDB SQL injections No SQL injections If the parameter is for a varchar column Isn't it better to work dirty ? Oracle SQL injections No SQL injections If the parameter is for a varchar2 column Read more MariaDB, Oracle Development, Security 1 comment
Transparent Data Encryption (TDE) with MariaDB Posted on June 10, 2025 , Modified on June 11, 2025 , by Yannick JaquierTable of contents Preamble MariaDB without Transparent Data Encryption MariaDB with Transparent Data Encryption with File Key Management plugin Encrypt File Key Management plugin key file References Read more MariaDB Security, Transparent Data Encryption (TDE) Leave a comment
SYS schema hands-on Posted on December 10, 2024 , Modified on December 10, 2024 , by Yannick JaquierTable of contents Preamble SYS schema configuration Instances global waits SYS schema schema view SYS schema side procedures sys.diagnostics() sys.statement_performance_analyzer() sys.format_time() and sys.format_bytes() References Read more MariaDB, MySQL Administration, Tuning Leave a comment