MySQL's utf8 character set only supports up to three bytes per character, causing errors when storing emoji or complex characters that require four bytes; the article explains the historical reason for this limitation and demonstrates that utf8mb4 is the true UTF-8 implementation introduced in 2010.
The author benchmarks MariaDB 10.3, MySQL 8.0, and PostgreSQL 12 using a real Turkish motorcycle classifieds app with many simple queries, finding MariaDB 5% faster on average and 7% faster at p95 with lower CPU usage, though MySQL handles tail latency better and memory differences stem from default performance_schema settings.
An AI‑driven security tool discovered high‑severity, remote‑code‑execution flaws in PostgreSQL's pgcrypto extension and MariaDB's JSON schema validation, both dating back over two decades, prompting immediate patch releases and offering mitigation steps for unpatched deployments.
The article analyzes MySQL's dwindling open‑source credibility, mounting security vulnerabilities, performance regressions, and Oracle's commercial lock‑in, contrasting it with MariaDB's transparent development and the growing migration of applications to MariaDB or PostgreSQL for better security and performance.
The WNMP one‑click package installs Nginx, PHP, and MariaDB with built‑in Mroonga, automatically optimizes kernel and network settings, configures WebDAV and SSL certificates, and provides a lightweight, reproducible web environment for small‑to‑medium sites on Debian‑based Linux or Windows 11 WSL.
With MySQL 8.0 support ending on April 30, 2026, users must migrate within six months to avoid security risks, and can choose upgrading to the latest MySQL, switching to Percona Server, or moving to alternatives like MariaDB or PostgreSQL, each with its own pros and cons.
MySQL 8.0 will lose Oracle support on April 30, 2026, ending security patches, bug fixes, and official assistance, so organizations must choose between upgrading to a newer MySQL version, switching to Percona Server, or migrating to alternative databases like MariaDB or PostgreSQL.
Oracle’s massive September 2025 layoffs hit the MySQL core team, prompting concerns about reduced innovation, a shift toward its Heatwave analytics product, and the broader impact on open‑source database ecosystems and developer choices.
This guide walks you through installing MariaDB from binary packages on various Linux distributions, covering user and group creation, downloading and extracting the tarball, configuring environment variables and my.cnf, initializing the database, securing the installation, testing the server, and using a ready-made shell script for automated deployment.
This comprehensive tutorial introduces MariaDB, explains its origins and key features, and provides detailed, cross‑platform installation and configuration instructions for Rocky Linux, Ubuntu, openSUSE and other distributions, including network setup, repository configuration, package installation, service management, and security hardening.
Oracle's recent large‑scale layoffs in its MySQL division have sparked community worries about the future of the world’s most popular open‑source database, highlighting shifts toward AI‑focused services and the rise of MariaDB as an alternative.
This guide walks you through verifying, installing, configuring, and activating the MariaDB server_audit plugin, including required ConfigMap edits, optional SQL commands, and a Kubernetes rollout to ensure comprehensive audit logging of connections, queries, and table events.
This guide walks through verifying the MariaDB server_audit plugin, installing it via configuration files or SQL, setting audit event variables, enabling logging, and restarting the MySQL service in a Kubernetes environment to achieve comprehensive query and connection auditing.
This guide explains the MariaDB MaxScale NoSQL protocol module, its key features, typical use cases, step‑by‑step installation, configuration, and how to perform MongoDB‑compatible operations that are transparently stored in MySQL/MariaDB.
The article traces MariaDB’s evolution from its MySQL roots and community‑driven development, through its NYSE listing, financial performance, restructuring, and the recent K1 Investment Management acquisition, while highlighting key figures, product features, and industry reactions.
The article compares MySQL and MariaDB, tracing MySQL’s historic rise, explaining why MariaDB was forked, detailing their governance, enumerating MariaDB’s additional storage engines and performance optimizations, highlighting new features, and analyzing recent adoption trends that suggest MariaDB may eventually overtake MySQL.
Discover why MySQL’s legacy ‘utf8’ charset only supports three‑byte characters, causing storage errors for true UTF‑8 data, and learn how the ‘utf8mb4’ charset resolves these issues, with historical context, technical details, and migration guidance.
The article traces MySQL’s origins from Monty Widenius’s early Unireg project through its rapid growth, acquisition by Sun and Oracle, and the emergence of MariaDB, highlighting how an open‑source, user‑focused ecosystem and the LAMP stack propelled MySQL to become the world’s most popular database.
Learn how to install MariaDB on Windows, test local connections with Navicat, set up cpolar to create a TCP tunnel, obtain a public address, and configure a fixed TCP port for stable remote access to your MariaDB database from anywhere.
This guide explains MariaDB ColumnStore’s columnar architecture, key advantages, step‑by‑step installation, field and SQL limitations, how to migrate InnoDB data, configure multi‑source replication, compare performance with InnoDB, and achieve high availability and dynamic scaling for analytical workloads.
Running ANALYZE TABLE on MySQL, Percona Server, or MariaDB can block queries in older versions, but from MySQL 8.0.24, Percona Server 5.6.38+, 5.7.20+, and MariaDB 10.5.4+, the operation is safe and no longer causes disruptive locks.
This article presents five expansion strategies—shutdown, write‑stop, log‑based, dual‑write, and smooth 2N—detailing step‑by‑step procedures for MariaDB installation, master‑master replication, dynamic data‑source configuration, and Keepalived high‑availability setup, enabling seamless horizontal scaling and minimal service disruption for large‑scale databases.
MariaDB announced the discontinuation of its SkySQL DBaaS and Xpand distributed backend, a 28% staff reduction, and a $26.5 million loan to stabilize finances, prompting analyst criticism and raising questions about the future of its cloud database strategy.
This guide walks you through installing phpIPAM—a web‑based IP address management tool—by preparing the server environment, configuring Apache and MariaDB, downloading the source code, setting permissions, and completing the web‑based setup, all with detailed commands and screenshots.
The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors with genuine four‑byte UTF‑8 symbols, and advises all MySQL/MariaDB users to migrate to the proper “utf8mb4” charset using available conversion guides.
This article examines the current state and historical background of MySQL and MariaDB service lifecycles and version‑management strategies, comparing their community‑edition release models, long‑term‑support policies, innovation releases, and upgrade paths.
The article introduces sql_helper, an open-source command-line and web tool for MySQL 5.7/8.0 and MariaDB that automatically analyzes SQL statements to suggest index creation, explains its six-step workflow, provides usage examples, command-line parameters, and notes its assumptions and limitations.
This article analyzes why the MariaDB audit plugin crashes on MySQL 5.7, presents compatibility tables before and after source modification, details the verification steps, and provides a step‑by‑step solution including source code changes and recompilation to make the plugin work reliably.
This article explains how MariaDB evolved from a MySQL branch into a comprehensive database ecosystem, covering the Community and Enterprise servers, diverse storage engines, MaxScale proxy, ColumnStore analytics, Xpand distributed scaling, and the SkySQL fully managed cloud service.
This guide explains how to use the open‑source binlog_parse_sql tool to parse MySQL 8.0 binary logs, generate SQL statements, and seamlessly migrate data to MariaDB or ClickHouse, covering installation, execution modes, troubleshooting, and practical ETL scenarios.
This article introduces Sequel Pro, a macOS GUI client for MySQL and MariaDB, explains how to configure standard connections with required fields, describes the main interface features such as database selection, table structure and content viewing, and highlights additional tools like Query and Table Info.
MariaDB, the MySQL fork founded by Michael Widenius, has seen its NYSE‑listed shares tumble from $14.45 to around $1.30, faced a $104 million Series D round, now lacks cash for twelve months, cut 8% staff, and holds just 2.15% of the relational‑database market.
This technical guide explains how to scale a sharded database horizontally by introducing five expansion schemes—including shutdown, write‑stop, log‑based, dual‑write, and smooth 2N approaches—covers MariaDB installation, master‑master replication setup, dynamic data‑source configuration with ShardingJDBC, and detailed Keepalived high‑availability configuration for seamless service continuity.
This article explains how to expand a sharded database from three to four nodes, compares five migration schemes—including stop‑service, stop‑write, log‑based, dual‑write, and smooth 2N approaches—and provides step‑by‑step instructions for MariaDB installation, master‑slave configuration, Keepalived high‑availability setup, and dynamic data‑source integration using ShardingJDBC.
MariaDB, the open‑source cloud database company founded by MySQL’s original creator, completed a SPAC merger to list on the NYSE, highlighting its $227.2 million pre‑IPO funding, ambitious cloud strategy, and the growing relevance of smaller‑scale database solutions against cloud giants.
MariaDB secured $104 million in Series D funding, merged with SPAC Angel Pond Holdings to list on the NYSE as MRDB, and is now leveraging its Enterprise and SkySQL products while navigating valuation challenges and emphasizing a customer‑centric, open‑source database strategy.
This article presents a detailed analysis and step‑by‑step implementation of horizontal database scaling, including sharding strategies, shutdown and stop‑write plans, log‑based migration, dual‑write approaches, and a smooth 2N expansion method, while also covering MariaDB master‑master configuration, dynamic data source addition, and Keepalived high‑availability setup.
This guide explains how to scale a sharded database horizontally by adding new nodes, handling data migration with stop‑service, stop‑write, log‑based, dual‑write, and smooth 2N strategies, and implementing high‑availability using MariaDB double‑master replication and Keepalived, complete with configuration examples and code snippets.
This article introduces four essential open‑source technologies—Elastic, MariaDB, RabbitMQ, and Redis—explaining their core features, typical use cases such as search, relational data, messaging, and caching, and why they are popular choices for building scalable backend systems.
In an exclusive interview, MariaDB founder Michael "Monty" Widenius discusses the rapid growth of China’s database industry, the rise of open‑source adoption, competition with cloud providers, and strategic plans for expanding MariaDB’s presence in the Chinese market.
This guide explains how to deploy and configure MariaDB MaxScale as a database proxy to achieve MySQL read/write splitting, covering topology design, user creation, installation steps, configuration files, service setup, and verification of routing behavior.
This guide walks you through using Docker‑Compose to orchestrate a React front‑end, an Express back‑end, and a MariaDB database, covering environment setup, Dockerfile creation, Nginx configuration, container building, and common pitfalls for seamless full‑stack deployment.
This guide walks through using Docker Compose to package and launch a complete full‑stack application—including a React front‑end, an Express back‑end, and a MariaDB database—with a single command, covering prerequisites, Dockerfiles, Nginx configuration, and runtime management.
MariaDB 10.10.1 RC and 10.9.2 GA have been released, delivering a short‑term support series with numerous bug fixes and improvements for InnoDB, replication, Galera clustering, the optimizer and other core components, enhancing stability and performance for database users.
This guide explains how to set up a lightweight database audit log platform using MariaDB's audit plugin, Rsyslog, and the LogAnalyzer web interface, covering environment preparation, plugin installation, syslog forwarding, MySQL schema creation, and LogAnalyzer configuration for real‑time monitoring and compliance reporting.
This article explains three practical methods for adding audit capabilities to MySQL 5.7—using the init_connect parameter to log user connections, installing the MariaDB server_audit plugin for detailed event logging, and deploying the McAfee audit plugin—while providing step‑by‑step commands, configuration examples, code snippets, and a comparison of advantages and drawbacks.
This article provides a comprehensive, step‑by‑step tutorial for installing and configuring the phpIPAM IP address management web application on a Linux server, covering environment preparation, disabling SELinux, installing dependencies, setting up Apache and MariaDB, cloning the source, adjusting permissions, and completing the web‑based setup.
This article introduces Sequel Pro, a lightweight macOS client for MySQL and MariaDB, explains how to configure standard connections, describes its main interface modules such as database selection, table structure, query editor, and provides visual guidance for common operations.
This article presents a detailed benchmark comparing MySQL 8.0.19 and MariaDB 10.4.12 on a Windows 10 i7 machine, covering single‑row and batch inserts, various SELECT queries with and without indexes, and analyzes the trade‑off between speed and memory usage.
A former Oracle MySQL optimizer lead publicly denounces MySQL as a poorly designed database, praises PostgreSQL's strengths, critiques MariaDB, and highlights real‑world migration experiences, offering a balanced view of the ongoing open‑source relational database debate.
This guide walks you through installing JumpServer—a bastion host solution that adds permission control, session monitoring, and audit logging to remote server access—by setting up MariaDB and Redis, configuring Docker, generating secret keys, running the JumpServer container, and configuring users, groups, assets, and permissions.
This tutorial walks through installing MariaDB and Redis on a backend node, configuring Docker on a separate host, pulling and running the JumpServer container, and then setting up users, assets, and permissions so that operations teams can securely manage internal servers via a bastion host.
A former Oracle MySQL lead engineer explains why, after five years of work, he finds PostgreSQL a superior open‑source RDBMS, criticizing MySQL’s design flaws, comparing MariaDB, and highlighting real‑world migration experiences and industry perspectives.
A former Oracle MySQL lead engineer denounces MySQL as a poor open‑source database, praises PostgreSQL, critiques MariaDB, and discusses the historical evolution and corporate politics behind these relational database systems.
The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors when storing true four‑byte UTF‑8 symbols, and shows how the newer “utf8mb4” charset provides full Unicode support, with historical context and migration guidance.
This article presents a detailed performance benchmark comparing MariaDB 10.4.12 and MySQL 8.0.19 on an i7 Windows 10 system, covering single and batch inserts, indexed and non-indexed queries, and analyzes speed and memory usage differences between the two databases.
This comprehensive tutorial walks you through installing Zabbix on CentOS 7, covering system overview, key terminology, disabling SELinux and firewalls, setting up repositories, installing server, agent, frontend, MariaDB, configuring the database, and finalizing the web interface with screenshots.
This article details the practical challenges encountered when migrating a MariaDB 10.3 database to MySQL 5.7.25, explains why certain defaults and engine-specific options cause import errors, and provides step‑by‑step fixes such as adjusting default expressions, removing Aria‑specific parameters, and configuring sql_mode.
This article reviews the history of MySQL and MariaDB, describes a test environment, runs insertion, batch, and query benchmarks (with and without indexes), and concludes that MariaDB generally outperforms MySQL in speed and memory usage while highlighting trade‑offs of indexing.
This article presents a detailed performance benchmark of MariaDB and MySQL, covering single‑row and batch inserts, as well as various query scenarios with and without indexes, and concludes that MariaDB generally outperforms MySQL while using more memory.
This article reviews the history of MySQL, introduces MariaDB as its open‑source fork, and presents a series of benchmark tests—including single‑row inserts, batch inserts, and various query scenarios—showing that MariaDB generally outperforms MySQL in speed while using more memory.
This article explains how enterprises can evaluate their needs and compare four popular open‑source relational databases—MySQL, PostgreSQL, MariaDB, and SQLite—covering licensing, performance, language support, strengths, and limitations to guide an informed selection.
This guide walks you through installing JumpServer—a secure bastion host—on CentOS, covering architecture overview, MariaDB and Redis setup, Docker configuration, container deployment, key generation, UI access, and essential administration tasks such as user, asset, and permission management.
This article traces MySQL’s evolution, introduces MariaDB’s origins, and presents a comprehensive benchmark comparing insert and query performance of MySQL 8.0.19 and MariaDB 10.4.12 on identical hardware, highlighting speed differences with and without indexes.
This article traces MySQL’s evolution, introduces its fork MariaDB, and presents a comprehensive performance benchmark—covering single and batch inserts, indexed and non‑indexed queries—on identical hardware, revealing that MariaDB generally delivers faster execution times albeit with higher memory usage.
This guide walks through installing MariaDB, creating a Gogs database and user, setting up Git, extracting and launching Gogs, and configuring the application—including disabling registration—to complete a simple self‑hosted Git server on Linux.
When selecting an open‑source database, enterprises must assess their specific data needs, understand licensing differences, and weigh the strengths and weaknesses of popular options such as MySQL, PostgreSQL, MariaDB, and SQLite, as this guide details.
The latest DB‑Engines popularity ranking reveals Oracle, MySQL and SQL Server still dominate the top three, while PostgreSQL, MariaDB, Azure SQL Database and Snowflake surge ahead, highlighting a stable yet evolving landscape where cloud‑native databases are gaining rapid momentum.
This tutorial walks you through installing JumpServer—a bastion host for centralized server management—by setting up MariaDB and Redis on separate nodes, configuring Docker, pulling the JumpServer image, generating required secret keys, and finally configuring users, groups, assets and session replay through the web UI.
This article explains how to use MariaDB's Query Profiling, Slow Query Log, and Performance Schema together with the Monyog monitoring tool to diagnose, visualize, and optimize database performance, covering configuration, log analysis, schema queries, and dashboard reporting.
This article traces MySQL's four‑decade history, its acquisition by Sun and Oracle, the rise of MariaDB as a compatible fork, and provides a practical guide to installing and using MariaDB with screenshots and tool recommendations.
This guide walks you through installing the MariaDB Python connector, establishing a secure connection, executing SELECT and INSERT statements, handling transactions and errors, and properly closing the connection, providing a complete workflow for Python developers working with MariaDB databases.
This guide explains how to obtain the MariaDB audit plugin, migrate it to a MySQL 5.7 environment, install and load the plugin, configure audit parameters, and manage audit log files and formats for effective database activity monitoring.
This guide explains how to replace the traditional MHA/Keepalived high‑availability setup with MariaDB MaxScale integrated with Consul, providing a simpler, fully automated HA solution, complete with configuration files, installation commands, and detailed failover, switchover, and rejoin procedures.
This step‑by‑step guide shows how to set up a Discuz! forum on a Huawei Cloud CentOS 7.6 server, covering cloud login, security group configuration, installation of Apache, PHP, MariaDB, downloading and deploying Discuz! source, and final web‑based installation.
The article explains that MySQL’s legacy "utf8" charset only supports three‑byte sequences, causing errors with true four‑byte Unicode characters, and shows how the later "utf8mb4" charset provides proper UTF‑8 support along with historical context and migration guidance.
The article explains that MySQL’s legacy “utf8” character set only supports three‑byte sequences and therefore cannot store true UTF‑8 characters, describes the historical reasons behind this limitation, and advises all MySQL/MariaDB users to migrate to the proper utf8mb4 charset.
This guide walks through preparing the environment, configuring the master and slave MySQL servers, and using Python's Paramiko library to automate SSH commands, edit configuration files, restart services, and verify replication, all while handling common pitfalls.
The article explains why MySQL’s legacy “utf8” character set only supports three‑byte sequences, causing errors with genuine four‑byte UTF‑8 characters, and shows how the proper “utf8mb4” charset resolves the issue, including historical background, practical examples, and migration guidance.
This article surveys MySQL audit capabilities, explains the limitations of general and binary logs, introduces several open‑source audit plugins with installation and configuration details, and compares MariaDB, Percona, and McAfee audit plugins in terms of granularity, log format, and performance impact.
This guide demonstrates how to write parameterized Ansible playbooks for MariaDB installation and configure Jenkins pipelines to execute those playbooks, securely passing credentials and extra variables to achieve fully automated, repeatable database deployments.
This guide walks through manually installing Apache, MariaDB, PHP, and the Discuz X2 forum on a Linux system, covering prerequisite checks, mounting installation media, configuring yum repositories, installing and starting services, securing MariaDB, deploying Discuz files, setting permissions, creating the database, and completing the setup wizard.
A production database migration from MariaDB 10.4 to MySQL 5.7 caused a previously fast SQL query to become extremely slow due to differing column collations that prevented index usage, and the article explains how to diagnose the issue and resolve it by aligning collations or using explicit conversion.
This tutorial explains how to install MariaDB's Spider storage engine, create single-table remote links, configure users and servers, and leverage Spider for sharding and multi‑server table aggregation, providing practical code examples and performance considerations for distributed database setups.
This guide walks you through installing and configuring Nextcloud on CentOS 7, covering dependencies, Apache, MariaDB, PHP, Nextcloud deployment, virtual‑host setup, and final login verification, enabling a fully functional private cloud storage service.
This article reviews six of the most popular open‑source database solutions, detailing their features, pros and cons, pricing models, mobile support, and typical user demographics to help readers make informed technology‑selection decisions.
The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors when storing true four‑byte UTF‑8 data, and shows how switching to the proper “utf8mb4” charset resolves the issue.
This article compares key new features of MySQL 8.0 and MariaDB 10.4—including authentication plugin changes, Unix‑socket auth, atomic DDL, instant column adds, clone plugin usage, optimizer enhancements, resource groups, query‑rewrite, and backup tools—providing step‑by‑step commands, code snippets, and practical caveats for database upgrades.
This guide explains how to create automated backup plans for MySQL and MariaDB databases on Jelastic PaaS, covering script configuration, cron scheduling, remote storage options, and restoring backups through phpMyAdmin, ensuring data safety and easy recovery.
The article explains why MySQL's legacy "utf8" charset only supports three‑byte characters, causing storage errors for true four‑byte UTF‑8 symbols, and advises developers to migrate all MySQL/MariaDB databases to the proper "utf8mb4" charset.
The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors when storing true four‑byte UTF‑8 symbols like emojis, and shows why switching to the proper “utf8mb4” charset is essential for correct Unicode handling.
This tutorial walks you through preparing a CentOS 7.4 system, installing MariaDB, setting up Zabbix 3.4.6 with MySQL support, configuring the database and web frontend, and finally starting all services to achieve a fully functional monitoring platform.
Discover why MySQL’s legacy ‘utf8’ charset only supports three‑byte characters, causing storage errors for true UTF‑8 data, and learn how switching to the proper ‘utf8mb4’ charset resolves these issues, with a brief history and practical migration guidance.
This article explains why MySQL’s legacy "utf8" charset only supports three‑byte characters, why it’s not true UTF‑8, and provides a clear guide to migrating databases to the proper "utf8mb4" charset for full Unicode support.
This article examines why modern businesses rely on databases, explains the concept and advantages of open‑source software, and provides a detailed comparison of three popular open‑source databases—PostgreSQL, MariaDB, and Percona—highlighting their strengths, weaknesses, and ideal use cases.
This tutorial walks you through preparing a CentOS 7.4 system, installing MariaDB, setting up Zabbix 3.4.6 (including repository configuration, package installation, database creation, and web front‑end), adjusting PHP settings, and finally starting and enabling all services for a fully functional monitoring platform.
This tutorial walks you through preparing a CentOS 7 system, installing MariaDB, setting up Zabbix 3.4.6 with all required packages, configuring the database and web front‑end, and finally launching the monitoring service, complete with code snippets and screenshots.
Former MariaDB CTO Ivan Zoratti shares his 35‑year tech career, the evolution from MySQL to MariaDB, why he transitioned to Neo4j, and his insights on graph versus relational databases, highlighting the innovations and future potential of graph technology.
This article surveys temporal database concepts, explains the SQL:2011 temporal extensions for valid and transaction time, and details how major products—DB2, SQL Server 2016, and MariaDB—implement these features, concluding with a comparative analysis of their capabilities.
This tutorial walks you through preparing a CentOS 7.4 system, installing MariaDB, configuring Zabbix 3.4.6 (including repository setup, database creation, service startup, PHP timezone adjustment, and web UI deployment), and verifies the monitoring platform is fully operational.