{"id":19912,"date":"2016-11-04T18:20:26","date_gmt":"2016-11-04T14:50:26","guid":{"rendered":"https:\/\/www.sourcebaran.com\/?p=19912"},"modified":"2021-07-24T13:28:53","modified_gmt":"2021-07-24T08:58:53","slug":"advanced-mysql-and-mariadb","status":"publish","type":"post","link":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html","title":{"rendered":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB"},"content":{"rendered":"<div id=\"attachment_19913\" style=\"width: 714px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB.jpg\"><img aria-describedby=\"caption-attachment-19913\" decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-19913\" src=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB.jpg\" alt=\"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB\" width=\"704\" height=\"346\" srcset=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB.jpg 704w, https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB-300x147.jpg 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/a><p id=\"caption-attachment-19913\" class=\"wp-caption-text\">\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB<\/p><\/div>\n<p style=\"text-align: justify;\">\u0633\u0644\u0627\u0645 \u0648 \u0639\u0631\u0636 \u0627\u062f\u0628. \u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a <a href=\"https:\/\/www.sourcebaran.com\/\">\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc<\/a> \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 <span style=\"color: #ff0000;\">\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB<\/span> <span style=\"color: #ff0000;\">\u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc<\/span> \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 <a href=\"https:\/\/www.sourcebaran.com\/\">\u0622\u0645\u0648\u0632\u0634<\/a> \u062a\u0635\u0648\u06cc\u0631\u06cc \u0628\u0627 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 <a href=\"https:\/\/www.sourcebaran.com\/\">MySQL<\/a> \u0648 <a href=\"https:\/\/www.sourcebaran.com\/\">MariaDB<\/a> \u0622\u0634\u0646\u0627 \u0645\u06cc \u0634\u0648\u06cc\u062f. MySQL \u0648 MariaDB \u062f\u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0647\u0633\u062a\u0646\u062f. \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0628\u0647 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0648 \u062a\u0641\u0627\u0648\u062a \u0647\u0627\u06cc \u0628\u06cc\u0646 MySQL \u0648 MariaDB \u0648 \u0627\u0646\u062c\u0627\u0645 \u06a9\u0627\u0631\u0647\u0627\u06cc \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 \u0647\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u062f.\u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0627\u06cc \u0627\u0631\u0632\u06cc\u0627\u0628\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0627\u0628\u0632\u0627\u0631 \u0647\u0627 \u0648 \u062a\u06a9\u0646\u06cc\u06a9 \u0647\u0627\u06cc \u062c\u062f\u06cc\u062f \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p style=\"text-align: justify;\">\u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0646\u062d\u0648\u0647 \u0646\u0635\u0628 \u0648 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0645\u0648\u062a\u0648\u0631 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc Sphinx \u0648 \u067e\u0644\u0627\u06af\u06cc\u0646 \u0647\u0627\u06cc HandlerSocket \u0648 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u0631\u0627 \u0622\u0645\u0648\u0632\u0634 \u0645\u06cc \u0647\u062f \u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0627\u0639\u062a\u0628\u0627\u0631\u0633\u0646\u062c\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0648 \u062d\u0633\u0627\u0628\u0631\u0633\u06cc \u067e\u0644\u0627\u06af\u06cc\u0646 \u0647\u0627 \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u0631\u0648\u062f \u0631\u0627 \u0645\u0637\u0631\u062d \u0645\u06cc \u06a9\u0646\u062f. \u0644\u0637\u0641\u0627 \u062a\u0648\u062c\u0647 \u0628\u0641\u0631\u0645\u0627\u06cc\u06cc\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u062f\u0648\u0631\u0647 \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0645\u06cc \u0628\u0627\u0634\u062f\u060c \u0647\u0645\u0686\u0646\u06cc\u0646 \u0633\u0631\u0641\u0635\u0644 \u0647\u0627\u06cc \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0645\u0637\u0644\u0628 \u0630\u06a9\u0631 \u0634\u062f\u0647&#8230;<\/p>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"color: #ff0000; font-size: 12pt;\">\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB<\/span><\/h3>\n<ul>\n<li>MariaDB \u0686\u06af\u0648\u0646\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f\u061f<\/li>\n<li>\u0686\u06af\u0648\u0646\u0647 MariaDB \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0632 MySQL \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f\u061f<\/li>\n<li>\u0646\u062d\u0648\u0647 \u06cc \u0627\u062f\u063a\u0627\u0645 \u0633\u0631\u0648\u0631<\/li>\n<li>\u0645\u0634\u0627\u0647\u062f\u0647 \u0622\u0645\u0627\u0631 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u0645\u062c\u0627\u0632\u06cc<\/li>\n<li>\u0646\u062d\u0648\u0647 \u06cc \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc Sphinx<\/li>\n<li>\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 Sphinx<\/li>\n<li>\u06a9\u0627\u0631 \u0628\u0627 NoSQL<\/li>\n<li>\u0646\u0635\u0628 \u0627\u0641\u0632\u0648\u0646\u0647 HandlerSocket<\/li>\n<li>\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc HandlerSocket<\/li>\n<li>\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MySQL<\/li>\n<li>\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MariaDB<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 MariaDB \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u062d\u0633\u0627\u0628\u0631\u0633\u06cc<\/li>\n<li>\u062a\u0627\u06cc\u06cc\u062f \u067e\u0644\u0627\u06af\u06cc\u0646<\/li>\n<li>\u0646\u0635\u0628 \u067e\u0644\u0627\u06af\u06cc\u0646<\/li>\n<li>\u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0647\u0646\u062f\u0633\u06cc \u0648 \u062c\u063a\u0631\u0627\u0641\u06cc\u0627\u06cc\u06cc<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MySQL<\/li>\n<li>\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MariaDB<\/li>\n<li>\u0648\u2026<\/li>\n<\/ul>\n<pre class=\"lang:default decode:true \" dir=\"ltr\">MySQL and MariaDB are powerful database solutions that operate in slightly different ways. In this course Sheeri K. Cabral compares and contrasts MySQL and MariaDB, and shows you how to perform advanced tasks in each system. First, learn how to install and configure the Sphinx storage engine and HandlerSocket plugin. Then find out how to set up GTIDs (global transaction identifiers) and make replication even easier, especially for failover. Finally, discover how to install and use authentication and audit plugins, and learn how MySQL and MariaDB store geometric and geographical information. These tutorials will help you evaluate these database management systems and find useful new tools and techniques to add to your administrative arsenal.\r\nWant more information about MariaDB? Check out Understanding MariaDB for MySQL Users.\r\nTopics include:\r\nComparing MariaDB and MySQL\r\nCreating and using virtual columns in MariaDB\r\nBuilding Sphinx tables\r\nInstalling HandlerSocket\r\nSetting up GTIDs in MariaDB and MySQL\r\nAudit logging in MariaDB and MySQL\r\nUsing GIS in MariaDB and MySQL\r\nIntroduction\r\n3m 6s\r\nWelcome\r\n1m 14s\r\nWhat you should know before watching this course\r\n1m 52s\r\n1. How MariaDB Is Different\r\n30m 29s\r\nHow MariaDB is different than MySQL\r\n4m 54s\r\nExploring server thread pooling\r\n5m 22s\r\nViewing user statistics\r\n6m 43s\r\nCreating and using virtual columns\r\n3m 56s\r\nUsing persistent virtual columns\r\n5m 45s\r\nProgress reporting and millisecond resolution\r\n3m 49s\r\n2. The Sphinx Storage Engine\r\n8m 37s\r\nInstalling the Sphinx storage engine\r\n3m 31s\r\nCreating a Sphinx table\r\n5m 6s\r\n3. NoSQL Integration\r\n8m 57s\r\nInstalling the HandlerSocket plugin\r\n3m 39s\r\nConfiguring HandlerSocket\r\n5m 18s\r\n4. Global Transaction Identifiers and Multisource Replication\r\n16m 20s\r\nGlobal transaction identifiers (GTIDs) and failover\r\n2m 47s\r\nSetting up GTIDs in MySQL\r\n4m 58s\r\nSetting up GTIDs in MariaDB\r\n5m 36s\r\nExploring multisource replication\r\n2m 59s\r\n5. Audit Plugin\r\n12m 33s\r\nUnderstanding and installing the Audit plugin\r\n3m 8s\r\nUsing MariaDB audit logging\r\n4m 28s\r\nUsing MySQL audit logging\r\n4m 57s\r\n6. Authentication Plugin\r\n8m 26s\r\nUnderstanding and installing the Authentication plugin\r\n4m 49s\r\nUsing the Pluggable Authentication Modules (PAM)\r\n3m 37s\r\n7. Geometric and Geographical Data\r\n9m 44s\r\nStoring geometric and geographical data\r\n1m 54s\r\nUsing GIS in MySQL\r\n5m 5s\r\nUsing GIS in MariaDB\r\n2m 45s\r\nConclusion\r\n1m 28s\r\nNext steps\r\n1m 28s<\/pre>\n<p>&nbsp;<\/p>\n<p>\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB<\/p>\n<p style=\"text-align: justify;\">\u062f\u0631 \u062c\u0644\u0633\u0647 \u0627\u06cc \u06a9\u0647 \u062a\u06cc\u0645 \u062a\u0648\u0633\u0639\u0647 \u062a\u0648\u0632\u06cc\u0639 \u0645\u062d\u0628\u0648\u0628 \u0641\u062f\u0648\u0631\u0627 \u062f\u0627\u0634\u062a\u0646\u062f \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MariaDB \u0628\u0627 MySQL \u0627\u0631\u0627\u0626\u0647 \u0634\u062f \u0648 \u0627\u062d\u062a\u0645\u0627\u0644 \u0645\u06cc \u0631\u0648\u062f \u06a9\u0647 \u0627\u06cc\u0646 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u06cc \u062f\u0631 \u0646\u0633\u062e\u0647 \u06cc \u0628\u0639\u062f\u06cc \u0641\u062f\u0648\u0631\u0627 \u06cc\u0639\u0646\u06cc Fedora 19 \u06a9\u0647 \u0628\u0627 \u0646\u0627\u0645 \u06af\u0631\u0628\u0647 \u0634\u0631\u0648\u062f\u06cc\u0646\u06af\u0631 (Schr\u00f6dinger\u2019s Cat) \u0627\u0633\u062a \u0631\u062e \u062f\u0647\u062f.<\/p>\n<p style=\"text-align: justify;\">\u0627\u06cc\u0646 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0627\u0632 \u0637\u0631\u0641 Jaroslav Reznik \u0648 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0644\u06cc\u0633\u062a \u067e\u0633\u062a\u06cc \u0641\u062f\u0648\u0631\u0627 \u0627\u0639\u0644\u0627\u0645 \u0634\u062f \u0648 \u062f\u0644\u06cc\u0644 \u0627\u06cc\u0646 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u062a\u0631\u0633 \u0627\u0632 \u062d\u0631\u06a9\u062a \u0634\u0631\u06a9\u062a \u0627\u0648\u0631\u0627\u06a9\u0644 \u0628\u0647 \u0633\u0645\u062a \u0645\u062f\u0644 \u0628\u0633\u062a\u0647 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0627\u0633\u062a.<\/p>\n<p style=\"text-align: justify;\">\u0634\u0631\u06a9\u062a \u0627\u0635\u0644\u06cc \u067e\u0634\u062a MySQL \u06a9\u0647\u060c MySQL AB \u0628\u0648\u062f \u062a\u0648\u0633\u0637 \u0634\u0631\u06a9\u062a Sun \u062e\u0631\u06cc\u062f\u0627\u0631\u06cc \u0634\u062f \u0648 \u067e\u0633 \u0627\u0632 \u0622\u0646 \u0646\u06cc\u0632 Sun \u062a\u0648\u0633\u0637 \u0634\u0631\u06a9\u062a \u0627\u0648\u0631\u0627\u06a9\u0644 \u062e\u0631\u06cc\u062f\u0627\u0631\u06cc \u0634\u062f.<span id=\"more-1990\"><\/span><\/p>\n<p style=\"text-align: justify;\">MariaDB \u0627\u0646\u0634\u0639\u0627\u0628\u06cc \u0627\u0632 \u067e\u0631\u0648\u0698\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 MySQL \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u062a\u0648\u0633\u0637 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u0646\u06af\u0627\u0646 \u0648 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u0627\u0646 \u0627\u0635\u0644\u06cc MySQL \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0648 \u0628\u0647 \u0635\u0648\u0631\u062a open-source \u0648 \u062f\u0627\u0631\u0627\u06cc \u062c\u0627\u0645\u0639\u0647 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0641\u0639\u0627\u0644\u06cc \u0645\u06cc \u0628\u0627\u0634\u062f.\u0648 \u062f\u0627\u0631\u0627\u06cc \u0645\u0648\u062a\u0648\u0631 \u062c\u062f\u06cc\u062f \u0648 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc\u06cc \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u06af\u0641\u062a\u0646\u06cc \u0627\u0633\u062a MariaDB \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f \u0633\u0631\u06cc\u0639 \u062a\u0631 \u0627\u0633\u062a.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/mariadb_vs_mysql.jpg\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-19915 aligncenter\" src=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/mariadb_vs_mysql.jpg\" alt=\"mariadb_vs_mysql\" width=\"468\" height=\"168\" srcset=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/mariadb_vs_mysql.jpg 468w, https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/mariadb_vs_mysql-300x108.jpg 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">\u0628\u0627 \u0627\u06cc\u0646 \u0627\u0648\u0635\u0627\u0641 \u067e\u0631\u0648\u0698\u0647 \u0641\u062f\u0648\u0631\u0627 \u0642\u0635\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0647\u0631 \u0686\u0647 \u0633\u0631\u06cc\u0639\u062a\u0631 \u0631\u0648\u0646\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646\u06cc MariaDB \u0631\u0627 \u0628\u0627 MySQL \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u062f \u0648 \u0686\u0631\u062e\u0647 \u06cc \u062a\u0648\u0633\u0639\u0647 \u0622\u0646 \u0631\u0627 \u0622\u063a\u0627\u0632 \u06a9\u0646\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0641\u062f\u0648\u0631\u0627 \u06f1\u06f9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u06cc\u0632\u06cc \u0634\u062f\u0647 \u0627\u0633\u062a.\u0647\u0631 \u0686\u0646\u062f MySQL \u0646\u06cc\u0632 \u0647\u0645\u0686\u0646\u0627\u0646 \u0642\u0627\u0628\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0628\u0627\u0634\u062f \u0648\u0644\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u062d\u062a\u0645\u0627\u0644\u0627 \u062f\u0631 \u0641\u062f\u0648\u0631\u0627 \u06f1\u06f9 \u0627\u0632 MariaDB \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f \u0648 \u062a\u06cc\u0645 \u062a\u0648\u0633\u0639\u0647 \u0641\u062f\u0648\u0631\u0627 \u0642\u0635\u062f \u0646\u062f\u0627\u0631\u0646\u062f \u06a9\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u0647\u0645\u0632\u0645\u0627\u0646 \u0627\u0632 \u0647\u0631 \u062f\u0648 \u0628\u0633\u062a\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p style=\"text-align: justify;\">\u06af\u0641\u062a\u0646\u06cc \u0627\u0633\u062a \u0628\u0633\u062a\u0647 \u0647\u0627\u06cc MariaDB \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0644\u0627\u0632\u0645 \u0628\u0627 \u0628\u0633\u062a\u0647 \u0647\u0627 \u0648 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc MySQL \u0631\u0627 \u062f\u0627\u0631\u0627 \u0645\u06cc \u0628\u0627\u0634\u0646\u062f \u0645\u06af\u0631 \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0631\u062f \u06a9\u0647 \u0628\u0633\u062a\u0647 \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u0638\u0631 \u062a\u0648\u0633\u0639\u0647 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.\u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631 \u062f\u0631 \u0627\u06cc\u0646 \u0632\u0645\u06cc\u0646\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062c\u0639\u0647 \u0646\u0645\u0627\u06cc\u06cc\u062f \u0648 \u0628\u0631\u0627\u06cc \u062f\u06cc\u062f\u0646 \u062a\u0641\u0627\u0648\u062a \u0647\u0627\u06cc \u0627\u0635\u0644\u06cc \u0628\u06cc\u0646 MariaDB \u0648 MySQL \u0628\u0647 \u0627\u06cc\u0646\u062c\u0627 \u0648 \u0628\u0631\u0627\u06cc \u0633\u0627\u0632\u06af\u0627\u0631\u06cc \u0628\u06cc\u0646 \u0622\u0646\u0647\u0627 \u0628\u0647 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<p style=\"text-align: justify;\">\u0628\u0647 \u0647\u0631 \u062d\u0627\u0644 \u0627\u06cc\u0646 \u0686\u0646\u06cc\u0646 \u062d\u0631\u06a9\u062a \u0647\u0627\u06cc\u06cc \u0627\u0632 \u0633\u0648\u06cc \u0641\u062f\u0648\u0631\u0627 \u062f\u0648\u0631 \u0627\u0632 \u0627\u0646\u062a\u0638\u0627\u0631 \u0646\u06cc\u0633\u062a \u0686\u0631\u0627 \u06a9\u0647 \u0641\u062f\u0648\u0631\u0627 \u06cc\u06a9 \u062a\u0648\u0632\u06cc\u0639 \u067e\u06cc\u0634\u0631\u0648 \u0645\u06cc \u0628\u0627\u0634\u062f \u0648 \u0647\u0645\u06cc\u0634\u0647 \u0628\u0631 \u0644\u0628\u0647 \u06cc \u0641\u0646\u0627\u0648\u0631\u06cc \u062d\u0631\u06a9\u062a \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;19912&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;\\u0628\\u0647 \\u0627\\u06cc\\u0646 \\u0645\\u0637\\u0644\\u0628 \\u0627\\u0645\\u062a\\u06cc\\u0627\\u0632 \\u062f\\u0647\\u06cc\\u062f post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 \\u0627\\u0645\\u062a\\u06cc\\u0627\\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\\u0641\\u06cc\\u0644\\u0645 \\u0622\\u0645\\u0648\\u0632\\u0634 \\u0645\\u0628\\u0627\\u062d\\u062b \\u067e\\u06cc\\u0634\\u0631\\u0641\\u062a\\u0647 \\u062f\\u0631 MySQL \\u0648 MariaDB&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">\u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0645\u062a\u06cc\u0627\u0632 \u062f\u0647\u06cc\u062f post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0633\u0644\u0627\u0645 \u0648 \u0639\u0631\u0636 \u0627\u062f\u0628. \u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645. \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062a\u0635\u0648\u06cc\u0631\u06cc \u0628\u0627 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0622\u0634\u0646\u0627 \u0645\u06cc \u0634\u0648\u06cc\u062f. MySQL \u0648 MariaDB \u062f\u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u0647\u0633\u062a\u0646\u062f. [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":19913,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12623,9753,172],"tags":[12624,12630,12629,4824,12626,7784,12640,12639,12634,12636,12625,12632,12638,12637,12633,12628,12627,12631,12635],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v20.12) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB - \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646<\/title>\n<meta name=\"description\" content=\"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\" \/>\n<meta property=\"og:locale\" content=\"fa_IR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB\" \/>\n<meta property=\"og:description\" content=\"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\" \/>\n<meta property=\"og:site_name\" content=\"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc - \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sourcebaran\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-04T14:50:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-24T08:58:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"704\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc\" \/>\n<meta name=\"twitter:label1\" content=\"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u062f\u0642\u06cc\u0642\u0647\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\"},\"author\":{\"name\":\"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc\",\"@id\":\"https:\/\/www.sourcebaran.com\/#\/schema\/person\/67435619ffcd527d1690364c320cf04e\"},\"headline\":\"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB\",\"datePublished\":\"2016-11-04T14:50:26+00:00\",\"dateModified\":\"2021-07-24T08:58:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\"},\"wordCount\":75,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.sourcebaran.com\/#organization\"},\"keywords\":[\"MariaDB\",\"MariaDB \u0686\u06af\u0648\u0646\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f\u061f\",\"MariaDB \u0686\u06cc\u0633\u062a\u061f\",\"mysql\",\"\u0622\u0645\u0648\u0632\u0634 MariaDB\",\"\u0622\u0645\u0648\u0632\u0634 MySQL\",\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MariaDB\",\"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MySQL\",\"\u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 Sphinx\",\"\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc HandlerSocket\",\"\u062a\u0641\u0627\u0648\u062a MySQL \u0648 MariaDB\",\"\u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc Sphinx\",\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MariaDB\",\"\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MySQL\",\"\u06a9\u0627\u0631 \u0628\u0627 NoSQL\",\"\u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MariaDB\",\"\u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL\",\"\u0646\u062d\u0648\u0647 \u06cc \u0627\u062f\u063a\u0627\u0645 \u0633\u0631\u0648\u0631\",\"\u0646\u0635\u0628 \u0627\u0641\u0632\u0648\u0646\u0647 HandlerSocket\"],\"articleSection\":[\"MariaDB\",\"Mysql\",\"\u0641\u06cc\u0644\u0645 \u0647\u0627\u06cc \u0622\u0645\u0648\u0632\u0634\u06cc\"],\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\",\"url\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\",\"name\":\"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB - \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\",\"isPartOf\":{\"@id\":\"https:\/\/www.sourcebaran.com\/#website\"},\"datePublished\":\"2016-11-04T14:50:26+00:00\",\"dateModified\":\"2021-07-24T08:58:53+00:00\",\"description\":\"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.\",\"breadcrumb\":{\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#breadcrumb\"},\"inLanguage\":\"fa-IR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u062e\u0627\u0646\u0647\",\"item\":\"https:\/\/www.sourcebaran.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sourcebaran.com\/#website\",\"url\":\"https:\/\/www.sourcebaran.com\/\",\"name\":\"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc - \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\",\"description\":\"\u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\",\"publisher\":{\"@id\":\"https:\/\/www.sourcebaran.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sourcebaran.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fa-IR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sourcebaran.com\/#organization\",\"name\":\"\u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\",\"url\":\"https:\/\/www.sourcebaran.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/www.sourcebaran.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2019\/10\/HeaderLogo.png\",\"contentUrl\":\"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2019\/10\/HeaderLogo.png\",\"width\":300,\"height\":90,\"caption\":\"\u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646\"},\"image\":{\"@id\":\"https:\/\/www.sourcebaran.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/sourcebaran\",\"http:\/\/instagram.com\/sourcebaran\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sourcebaran.com\/#\/schema\/person\/67435619ffcd527d1690364c320cf04e\",\"name\":\"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fa-IR\",\"@id\":\"https:\/\/www.sourcebaran.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70ee3e5ba3da8e8c58dc1729ab5282eb?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70ee3e5ba3da8e8c58dc1729ab5282eb?s=96&d=mm&r=g\",\"caption\":\"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB - \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","description":"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html","og_locale":"fa_IR","og_type":"article","og_title":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB","og_description":"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.","og_url":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html","og_site_name":"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc - \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","article_publisher":"https:\/\/www.facebook.com\/sourcebaran","article_published_time":"2016-11-04T14:50:26+00:00","article_modified_time":"2021-07-24T08:58:53+00:00","og_image":[{"width":704,"height":346,"url":"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2016\/11\/MySQL-and-MariaDB.jpg","type":"image\/jpeg"}],"author":"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc","twitter_misc":{"\u0646\u0648\u0634\u062a\u0647\u200c\u0634\u062f\u0647 \u0628\u062f\u0633\u062a":"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc","\u0632\u0645\u0627\u0646 \u062a\u0642\u0631\u06cc\u0628\u06cc \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646":"2 \u062f\u0642\u06cc\u0642\u0647"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#article","isPartOf":{"@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html"},"author":{"name":"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc","@id":"https:\/\/www.sourcebaran.com\/#\/schema\/person\/67435619ffcd527d1690364c320cf04e"},"headline":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB","datePublished":"2016-11-04T14:50:26+00:00","dateModified":"2021-07-24T08:58:53+00:00","mainEntityOfPage":{"@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html"},"wordCount":75,"commentCount":0,"publisher":{"@id":"https:\/\/www.sourcebaran.com\/#organization"},"keywords":["MariaDB","MariaDB \u0686\u06af\u0648\u0646\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f\u061f","MariaDB \u0686\u06cc\u0633\u062a\u061f","mysql","\u0622\u0645\u0648\u0632\u0634 MariaDB","\u0622\u0645\u0648\u0632\u0634 MySQL","\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MariaDB","\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 GIS \u062f\u0631 MySQL","\u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 Sphinx","\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc HandlerSocket","\u062a\u0641\u0627\u0648\u062a MySQL \u0648 MariaDB","\u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc Sphinx","\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MariaDB","\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc GTIDs \u062f\u0631 MySQL","\u06a9\u0627\u0631 \u0628\u0627 NoSQL","\u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MariaDB","\u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL","\u0646\u062d\u0648\u0647 \u06cc \u0627\u062f\u063a\u0627\u0645 \u0633\u0631\u0648\u0631","\u0646\u0635\u0628 \u0627\u0641\u0632\u0648\u0646\u0647 HandlerSocket"],"articleSection":["MariaDB","Mysql","\u0641\u06cc\u0644\u0645 \u0647\u0627\u06cc \u0622\u0645\u0648\u0632\u0634\u06cc"],"inLanguage":"fa-IR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html","url":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html","name":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB - \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","isPartOf":{"@id":"https:\/\/www.sourcebaran.com\/#website"},"datePublished":"2016-11-04T14:50:26+00:00","dateModified":"2021-07-24T08:58:53+00:00","description":"\u062a\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0627\u0632 \u0648\u0628 \u0633\u0627\u06cc\u062a \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646 \u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB \u0628\u0647 \u0632\u0628\u0627\u0646 \u0627\u0635\u0644\u06cc \u0631\u0648 \u0628\u0631\u0627\u062a\u0648\u0646 \u062c\u0647\u062a \u062f\u0627\u0646\u0644\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645.","breadcrumb":{"@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#breadcrumb"},"inLanguage":"fa-IR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/www.sourcebaran.com\/advanced-mysql-and-mariadb.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u062e\u0627\u0646\u0647","item":"https:\/\/www.sourcebaran.com\/"},{"@type":"ListItem","position":2,"name":"\u0641\u06cc\u0644\u0645 \u0622\u0645\u0648\u0632\u0634 \u0645\u0628\u0627\u062d\u062b \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u062f\u0631 MySQL \u0648 MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.sourcebaran.com\/#website","url":"https:\/\/www.sourcebaran.com\/","name":"\u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc - \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","description":"\u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0628\u0627 \u0637\u0639\u0645 \u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","publisher":{"@id":"https:\/\/www.sourcebaran.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sourcebaran.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fa-IR"},{"@type":"Organization","@id":"https:\/\/www.sourcebaran.com\/#organization","name":"\u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646","url":"https:\/\/www.sourcebaran.com\/","logo":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/www.sourcebaran.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2019\/10\/HeaderLogo.png","contentUrl":"https:\/\/www.sourcebaran.com\/wp-content\/uploads\/2019\/10\/HeaderLogo.png","width":300,"height":90,"caption":"\u0633\u0648\u0631\u0633 \u0628\u0627\u0631\u0627\u0646"},"image":{"@id":"https:\/\/www.sourcebaran.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/sourcebaran","http:\/\/instagram.com\/sourcebaran"]},{"@type":"Person","@id":"https:\/\/www.sourcebaran.com\/#\/schema\/person\/67435619ffcd527d1690364c320cf04e","name":"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc","image":{"@type":"ImageObject","inLanguage":"fa-IR","@id":"https:\/\/www.sourcebaran.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/70ee3e5ba3da8e8c58dc1729ab5282eb?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70ee3e5ba3da8e8c58dc1729ab5282eb?s=96&d=mm&r=g","caption":"\u0635\u0627\u0628\u0631 \u0628\u0648\u0633\u062a\u0627\u0646\u06cc"}}]}},"views":2691,"_links":{"self":[{"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/posts\/19912"}],"collection":[{"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/comments?post=19912"}],"version-history":[{"count":4,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/posts\/19912\/revisions"}],"predecessor-version":[{"id":19918,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/posts\/19912\/revisions\/19918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/media\/19913"}],"wp:attachment":[{"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/media?parent=19912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/categories?post=19912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sourcebaran.com\/wp-json\/wp\/v2\/tags?post=19912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}