MariaDB Connector/J high availability features testing Posted on May 4, 2017, updated on February 21, 2022 by Yannick JaquierTable of contents Preamble MariaDB replication setup MariaDB Connector/J high availability testing Conclusion References Continue reading
Enhanced password strength in MySQL with validate_password plugin Posted on April 12, 2017, updated on March 6, 2019 by Yannick JaquierTable of contents Preamble Validate_password plugin installation Validate_password plugin testing References Continue reading
Automatic extended statistics to improve performance Posted on April 6, 2017, updated on July 9, 2024 by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
OGG-03517 when moving to Unicode from any other character set Posted on March 10, 2017, updated on November 1, 2024 by Yannick JaquierTable of contents Preamble OGG-03517 with character set conversion Oracle Database Migration Assistant for Unicode References Continue reading
Audit creation and deletion of users for SOX evidences Posted on February 17, 2017, updated on February 21, 2022 by Yannick JaquierTable of contents Preamble Oracle Legacy audit Unified audit Audit cleaning SQL Server Audit Audit cleaning MySQL MariaDB audit plugin McAfee audit plugin Percona audit plugin References Oracle SQL Server MySQL Continue reading
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017, updated on July 4, 2024 by Yannick JaquierTable of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Continue reading