MariaDB Vs MySQL

Minggu, 06/07/2014 Internet 1767 hits


MySQL adalah teknologi database yang paling banyak digunakan untuk perusahaan dan aplikasi web di dunia. Hal ini telah terbukti menjadi alternatif yang fleksibel, kuat, dan efektifitas biaya untuk database. Teknologi MySQL merupakan pusat arsitektur Internet.

MariaDB kini menjadi pilihan alternatif bahkan bisa saja menjadi pilihan utama karena banyak kelebihan yang ditawarkan.

Berikut kelebihan dari MariaDB dibandingkan MySQL yang saya copas langsung dari websitenya MariaDB.

Compare Products MySQL 5.6 MariaDB 10
What is it? MySQL 5.6 is a popular choice of database for use in web applications, and is a central component of the widely used LAMP web application software stack. MariaDB 10 is a enhanced, high performance, free and open source alternative to MySQL that helps the world's busiest websites deliver more content faster.
Scalability
Parallel Slave Replication Scalability
Compatible with MySQL 5.6 but with improvements. MySQL's parallel replication can only run transactions for different databases in parallel - each database per slave is single-threaded. The MariaDB implementation can run multiple transactions within same database in parallel. Up to 4x replication performance improvement vs. MySQL. .
Single threaded per database V
Multi-source Replication Scalability
Allows a slave database server to replicate from multiple master servers. If you've split your data over several masters - multiple databases, applications, sharding - Multi-source Replication can pull all the data together onto one slave for analytics, backup, etc. .

V
Global Transaction ID Scalability
Makes complex replication hierarchies such as Multi-Source Replication be ACID consistent and durable, while running in parallel at high performance and scale. Tags events within a replication hierarchy with a unique, universal identifier spanning multiple domains, but strictly ordered within each domain. MySQL 5.6’s GTID does not allow for independent domains, and thus is limited in supporting complex replication. MariaDB’s GTID is more powerful and flexible. .
Limited V
Sharding - Spider Storage Engine Scalability
Spider is a storage engine contributed by a 3rd party. It allows for a table to be sharded using simple hashing only. Supports XA transactions. Shards may be replicated for HA. Includes master lookup table replication. .
3rd party V
TokuDB Storage Engine Scalability
Integrated with MariaDB 10, TokuDB uses advanced indexing and compression that allows for much faster updates/insertion, greatly reducing slave lag for replication. .
3rd party V
Table Partitioning: Improvements Scalability
Application-level table partitioning lets an application control how a table is split across multiple OS files and multiple servers, for performance and scale.
V V
Performance
TokuDB Storage Engine Performance
Integrated with MariaDB 10, TokuDB uses advanced indexing and compression that allows for up to 20x faster updates/insertion, and up to 90% less HDD/flash. .
3rd party V
Engine Independent Table Statistics Performance
Improves optimizations by gathering statistics for use by the optimizer about the size and structure of tables, independent of specific storage engine features. .

V
Subquery Optimizations Performance
Through transformation, apply existing optimizations to a broader range of SQL statements. .

V
Histogram Stats for Non-Indexed Columns Performance
Improves optimizations on columns without indexes, by capturing the distribution of values on such columns and using that distribution to adjust the query plan. .

V
Fusion-io specific enhancements Performance
Improves the performance of Fusion-io SSDs when used with MariaDB. Uses the atomic write feature of the Fusion-io directFS filesystem, and eliminates InnoDB overhead to guarantee ACID consistency. .

V
Performance Schema Performance
Allows a developer or DBA, or IT automation tooling to directly monitor performance of a database node in real time through SQL queries to a monitoring table built right into the system.
V V
Improved thread pool Performance
Increase the scalability of the database server when there are many concurrent connections. .
MySQL Enterprise only V
NoSQL Capabilities
CONNECT storage engine NoSQL Capabilities
CONNECT is a flexible tool to access diverse data sources dynamically, including unstructured files such as log files in a folder, or any database with an ODBC connector, from within MariaDB. .

V
Sequence storage engine NoSQL Capabilities
Create numerical sequences that are stored in memory and can be used in your queries. .

V
NoSQL Cassandra Storage Engine NoSQL Capabilities
Combine data from Cassandra with your data in MariaDB, read and write Cassandra data, and connect many MariaDB servers to one Cassandra ring, creating a high-availability cluster. .

