How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
Galera Arbitrator as an odd node in Galera cluster Posted on February 14, 2023 , Modified on November 9, 2023 , by Yannick JaquierTable of contents Preamble Galera Arbitrator installation Galera Cluster configuration Galera Arbitrator configuration Galera Cluster testing References Read more MariaDB Galera, High Availability 1 comment
Data in transit encryption with MariaDB 10.6 (WolfSSL) Posted on January 24, 2023 , Modified on February 1, 2023 , by Yannick JaquierTable of contents Preamble Data in transit encryption certificates generation Root Certificate Authority Server v3 certificate generation Client v3 certificate generation Data in transit encryption MariaDB configuration and testing One-way TLS for client Two-way TLS for client References Read more MariaDB Security Leave a comment
MariaDB PAM LDAP authentication with newest SSSD daemon Posted on February 28, 2022 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble MariaDB PAM LDAP Linux and database configuration Ldapsearch configuration MariaDB PAM LDAP authentication with legacy nslcd configuration MariaDB PAM LDAP authentication with System Security Services Daemon (SSSD) References Read more MariaDB Administration, Security Leave a comment
MariaDB ColumnStore installation and testing – part 2 Posted on January 24, 2021 , Modified on August 25, 2025 , by Yannick JaquierTable of contents Preamble MariaDB Community Server installation and configuration MariaDB ColumnStore installation and configuration References Read more MariaDB Administration, Tuning 1 comment
MariaDB ColumnStore installation and testing – part 1 Posted on December 23, 2020 , Modified on August 31, 2026 , by Yannick JaquierTable of contents Preamble MariaDB ColumnStore container installation and configuration with Podman MariaDB ColumnStore default schema configuration Power BI Desktop configuration Is MariaDB ColumnStore worth the effort ? References Read more MariaDB Administration, Tuning 1 comment