)]}'
{"doc/high-availability-guide/ha_aa_db/section_mariadb_galera_rh.xml":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"0ceef516e9a21fd051727c4da8fffa7ada413e71","unresolved":false,"context_lines":[{"line_number":5,"context_line":"  version\u003d\"5.0\""},{"line_number":6,"context_line":"  xml:id\u003d\"ha-aa-db-mariadb-galera-rh\"\u003e"},{"line_number":7,"context_line":"  \u003ctitle\u003eMariaDB with Galera (Red Hat-based platforms)\u003c/title\u003e"},{"line_number":8,"context_line":"  \u003cpara\u003eMariaDB with Galera provides synchronous database replication, in an"},{"line_number":9,"context_line":"    active-active, multi-master environment. High availability for the data"},{"line_number":10,"context_line":"    itself is managed internally by Galera, while access availability will be"},{"line_number":11,"context_line":"    managed by HAProxy.\u003c/para\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"9aa53dc9_383e98da","line":8,"updated":"2015-04-09 08:41:51.000000000","message":"The comma after \"replication\" is not necessary.","commit_id":"f71d7a97a68fd12760c1b78c1c5f7e282e6862a1"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"0ceef516e9a21fd051727c4da8fffa7ada413e71","unresolved":false,"context_lines":[{"line_number":9,"context_line":"    active-active, multi-master environment. High availability for the data"},{"line_number":10,"context_line":"    itself is managed internally by Galera, while access availability will be"},{"line_number":11,"context_line":"    managed by HAProxy.\u003c/para\u003e"},{"line_number":12,"context_line":"  \u003cpara\u003eThis guide will assume that three nodes are used to form the MariaDB"},{"line_number":13,"context_line":"    Galera cluster. Unless otherwise specified, all commands need to be"},{"line_number":14,"context_line":"    executed on all cluster nodes.\u003c/para\u003e"},{"line_number":15,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"9aa53dc9_1b162e4c","line":12,"updated":"2015-04-09 08:41:51.000000000","message":"will assume --\u003e assumes","commit_id":"f71d7a97a68fd12760c1b78c1c5f7e282e6862a1"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"0ceef516e9a21fd051727c4da8fffa7ada413e71","unresolved":false,"context_lines":[{"line_number":29,"context_line":"      \u003cpara\u003eIf HAProxy is used to load-balance client access to MariaDB,"},{"line_number":30,"context_line":"        as described in \u003clink linkend\u003d\"ha-aa-haproxy\"\u003ethe HAProxy section\u003c/link\u003e"},{"line_number":31,"context_line":"        of this document, you can use the \u003capplication\u003eclustercheck\u003c/application\u003e utility"},{"line_number":32,"context_line":"        to improve health checks. This requires some commands to be executed."},{"line_number":33,"context_line":"    \u003c/para\u003e"},{"line_number":34,"context_line":"        \u003cpara\u003e"},{"line_number":35,"context_line":"\u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003ecat \u003e /etc/sysconfig/clustercheck \u0026lt;\u0026lt; EOF"}],"source_content_type":"application/xml","patch_set":2,"id":"9aa53dc9_9b60fea6","line":32,"updated":"2015-04-09 08:41:51.000000000","message":"Please put a colon instead of the dot.\n\nAnd I would write: This requires the following commands to be executed:","commit_id":"f71d7a97a68fd12760c1b78c1c5f7e282e6862a1"},{"author":{"_account_id":14962,"name":"ologvinova","email":"ologvinova@mirantis.com","username":"ologvinova"},"change_message_id":"4a70dff74de6ee9d9c34c74e1b1fddda825b1ab4","unresolved":false,"context_lines":[{"line_number":26,"context_line":"  \u003corderedlist numeration\u003d\"arabic\" inheritnum\u003d\"ignore\" continuation\u003d\"restarts\"\u003e"},{"line_number":27,"context_line":"    \u003ctitle\u003eConfiguring the clustercheck utility:\u003c/title\u003e"},{"line_number":28,"context_line":"   \u003clistitem\u003e"},{"line_number":29,"context_line":"      \u003cpara\u003eIf HAProxy is used to load-balance client access to MariaDB,"},{"line_number":30,"context_line":"        as described in \u003clink linkend\u003d\"ha-aa-haproxy\"\u003ethe HAProxy section\u003c/link\u003e"},{"line_number":31,"context_line":"        of this document, you can use the \u003capplication\u003eclustercheck\u003c/application\u003e utility"},{"line_number":32,"context_line":"        to improve health checks, which requires the following commands to be executed:"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_ff3ea489","line":29,"updated":"2015-04-10 11:12:16.000000000","message":"Is \u0027load-balance\u0027 used as a verb here?","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":14962,"name":"ologvinova","email":"ologvinova@mirantis.com","username":"ologvinova"},"change_message_id":"a2904a4f94469ab218964477ac963ed45b3ef891","unresolved":false,"context_lines":[{"line_number":26,"context_line":"  \u003corderedlist numeration\u003d\"arabic\" inheritnum\u003d\"ignore\" continuation\u003d\"restarts\"\u003e"},{"line_number":27,"context_line":"    \u003ctitle\u003eConfiguring the clustercheck utility:\u003c/title\u003e"},{"line_number":28,"context_line":"   \u003clistitem\u003e"},{"line_number":29,"context_line":"      \u003cpara\u003eIf HAProxy is used to load-balance client access to MariaDB,"},{"line_number":30,"context_line":"        as described in \u003clink linkend\u003d\"ha-aa-haproxy\"\u003ethe HAProxy section\u003c/link\u003e"},{"line_number":31,"context_line":"        of this document, you can use the \u003capplication\u003eclustercheck\u003c/application\u003e utility"},{"line_number":32,"context_line":"        to improve health checks, which requires the following commands to be executed:"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_fa6b52b7","line":29,"in_reply_to":"9aa53dc9_bf793cca","updated":"2015-04-10 11:36:05.000000000","message":"If its a verb, all is good, as for me! \u003d)","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":13294,"name":"Javier Peña","email":"jpena@redhat.com","username":"jpena"},"change_message_id":"28bbf565cea0dc24dcb3ddd3484cffd10cbc7264","unresolved":false,"context_lines":[{"line_number":26,"context_line":"  \u003corderedlist numeration\u003d\"arabic\" inheritnum\u003d\"ignore\" continuation\u003d\"restarts\"\u003e"},{"line_number":27,"context_line":"    \u003ctitle\u003eConfiguring the clustercheck utility:\u003c/title\u003e"},{"line_number":28,"context_line":"   \u003clistitem\u003e"},{"line_number":29,"context_line":"      \u003cpara\u003eIf HAProxy is used to load-balance client access to MariaDB,"},{"line_number":30,"context_line":"        as described in \u003clink linkend\u003d\"ha-aa-haproxy\"\u003ethe HAProxy section\u003c/link\u003e"},{"line_number":31,"context_line":"        of this document, you can use the \u003capplication\u003eclustercheck\u003c/application\u003e utility"},{"line_number":32,"context_line":"        to improve health checks, which requires the following commands to be executed:"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_bf793cca","line":29,"in_reply_to":"9aa53dc9_ff3ea489","updated":"2015-04-10 11:28:39.000000000","message":"Yes. I\u0027m not 100% sure how gramatically correct it is, but I\u0027ve been using it as a verb for a long time. Any suggestion?","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":14962,"name":"ologvinova","email":"ologvinova@mirantis.com","username":"ologvinova"},"change_message_id":"4a70dff74de6ee9d9c34c74e1b1fddda825b1ab4","unresolved":false,"context_lines":[{"line_number":91,"context_line":"      \u003ctitle\u003eMariaDB with Galera configuration:\u003c/title\u003e"},{"line_number":92,"context_line":"    \u003clistitem\u003e"},{"line_number":93,"context_line":"        \u003cpara\u003e"},{"line_number":94,"context_line":"          Create the Galera configuration file, \u003cfilename\u003e/etc/my.cnf.d/galera.cnf\u003c/filename\u003e,"},{"line_number":95,"context_line":"          with the following contents:"},{"line_number":96,"context_line":"        \u003c/para\u003e"},{"line_number":97,"context_line":"        \u003cprogramlisting language\u003d\"ini\"\u003e[mysqld]"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_7f53b4e2","line":94,"updated":"2015-04-10 11:12:16.000000000","message":"I would remove commas in this sentence, as the name of the file gives us essential information.","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":13294,"name":"Javier Peña","email":"jpena@redhat.com","username":"jpena"},"change_message_id":"28bbf565cea0dc24dcb3ddd3484cffd10cbc7264","unresolved":false,"context_lines":[{"line_number":91,"context_line":"      \u003ctitle\u003eMariaDB with Galera configuration:\u003c/title\u003e"},{"line_number":92,"context_line":"    \u003clistitem\u003e"},{"line_number":93,"context_line":"        \u003cpara\u003e"},{"line_number":94,"context_line":"          Create the Galera configuration file, \u003cfilename\u003e/etc/my.cnf.d/galera.cnf\u003c/filename\u003e,"},{"line_number":95,"context_line":"          with the following contents:"},{"line_number":96,"context_line":"        \u003c/para\u003e"},{"line_number":97,"context_line":"        \u003cprogramlisting language\u003d\"ini\"\u003e[mysqld]"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_7f7f34ab","line":94,"in_reply_to":"9aa53dc9_7f53b4e2","updated":"2015-04-10 11:28:39.000000000","message":"Ok, will do.","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":14962,"name":"ologvinova","email":"ologvinova@mirantis.com","username":"ologvinova"},"change_message_id":"4a70dff74de6ee9d9c34c74e1b1fddda825b1ab4","unresolved":false,"context_lines":[{"line_number":122,"context_line":"    \u003c/listitem\u003e"},{"line_number":123,"context_line":"    \u003clistitem\u003e"},{"line_number":124,"context_line":"        \u003cpara\u003e"},{"line_number":125,"context_line":"          Open firewall ports used for Mariadb and Galera communications:"},{"line_number":126,"context_line":"        \u003c/para\u003e"},{"line_number":127,"context_line":"          \u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003efirewall-cmd --add-service\u003dmysql\u003c/userinput\u003e"},{"line_number":128,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003efirewall-cmd --add-port\u003d4444/tcp\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_ffb10402","line":125,"updated":"2015-04-10 11:12:16.000000000","message":"Mariadb -\u003e MariaDB","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":13294,"name":"Javier Peña","email":"jpena@redhat.com","username":"jpena"},"change_message_id":"28bbf565cea0dc24dcb3ddd3484cffd10cbc7264","unresolved":false,"context_lines":[{"line_number":122,"context_line":"    \u003c/listitem\u003e"},{"line_number":123,"context_line":"    \u003clistitem\u003e"},{"line_number":124,"context_line":"        \u003cpara\u003e"},{"line_number":125,"context_line":"          Open firewall ports used for Mariadb and Galera communications:"},{"line_number":126,"context_line":"        \u003c/para\u003e"},{"line_number":127,"context_line":"          \u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003efirewall-cmd --add-service\u003dmysql\u003c/userinput\u003e"},{"line_number":128,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003efirewall-cmd --add-port\u003d4444/tcp\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":3,"id":"9aa53dc9_5f7c70b4","line":125,"in_reply_to":"9aa53dc9_ffb10402","updated":"2015-04-10 11:28:39.000000000","message":"Good catch! Will fix it right away","commit_id":"91be174e7f156311e3483c02be1727b2e965a8ce"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"250b7421723cdcef1f2a78d4720cce356a437230","unresolved":false,"context_lines":[{"line_number":14,"context_line":"    executed on all cluster nodes.\u003c/para\u003e"},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"  \u003corderedlist numeration\u003d\"arabic\" inheritnum\u003d\"ignore\" continuation\u003d\"restarts\"\u003e"},{"line_number":17,"context_line":"    \u003ctitle\u003eInstalling MariaDB with Galera:\u003c/title\u003e"},{"line_number":18,"context_line":"    \u003clistitem\u003e"},{"line_number":19,"context_line":"        \u003cpara\u003e"},{"line_number":20,"context_line":"Red Hat-based distributions include Galera packages in their repositories. To"}],"source_content_type":"application/xml","patch_set":4,"id":"7aaa499b_3b828553","line":17,"updated":"2015-04-12 07:47:23.000000000","message":"These lists should be a single procedure.","commit_id":"099d05fd2089007b4ad74d23c94c0dde19b66ad2"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"250b7421723cdcef1f2a78d4720cce356a437230","unresolved":false,"context_lines":[{"line_number":29,"context_line":"      \u003cpara\u003eIf HAProxy is used to load-balance client access to MariaDB,"},{"line_number":30,"context_line":"        as described in \u003clink linkend\u003d\"ha-aa-haproxy\"\u003ethe HAProxy section\u003c/link\u003e"},{"line_number":31,"context_line":"        of this document, you can use the \u003capplication\u003eclustercheck\u003c/application\u003e utility"},{"line_number":32,"context_line":"        to improve health checks, which requires the following commands to be executed:"},{"line_number":33,"context_line":"    \u003c/para\u003e"},{"line_number":34,"context_line":"        \u003cpara\u003e"},{"line_number":35,"context_line":"\u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003ecat \u003e /etc/sysconfig/clustercheck \u0026lt;\u0026lt; EOF"}],"source_content_type":"application/xml","patch_set":4,"id":"7aaa499b_fb7bfd79","line":32,"updated":"2015-04-12 07:47:23.000000000","message":"I would reword this as: Create the clustercheck file with the following content - and let the admin choose whatever means they want.","commit_id":"099d05fd2089007b4ad74d23c94c0dde19b66ad2"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"250b7421723cdcef1f2a78d4720cce356a437230","unresolved":false,"context_lines":[{"line_number":34,"context_line":"        \u003cpara\u003e"},{"line_number":35,"context_line":"\u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003ecat \u003e /etc/sysconfig/clustercheck \u0026lt;\u0026lt; EOF"},{"line_number":36,"context_line":"\u0026gt;MYSQL_USERNAME\u003d\"clustercheck\""},{"line_number":37,"context_line":"\u0026gt;MYSQL_PASSWORD\u003d\"password\""},{"line_number":38,"context_line":"\u0026gt;MYSQL_HOST\u003d\"localhost\""},{"line_number":39,"context_line":"\u0026gt;MYSQL_PORT\u003d\"3306\""},{"line_number":40,"context_line":"\u0026gt;EOF\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":4,"id":"7aaa499b_db804149","line":37,"updated":"2015-04-12 07:47:23.000000000","message":"Use \u003creplaceable\u003ePASSWORD\u003c/replaceable\u003e","commit_id":"099d05fd2089007b4ad74d23c94c0dde19b66ad2"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"250b7421723cdcef1f2a78d4720cce356a437230","unresolved":false,"context_lines":[{"line_number":49,"context_line":"    \u003clistitem\u003e"},{"line_number":50,"context_line":"    \u003cpara\u003eConfigure monitor service (used by HAProxy):\u003c/para\u003e"},{"line_number":51,"context_line":"        \u003cpara\u003e"},{"line_number":52,"context_line":"          \u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003ecat \u003e /etc/xinetd.d/galera-monitor \u0026lt;\u0026lt; EOF"},{"line_number":53,"context_line":"\u0026gt;service galera-monitor"},{"line_number":54,"context_line":"\u0026gt;{"},{"line_number":55,"context_line":"\u0026gt;  port \u003d 9200"}],"source_content_type":"application/xml","patch_set":4,"id":"7aaa499b_9b93d9a3","line":52,"updated":"2015-04-12 07:47:23.000000000","message":"Like above","commit_id":"099d05fd2089007b4ad74d23c94c0dde19b66ad2"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"250b7421723cdcef1f2a78d4720cce356a437230","unresolved":false,"context_lines":[{"line_number":75,"context_line":"          Create the database user required by clustercheck:"},{"line_number":76,"context_line":"        \u003c/para\u003e"},{"line_number":77,"context_line":"          \u003cscreen\u003e\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003esystemctl start mysqld\u003c/userinput\u003e"},{"line_number":78,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003emysql -e \"CREATE USER \u0027clustercheck\u0027@\u0027localhost\u0027 IDENTIFIED BY \u0027password\u0027;\"\u003c/userinput\u003e"},{"line_number":79,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003esystemctl stop mysqld\u003c/userinput\u003e\u003c/screen\u003e"},{"line_number":80,"context_line":"    \u003c/listitem\u003e"},{"line_number":81,"context_line":"    \u003clistitem\u003e"}],"source_content_type":"application/xml","patch_set":4,"id":"7aaa499b_5b8d517a","line":78,"updated":"2015-04-12 07:47:23.000000000","message":"\u003creplaceable\u003ePASSWORD\u003c/","commit_id":"099d05fd2089007b4ad74d23c94c0dde19b66ad2"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"e385b1bea2db067ed9a599db3d35bce9eb64a58c","unresolved":false,"context_lines":[{"line_number":34,"context_line":"             \u003cpara\u003eCreate file \u003cfilename\u003eetc/sysconfig/clustercheck\u003c/filename\u003e"},{"line_number":35,"context_line":"               with the following contents:"},{"line_number":36,"context_line":"             \u003c/para\u003e"},{"line_number":37,"context_line":"             \u003cpara\u003e"},{"line_number":38,"context_line":"               \u003cprogramlisting language\u003d\"ini\"\u003eMYSQL_USERNAME\u003d\"clustercheck\""},{"line_number":39,"context_line":"MYSQL_PASSWORD\u003d\u003creplaceable\u003ePASSWORD\u003c/replaceable\u003e"},{"line_number":40,"context_line":"MYSQL_HOST\u003d\"localhost\""}],"source_content_type":"application/xml","patch_set":6,"id":"7aaa499b_b718d685","line":37,"updated":"2015-04-13 11:56:14.000000000","message":"No need to add para around programlisting","commit_id":"53897f8a6493db9f3a25231db1489d06999d9bfe"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"e385b1bea2db067ed9a599db3d35bce9eb64a58c","unresolved":false,"context_lines":[{"line_number":48,"context_line":"             \u003cpara\u003eConfigure monitor service (used by HAProxy):\u003c/para\u003e"},{"line_number":49,"context_line":"             \u003cpara\u003eCreate file \u003cfilename\u003e/etc/xinetd.d/galera-monitor\u003c/filename\u003e"},{"line_number":50,"context_line":"               with the following contents:\u003c/para\u003e"},{"line_number":51,"context_line":"             \u003cpara\u003e"},{"line_number":52,"context_line":"               \u003cprogramlisting language\u003d\"ini\"\u003eservice galera-monitor"},{"line_number":53,"context_line":"{"},{"line_number":54,"context_line":"  port \u003d 9200"}],"source_content_type":"application/xml","patch_set":6,"id":"7aaa499b_77124e64","line":51,"updated":"2015-04-13 11:56:14.000000000","message":"Extra para","commit_id":"53897f8a6493db9f3a25231db1489d06999d9bfe"},{"author":{"_account_id":6547,"name":"Andreas Jaeger","email":"jaegerandi@gmail.com","username":"jaegerandi"},"change_message_id":"69e1a2cb1ac63c7c8184c18b10ac6935eaf5f0fa","unresolved":false,"context_lines":[{"line_number":62,"context_line":"  log_on_success \u003d"},{"line_number":63,"context_line":"  log_on_failure \u003d HOST"},{"line_number":64,"context_line":"  flags \u003d REUSE"},{"line_number":65,"context_line":"}\u003c/programlisting\u003e"},{"line_number":66,"context_line":"             \u003c/para\u003e"},{"line_number":67,"context_line":"           \u003c/step\u003e"},{"line_number":68,"context_line":"           \u003cstep\u003e"}],"source_content_type":"application/xml","patch_set":7,"id":"7aaa499b_c2815b91","line":65,"updated":"2015-04-13 13:57:08.000000000","message":"Remove this one as well so that the gate passes","commit_id":"f6c477e0044d5e5155b4cfe420cfeacf7228c24a"}]}