V
Dynamic Columns NoSQL Capabilities
Dynamic Columns store different, labeled data objects in each row of a table in much the same way as NoSQL technologies. .

V
NoSQL Handlersocket interface NoSQL Capabilities
HandlerSocket gives you direct access to InnoDB/XtraDB and SPIDER. .

V
NoSQL memcache interface NoSQL Capabilities
Persist memcached data in InnoDB.
V
Operations
Improved table discovery Operations
For storage engines that support this capability, MariaDB 10 includes the ability to use tables for which no explicit CREATE TABLE statement has been run. The Sequence and FederatedX storage engines now support table discovery. .

V
SHOW PLUGINS SONAME Operations
Reports information and installation status on compiled-in and dynamic plug-ins. .

V
SHUTDOWN Command Operations
Added SHUTDOWN statement to SQL syntax - shuts a server down gracefully. Same permissions as mysqladmin shutdown. .

V
Kill query by query ID Operations
Allows a DBA or admin to kill a single query executing on a connection/thread, without killing the entire connection. .

V
SHOW EXPLAIN Command Operations
Helps developers and DBAs diagnose performance issues. Lets you get the query plan for actively running queries. Optionally, can automatically run SHOW EXPLAIN on queries in the slow query log and capture the plan in the log. .

V
Per-thread Memory Statistics Operations
Adds a memory usage column to the processlist, and allows this value to be returned through SHOW STATUS. Using this new feature, DBAs and developers can evaluate per-connection memory usage to diagnose problems.

V
Improved Error Messages Operations
All errors now include descriptive text in the log for the benefit of both developers and DBAs.

V
Online ALTER TABLE Operations
Do many of your schema changes without interrupting the system. MySQL 5.6 introduces the concept of online ALTER, which has been merged to MariaDB 10.0.
V V
Security & Compliance
Role-based access control Security & Compliance
DBAs can now create roles with certain permissions and assign users to the roles. .

V
Audit Plugin Security & Compliance
The MariaDB Audit Plugin introduces the capabilities of tracking user access to data. Follow in real time who’s doing what in your databases. .
MySQL Enterprise only V
PAM Authentication Plugin Security & Compliance
The plugin enables Pluggable Authentication Modules (PAM) for the database server, which is an authentication framework used by Linux, FreeBSD, Solaris, and other operating systems. .
MySQL Enterprise only V

Semoga bermanfaat ..

Sumber: https://mariadb.com/products/mariadb

: tanpa label



Silakan beri komentar :)

Tahukah ANDA ?
Di bawah ini ada sebuah daftar kegagalan dari orang yang semasa hidupnya mengalami banyak tantangan dan badai. 1831 - ia mengalami kebangkrutan dalam usahanya. 1832 - ia menderita kekalahan dalam pemilihan tingkat lokal. 1833 - ia kembali menderita kebangkrutan. 1835 - istrinya meninggal dunia. 1836 - ia menderita tekanan mental…

Cangehgar: Bandung Super Mall Jadi Rumah Sakit


MUTIARA HADIST

Jika Kamu Berada Di Sore Hari, Jgn Kau Tunggu Pagi Hari. Dan Jika Kau Berada Di Pagi Hari, Janganlah Menunggu Sore Hari. Ambillah Persiapan Saat Engkau Sehat Utk Menghadapi Masa Sakitmu Dan Saat Hidupmu Utk Sesudah Kematianmu

Hari Gini! Masih Menunda-nunda

Hosting, VPS & Server

Kini saatnya memiliki website/blog professional dan memiliki prestise baik untuk pribadi maupun instansi/perusahaan. Layanan VPS maupun Dedicated Server dengan harga yang terjangkau

Learn More

Web Desain

Memerlukan layanan Jasa pembuatan website ? Jangan ragu untuk menggunakan layanan GaluhWeb yang telah digunakan oleh puluhan Pelanggan. Ayo tunggu apalagi ?

Learn More

Domain

Gunakan identitas bisnis atau blog dengan domain yang keren. Harga murah dengan fitur melimpah. Buruan daftarkan domain anda sebelum keduluan yang lain :)

Learn More