https://shiyoka.com/ 2026-05-08T14:29:14+00:00 https://shiyoka.com/ https://shiyoka.com/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-02-16T13:53:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://shiyoka.com/doku.php?id=mariadb:cluseter&rev=1739713984&do=diff Cluster <http://db-engines.com/en/system/MariaDB%3BMySQL%3BPercona+Server> GALERA CLUSTER <http://galeracluster.com/products/> " Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication. Galera Cluster is an easy-to-use, high-availability solution, which provides high system uptime, no data loss and scalability for future growth. text/html 2025-02-16T13:53:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://shiyoka.com/doku.php?id=mariadb:galera&rev=1739713984&do=diff MariaDB Galera Cluster <http://www.codership.com/wiki/doku.php?id=Galera%20Wiki> <https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/> Install Adding the MariaDB YUM Repository # vi /etc/yum.repos.d/MariaDB.repo MariaDB 10.0 CentOS repository list [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/centos6-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 text/html 2025-02-16T13:53:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://shiyoka.com/doku.php?id=mariadb:samplecnf&rev=1739713984&do=diff server.cnfのsample MariaDB Galera Cluster の server.cnf のサンプル # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] ##----------------- Daemon -----------------## pid-file = /var/lib/mysql/mysql.pid socket =… text/html 2025-02-16T13:53:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://shiyoka.com/doku.php?id=mariadb:version&rev=1739713984&do=diff 5.5 or 10 " MariaDBには5.5系と10系の2つのバージョンが存在します。もともとMySQLと互換を目指して構築されており、MariaDB 5.5はMySQL5.5を元に独自機能の追加や安定性確保のための多くの改善が取り入れられているバージョンです。設定ファイルの書式なども含めて、利用者側からみた機能の違いは軽微で、ほぼ互換性を有しています。さらにMyISAMやInnoDBなどのMySQL標準のストレージエンジンに加え、XtraDB, Ariaなどのストレージエンジンも利用可能になっています。…