BestHub
Sign in
Tagged articles
129 articles
Page 2 of 2
Programmer DD
Programmer DD
Jan 8, 2018 · Information Security

Essential Linux MySQL/MariaDB Security Practices Every Admin Should Follow

This guide outlines twelve practical steps to harden MySQL and MariaDB on Linux, covering secure installation, network binding, disabling unsafe features, changing defaults, enabling logging, proper permissions, history cleanup, safe credential handling, application‑specific users, security plugins, password rotation, and regular package updates.

Database HardeningLinuxMariaDB
0 likes · 8 min read
Essential Linux MySQL/MariaDB Security Practices Every Admin Should Follow
dbaplus Community
dbaplus Community
Dec 12, 2017 · Databases

MariaDB ColumnStore: Future‑Ready OLAP Architecture, Limits & Migration Tips

This article shares practical experience deploying MariaDB ColumnStore for offline OLAP, covering its MPP‑based architecture, user‑experience benefits, high‑availability options, numerous syntax and data‑type limitations, and detailed scripts for schema conversion and incremental data extraction using pt‑archiver.

ColumnstoreData MigrationMariaDB
0 likes · 17 min read
MariaDB ColumnStore: Future‑Ready OLAP Architecture, Limits & Migration Tips
21CTO
21CTO
Dec 4, 2017 · Databases

The Untold Story of Monty Widenius: How MySQL Became the World’s Top Database

This article chronicles Monty Widenius’s journey from a teenage programmer in Helsinki to the creator of MySQL, detailing the database’s origins, open‑source philosophy, commercial licensing model, and its lasting impact on the global data‑management ecosystem.

Database HistoryMariaDBMonty Widenius
0 likes · 9 min read
The Untold Story of Monty Widenius: How MySQL Became the World’s Top Database
Efficient Ops
Efficient Ops
Oct 23, 2017 · Databases

How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB

The article recounts how Tencent Game DBA engineers contributed two core features—instant ADD COLUMN and large‑field compression—to MariaDB 10.3.2 Alpha, slashing a 12‑hour schema change to 0.04 seconds, earning public thanks from the MariaDB project and its founder Monty, and illustrating the impact of open‑source collaboration on high‑performance game databases.

Instant Add ColumnMariaDBTencent DBA
0 likes · 9 min read
How Tencent’s DBA Team Cut a 12‑Hour Schema Change to 0.04 seconds in MariaDB
dbaplus Community
dbaplus Community
Apr 19, 2017 · Databases

How to Use MariaDB Spider for Horizontal & Vertical Sharding

This article explains what MariaDB Spider is, its role as a pluggable storage engine for MySQL/MariaDB sharding, demonstrates vertical and horizontal partitioning with real‑world Tencent game case, provides installation steps, configuration commands, performance considerations, tunable parameters, and load‑balancing architecture.

MariaDBSpiderdatabase partitioning
0 likes · 8 min read
How to Use MariaDB Spider for Horizontal & Vertical Sharding
dbaplus Community
dbaplus Community
Mar 23, 2017 · Databases

Secure MariaDB Connections with SSL: A Complete Step‑by‑Step Guide

This article explains why internet‑financial companies need encrypted MariaDB connections, shows how to verify SSL support, and provides a detailed eight‑step procedure—including OpenSSL upgrade, CA creation, server and client certificates, MySQL configuration, and verification—to enable secure client‑server communication.

MariaDBOpenSSLSSL
0 likes · 11 min read
Secure MariaDB Connections with SSL: A Complete Step‑by‑Step Guide
dbaplus Community
dbaplus Community
Dec 22, 2016 · Databases

MariaDB Columnstore Deep Dive: Architecture, Performance, and Deployment

MariaDB Columnstore, the newly integrated InfiniDB storage engine, brings column‑store analytics to MySQL, offering P‑scale data handling, distributed deployment, and impressive performance gains over InnoDB, with detailed installation steps, kernel tuning, command‑line administration, and optimization tips for production environments.

AnalyticsColumnstoreInfiniDB
0 likes · 11 min read
MariaDB Columnstore Deep Dive: Architecture, Performance, and Deployment
dbaplus Community
dbaplus Community
Dec 16, 2016 · Databases

Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights

This article explains how MariaDB, a community‑driven fork of MySQL, maintains full compatibility while adding new storage engines, advanced replication, performance‑boosting features like XtraDB and thread pools, and why many organizations consider it a superior replacement for Oracle‑owned MySQL.

