{"id":4005,"date":"2020-02-11T14:59:04","date_gmt":"2020-02-11T07:59:04","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&p=4005"},"modified":"2023-08-06T21:30:46","modified_gmt":"2023-08-06T14:30:46","slug":"so-sanh-mariadb-va-mysql","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/so-sanh-mariadb-va-mysql\/","title":{"rendered":"So S\u00e1nh MariaDB v\u00e0 Mysql"},"content":{"rendered":"\n

\u0110\u1ea7u ti\u00ean v\u00e0 quan tr\u1ecdng nh\u1ea5t, MariaDB cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef t\u1ed1t h\u01a1n. H\u1ed7 tr\u1ee3 NoQuery, \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi Cassandra , cho ph\u00e9p b\u1ea1n ch\u1ea1y SQL v\u00e0 NoQuery trong m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u duy nh\u1ea5t. MariaDB c\u0169ng h\u1ed7 tr\u1ee3 TokuDB , c\u00f3 th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn cho m\u00e1y ch\u1ee7<\/a> c\u00e1c t\u1ed5 ch\u1ee9c l\u1edbn v\u00e0 ng\u01b0\u1eddi d\u00f9ng doanh nghi\u1ec7p.<\/p>\n\n\n\n

C\u00e1c c\u00f4ng c\u1ee5 c\u01a1 s\u1edf d\u1eef li\u1ec7u th\u00f4ng th\u01b0\u1eddng (v\u00e0 ch\u1eadm) c\u1ee7a MySQL MyISAM v\u00e0 InnoDB \u0111\u01b0\u1ee3c thay th\u1ebf trong MariaDB b\u1edfi Aria v\u00e0 XtraDB t\u01b0\u01a1ng \u1ee9ng. Aria cung c\u1ea5p b\u1ed9 nh\u1edb \u0111\u1ec7m t\u1ed1t h\u01a1n, \u0111i\u1ec1u n\u00e0y t\u1ea1o ra s\u1ef1 kh\u00e1c bi\u1ec7t khi ho\u1ea1t \u0111\u1ed9ng v\u1edbi nhi\u1ec1u \u0111\u0129a. C\u00e1c b\u1ea3ng t\u1ea1m th\u1eddi c\u0169ng s\u1eed d\u1ee5ng Aria, gi\u00fap t\u0103ng t\u1ed1c c\u00e1c truy v\u1ea5n ph\u1ee9c t\u1ea1p, ch\u1eb3ng h\u1ea1n nh\u01b0 c\u00e1c truy v\u1ea5n li\u00ean quan \u0111\u1ebfn GROUP BY v\u00e0 DISTINCT. XtraDB c\u1ee7a Percona tho\u00e1t kh\u1ecfi t\u1ea5t c\u1ea3 c\u00e1c s\u1ef1 c\u1ed1 InnoDB v\u1edbi hi\u1ec7u su\u1ea5t v\u00e0 \u0111\u1ed9 \u1ed5n \u0111\u1ecbnh ch\u1eadm, \u0111\u1eb7c bi\u1ec7t l\u00e0 trong m\u00f4i tr\u01b0\u1eddng t\u1ea3i cao.<\/p>\n\n\n\n

C\u00e1c t\u00ednh n\u0103ng b\u1ed5 sung, ch\u01b0a t\u1eebng c\u00f3 trong MariaDB cung c\u1ea5p kh\u1ea3 n\u0103ng gi\u00e1m s\u00e1t t\u1ed1t h\u01a1n th\u00f4ng qua vi\u1ec7c gi\u1edbi thi\u1ec7u \u0111\u1ed9 ch\u00ednh x\u00e1c c\u1ee7a micro gi\u00e2y v\u00e0 th\u1ed1ng k\u00ea ng\u01b0\u1eddi d\u00f9ng m\u1edf r\u1ed9ng . MariaDB c\u0169ng t\u0103ng c\u01b0\u1eddng l\u1ec7nh KILL \u0111\u1ec3 cho ph\u00e9p b\u1ea1n gi\u1ebft t\u1ea5t c\u1ea3 c\u00e1c truy v\u1ea5n cho ng\u01b0\u1eddi d\u00f9ng (t\u00ean ng\u01b0\u1eddi d\u00f9ng KILL USER) ho\u1eb7c \u0111\u1ec3 gi\u1ebft ID truy v\u1ea5n (KILL QUERY ID query_id). MariaDB c\u0169ng chuy\u1ec3n sang c\u00e1c bi\u1ec3u th\u1ee9c ch\u00ednh quy t\u01b0\u01a1ng th\u00edch Perl (PCRE), cung c\u1ea5p c\u00e1c truy v\u1ea5n ch\u00ednh x\u00e1c v\u00e0 m\u1ea1nh m\u1ebd h\u01a1n so v\u1edbi h\u1ed7 tr\u1ee3 regex ti\u00eau chu\u1ea9n c\u1ee7a MySQL.<\/p>\n\n\n\n

Ngo\u00e0i nhi\u1ec1u t\u00ednh n\u0103ng h\u01a1n, MariaDB c\u0169ng \u0111\u00e3 \u00e1p d\u1ee5ng m\u1ed9t s\u1ed1 t\u1ed1i \u01b0u h\u00f3a truy v\u1ea5n cho c\u00e1c truy v\u1ea5n \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi truy c\u1eadp \u0111\u0129a, tham gia ho\u1ea1t \u0111\u1ed9ng, truy v\u1ea5n con, b\u1ea3ng v\u00e0 khung nh\u00ecn d\u1eabn xu\u1ea5t, ki\u1ec3m so\u00e1t th\u1ef1c thi v\u00e0 th\u1eadm ch\u00ed gi\u1ea3i th\u00edch c\u00e1c c\u00e2u l\u1ec7nh. \u0110\u1ec3 xem nh\u1eefng \u0111i\u1ec1u n\u00e0y c\u00f3 \u00fd ngh\u0129a g\u00ec \u0111\u1ed1i v\u1edbi hi\u1ec7u su\u1ea5t c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/p>\n\n\n\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0  b\u1ea3ng so s\u00e1nh m\u1ed9t s\u1ed1 kh\u00e1c bi\u1ec7t gi\u1eefa Mysql v\u00e0 MariaDB<\/p>\n\n\n\n

Parameter<\/strong><\/th>MariaDB<\/strong><\/th>MySQL<\/strong><\/th><\/tr><\/thead>
Storage Engines<\/td>MariaDB h\u1ed7 tr\u1ee3 storage engines m\u1edbi, \u0111i\u1ec1u m\u00e0 Mysql kh\u00f4ng c\u00f3<\/td>C\u00f3 \u00edt t\u00f9y ch\u1ecdn storage h\u01a1n so v\u1edbi Mariadb<\/td><\/tr>
C\u1ea3i ti\u1ebfn t\u1ed1c \u0111\u1ed9<\/td>MariaDB cho th\u1ea5y m\u1ed9t t\u1ed1c \u0111\u1ed9 \u0111\u01b0\u1ee3c c\u1ea3i thi\u1ec7n khi so s\u00e1nh v\u1edbi MySQL.<\/td>\n
\n

MySQL th\u1ec3 hi\u1ec7n t\u1ed1c \u0111\u1ed9 ch\u1eadm h\u01a1n khi so s\u00e1nh v\u1edbi MariaDB.<\/p>\n<\/div>\n<\/td><\/tr>

\n
\n

Ph\u00e1t h\u00e0nh l\u1ea7n \u0111\u1ea7u<\/p>\n<\/div>\n<\/td>

2009<\/td>1995<\/td><\/tr>
H\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng<\/td>FreeBSD
Linux
Solaris
Windows<\/td>		FreeBSD
Linux
OS X
Solaris
Windows<\/td><\/tr>
Faster cache\/indexes<\/td>\n
\n

V\u1edbi c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef b\u1ed9 nh\u1edb c\u1ee7a MariaDB, m\u1ed9t c\u00e2u l\u1ec7nh INSERT c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c ho\u00e0n th\u00e0nh nhanh h\u01a1n 24% so v\u1edbi MySQL ti\u00eau chu\u1ea9n.<\/p>\n<\/div>\n<\/td>

memory storage engine c\u1ee7a MySQL ch\u1eadm h\u01a1n so v\u1edbi MariaDB.<\/td><\/tr>
t\u1ed1c \u0111\u1ed9 v\u00e0 s\u1ee9c ch\u1ee9a Connection Pool<\/td>MariaDB \u0111i k\u00e8m v\u1edbi thread pool n\u00e2ng cao c\u00f3 kh\u1ea3 n\u0103ng ch\u1ea1y nhanh h\u01a1n v\u00e0 h\u1ed7 tr\u1ee3 h\u01a1n 200.000 k\u1ebft n\u1ed1i.<\/td>\n
\n

Thread pool \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi MySQL kh\u00f4ng th\u1ec3 h\u1ed7 tr\u1ee3 t\u1edbi 200.000 k\u1ebft n\u1ed1i m\u1ed7i l\u1ea7n.<\/p>\n<\/div>\n<\/td><\/tr>

C\u1ea3i ti\u1ebfn Replication<\/td>Trong MariaDB, replication c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n an to\u00e0n h\u01a1n v\u00e0 nhanh h\u01a1n. replication c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh h\u01a1n g\u1ea5p 2 l\u1ea7n so v\u1edbi MySQL truy\u1ec1n th\u1ed1ng.<\/td>\n
\n

Phi\u00ean b\u1ea3n c\u1ed9ng \u0111\u1ed3ng c\u1ee7a MySQL cho ph\u00e9p s\u1ed1 l\u01b0\u1ee3ng ch\u1ee7 \u0111\u1ec1 t\u0129nh \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i. MySQL’s enterprise m\u1edbi \u0111i k\u00e8m v\u1edbi kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng.<\/p>\n<\/div>\n<\/td><\/tr>

New Features\/Extensions<\/td>\n
\n

MariaDB \u0111i k\u00e8m v\u1edbi c\u00e1c t\u00ednh n\u0103ng v\u00e0 ti\u1ec7n \u00edch m\u1edf r\u1ed9ng m\u1edbi bao g\u1ed3m c\u00e1c c\u00e2u l\u1ec7nh JSON, WITH v\u00e0 KILL.<\/p>\n<\/div>\n<\/td>

\n
\n

C\u00e1c t\u00ednh n\u0103ng MariaDB m\u1edbi kh\u00f4ng \u0111\u01b0\u1ee3c cung c\u1ea5p trong MySQL.<\/p>\n<\/div>\n<\/td><\/tr>

C\u00e1c t\u00ednh n\u0103ng ch\u01b0a c\u00f3.<\/td>MariaDB thi\u1ebfu m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi phi\u00ean b\u1ea3n doanh nghi\u1ec7p MySQL. \u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y, n\u00f3 cung c\u1ea5p c\u00e1c plugin ngu\u1ed3n m\u1edf thay th\u1ebf.<\/td>\n
\n

Phi\u00ean b\u1ea3n doanh nghi\u1ec7p c\u1ee7a MySQL s\u1eed d\u1ee5ng m\u00e3 \u0111\u1ed9c quy\u1ec1n. Ch\u1ec9 ng\u01b0\u1eddi d\u00f9ng c\u1ee7a MySQL Enterprise Edition m\u1edbi c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o \u0111\u00e2y.<\/p>\n<\/div>\n<\/td><\/tr>

Priority code<\/td>\n
\n

MariaDB kh\u00f4ng cho ph\u00e9p truy c\u1eadp v\u00e0o n\u1ed9i dung ri\u00eang t\u01b0 v\u00e0 l\u00e0 m\u1ed9t ngu\u1ed3n \u0111\u00f3ng.<\/p>\n<\/div>\n<\/td>

\n
\n

MySQL s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 m\u00e3 \u0111\u1ed9c quy\u1ec1n trong Phi\u00ean b\u1ea3n doanh nghi\u1ec7p c\u1ee7a n\u00f3.<\/p>\n<\/div>\n<\/td><\/tr>

Data Masking<\/td>Kh\u00f4ng<\/td>C\u00f3<\/td><\/tr>
Dynamic columns<\/td>Kh\u00f4ng<\/td>C\u00f3<\/td><\/tr>
Monitoring<\/td>SQLyog<\/td>MySQL workbench<\/td><\/tr>
Routing<\/td>MariaDB MaxScale<\/td>Mysql Router<\/td><\/tr>
Analytics<\/td>MaraiDB ColumnStore<\/td>No<\/td><\/tr>
Secondary database model<\/td>ocument store v\u00e0 \u0111\u1ed3 th\u1ecb DBMS<\/td>Document store<\/td><\/tr>
Git hub stars<\/td>2.8 k<\/td>4k<\/td><\/tr>
Forks<\/td>868<\/td>1.6 K<\/td><\/tr>
\n
\n

C\u00f4ng ty n\u1ed5i ti\u1ebfng s\u1eed d\u1ee5ng<\/p>\n<\/div>\n<\/td>

Nrise, Accenture, Docplanner, Grooveshark.<\/td>Airbnb, Uber Technogloeis, Netflix, Dropbox.<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

\u0110\u1ea7u ti\u00ean v\u00e0 quan tr\u1ecdng nh\u1ea5t, MariaDB cung c\u1ea5p nhi\u1ec1u c\u00f4ng c\u1ee5 l\u01b0u tr\u1eef t\u1ed1t h\u01a1n. H\u1ed7 tr\u1ee3 NoQuery, \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi Cassandra , cho ph\u00e9p b\u1ea1n ch\u1ea1y SQL v\u00e0 NoQuery trong m\u1ed9t h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u duy nh\u1ea5t. MariaDB c\u0169ng h\u1ed7 tr\u1ee3 TokuDB , c\u00f3 th\u1ec3 x\u1eed l\u00fd d\u1eef li\u1ec7u l\u1edbn […]<\/p>\n","protected":false},"author":11,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5156],"class_list":["post-4005","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-mariadb"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=4005"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4005\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/16424"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=4005"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4005"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}