mariadb- Home of scripts
mariadb

mariadb

Details >>

MariaDB database management System is a branch of MySQL, mainly maintained by the open source community, MariaDB under the GPL license is intended to be fully compatible with MySQL, including the API and command line, making it an easy replacement for MySQL. In terms of storage engines, XtraDB is used instead of MySQL's InnoDB. MariaDB was created by Michael Widenius, the founder of MySQL. Development was led by Michael Widenius, who had earlier sold the company he founded, MySQL AB, to SUN for $1 billion, and then, with SUN's acquisition by Oracle, ownership of MySQL fell into Oracle's hands. The name MariaDB comes from the name of Michael Widenius' daughter Maria.

MariaDB's translate-based Maria storage engine, which replaces MySQL's MyISAM storage engine, uses Percona's XtraDB, a variant of InnoDB that the developers of the branch want to provide access to the upcoming MySQL 5.4 InnoDB performance. This release also includes PrimeBase XT (PBXT) and the FederatedX storage engine.

Compared to MySQL, MariaDB is stronger in the following ways:

  • Maria storage engine
  • PBXT storage engine
  • XtraDB Storage engine
  • FederatedX storage engine
  • Faster replication query processing
  • Thread pool
  • Fewer warnings and bugs
  • Faster running speed
  • More Extensions (More index parts, new startup options, etc.)
  • Better functional testing
  • Table elimination
  • Extended statistics of slow query logs
  • Support for Unicode sorting

Compared to the latest version of MySQL 5.6, MariaDB contains richer features in terms of performance, functionality, administration, and NoSQL extensions. Examples include microsecond support, thread pools, subquery optimization, group submission, progress reporting, and more.

Expand all
Date :2023-05-01 MariaDB data type details
Date :2022-11-24 Example of Mariadb database master/Slave replication synchronization configuration process
Date :2022-08-29 centos compilation and installation mariadb detailed process
Date :2022-06-29 MariaDB installation and configuration tutorial
Date :2022-02-07 MariaDB Spider database sorting practice records
Date :2022-01-27 Common Table Expressions (CTE) for MariaDB Table Expressions
Date :2020-11-30 debian10 mariadb installation process details
Date :2020-11-30 Example description of installing MariaDB database in Linux
Date :2020-11-23 MariaDB10.5.6 Installation and use details
Date :2020-02-21 Discuss the difference between MySQL and MariaDB in detail and compare the performance comprehensively
Date :2020-02-01 Error 28663 Cannot start the MongoDB server is reported
Date :2018-12-07 Tutorial illustration for installing MariaDB on Windows10
Date :2018-09-04 Foreign key constraint example of MariaDB database
Date :2018-08-11 How did I speed up MariaDB SQL with 2 Unix commands
Date :2018-08-01 Exchange Method of enabling anonymous relaying on the receive connector
Date :2018-05-22 Analysis of MariaDB database installation and system initialization operation for Windows 7
Date :2017-08-05 Setup method of MariaDB database environment in Windows Server 2016 Server Configuration Guide
Date :2017-06-06 Install mysql (MariaDB) under centos 7
Date :2017-04-24 How to successfully install MariaDB in CentOS 7
Date: March 22, 2017 mysql restarts MariaDB under Centos7
Date: March 22, 2017 Detailed usage of MariaDB performance tuning tool mytop
Date: March 12, 2017 MariaDB configures the dual-master replication scheme
Date :2016-11-21 mariadb master/slave replication, master/master replication, semi-synchronous replication configuration details
Date :2016-11-06 Compile and install MariaDB database in CentOS6.7 system
Date :2016-10-05 Remember once mariadb database could not connect
Date :2016-09-22 Installation steps for MariaDB database in Mac
Date :2016-09-20 mariadb crash solution on low configuration VPS
Date :2016-06-03 MongoDB quick start notes (8) MongoDB java driven operation code explanation
Date :2016-01-07 Error resolution for 1045 permission error in MariaDB causing user access to be denied
Date :2016-01-04 About mongoose connection mongodb repeated access error solution
Date :2015-09-18 CentOS installation and setup of MariaDB tutorial
Date :2015-09-18 Details Centos uses YUM to install MariaDB
Date :2015-09-18 Commands for installing mysql5.5 and mariadb on centos 7
Date :2015-09-18 On the difference between MySQL and mariadb
Date :2015-09-18 Causes and solutions of Mysql/MariaDB startup failure caused by progress bar status
Date :2015-06-29 Tutorial for installing MariaDB database in Ubuntu system
Date: March 19, 2015 MySQL branch selection reference: Percona or MariaDB
Date :2014-12-24 CMake Error at MariaDB
Date :2014-07-22 thread pool in MariaDB is introduced in detail and how to use it
Date :2014-07-14 How to retrieve MariaDB database root user permission in centos
Number of pages: 1/1 40 articles per page 40 Top page 1 Bottom page