MariaDBReplicationStorage Engine
0 likes · 9 min read
Why MariaDB Beats MySQL: Features, Compatibility, and Performance Insights
MaGe Linux Operations
MaGe Linux Operations
Dec 3, 2016 · Operations

Build a Scalable Distributed Storage System with MogileFS and Nginx

This guide walks through the concepts of distributed file systems, introduces MogileFS, and provides step‑by‑step instructions—including environment setup, MariaDB and MogileFS configuration, Nginx compilation with the MogileFS module, and testing—to create a scalable small‑file storage solution.

LinuxMariaDBMogileFS
0 likes · 13 min read
Build a Scalable Distributed Storage System with MogileFS and Nginx
MaGe Linux Operations
MaGe Linux Operations
Oct 9, 2016 · Databases

How to Simplify Permission Management with MariaDB Roles

This article explains why database roles are essential for efficient permission handling, outlines the benefits of using roles, and provides step‑by‑step instructions with screenshots for creating and assigning roles in MariaDB, while noting MySQL's current lack of support.

Database RolesMariaDBUser Administration
0 likes · 3 min read
How to Simplify Permission Management with MariaDB Roles
Efficient Ops
Efficient Ops
May 29, 2016 · Databases

Recover Accidentally Deleted MySQL/MariaDB Data with Binlog Flashback

This article explains how to simulate a flashback feature for MySQL and MariaDB by parsing binlogs, allowing you to restore tables after accidental DELETE or UPDATE operations without relying on full backups, and provides step‑by‑step commands and precautions.

BinlogData RecoveryDatabase Administration
0 likes · 6 min read
Recover Accidentally Deleted MySQL/MariaDB Data with Binlog Flashback
dbaplus Community
dbaplus Community
May 4, 2016 · Databases

Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies

This guide compares Percona Server, MariaDB, and MySQL, outlines practical MySQL performance tuning steps across hardware, storage, filesystem, and server parameters, and presents several high‑availability architectures such as master‑slave replication, MMM/MHA, Heartbeat/SAN, and Heartbeat/DRBD with real‑world deployment examples.

Database TuningMariaDBPercona
0 likes · 9 min read
Choosing Percona, MariaDB or MySQL and Proven MySQL Tuning & HA Strategies
21CTO
21CTO
Sep 25, 2015 · Databases

How MySQL 5.7 Optimizes Metadata Locks and Boosts Replication Performance

This article explains the evolution of MySQL's metadata lock (MDL) subsystem, the introduction of lock‑free hash tables and fast‑path locking in 5.7, the hash_scan replication optimization, TokuDB 7.5.0 enhancements, and MariaDB's small‑LIMIT filesort improvement, providing deep insight into modern database performance tuning.

Hash ScanMariaDBTokuDB
0 likes · 17 min read
How MySQL 5.7 Optimizes Metadata Locks and Boosts Replication Performance
Efficient Ops
Efficient Ops
Aug 25, 2015 · Databases

Choosing the Right MySQL Branch and Shaping the Future of MySQL DBAs

This article summarizes a live Q&A where experts compare MySQL official, MariaDB, and Percona branches, discuss the pros and cons of each, and explore how MySQL DBAs can balance source‑code knowledge with operational expertise to advance their careers and influence architecture and business integration.

DBA CareerDatabase AdministrationMariaDB
0 likes · 10 min read
Choosing the Right MySQL Branch and Shaping the Future of MySQL DBAs
MaGe Linux Operations
MaGe Linux Operations
Jul 2, 2015 · Databases

15 Essential MySQL & MariaDB Performance Tuning Tips for Faster Databases

This guide walks you through essential MySQL and MariaDB performance‑tuning techniques—including storage engine settings, disk placement, buffer pool sizing, swappiness, connection limits, thread cache, DNS lookup, query cache, temporary tables, slow‑query logging, idle connections, file‑system choices, packet size, and testing tools—to help you optimize and maintain a high‑speed, reliable database server.

Database OptimizationInnoDBLinux
0 likes · 15 min read
15 Essential MySQL & MariaDB Performance Tuning Tips for Faster Databases
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Mar 23, 2015 · Databases

Percona Server vs. MariaDB: Features, Compatibility, and Performance Compared to MySQL

The article examines the impact of Oracle's acquisition of MySQL, introduces Percona XtraDB and Percona Server, outlines MariaDB's origins and compatibility, compares their storage engines, performance, and version histories, and provides resources for further comparison of these MySQL alternatives.

MariaDBPerconaStorage Engine
0 likes · 7 min read
Percona Server vs. MariaDB: Features, Compatibility, and Performance Compared to MySQL