)]}'
{"doc/high-availability-guide/ha_aa_db/section_mysql_galera.xml":[{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"c9f6b9b36a2c2a52df57e0ce9e0863e4e41d9f78","unresolved":false,"context_lines":[{"line_number":112,"context_line":"    \u003c/screen\u003e"},{"line_number":113,"context_line":"    \u003cpara\u003e"},{"line_number":114,"context_line":"    copy from the primary database server the \u003cfilename\u003edebian.cnf\u003c/filename\u003e to all other servers. Make sure you have SSH root access on the other servers."},{"line_number":115,"context_line":"    \u003c/para\u003e"},{"line_number":116,"context_line":"    \u003cscreen\u003e"},{"line_number":117,"context_line":"        \u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003escp /etc/mysql/debian.cnf root@IP-address:/etc/mysql\u003c/userinput\u003e"},{"line_number":118,"context_line":"    \u003c/screen\u003e"}],"source_content_type":"application/xml","patch_set":9,"id":"ba7be1f8_a97c72b6","line":115,"updated":"2015-02-24 16:57:21.000000000","message":"Change the order as you must make sure you have ssh access first.\n\nMake sure you have SSH root access on the other servers.\n\nFrom the primary database server, copy the ...","commit_id":"87bcfb93580f6d9a3e8a87bed8b79b33520f2044"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"c9f6b9b36a2c2a52df57e0ce9e0863e4e41d9f78","unresolved":false,"context_lines":[{"line_number":116,"context_line":"    \u003cscreen\u003e"},{"line_number":117,"context_line":"        \u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003escp /etc/mysql/debian.cnf root@IP-address:/etc/mysql\u003c/userinput\u003e"},{"line_number":118,"context_line":"    \u003c/screen\u003e"},{"line_number":119,"context_line":"    \u003cpara\u003eafter the copy make sure that all files are the same, you can do this by using the following command\u003c/para\u003e"},{"line_number":120,"context_line":"    \u003cscreen\u003e"},{"line_number":121,"context_line":"        \u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003emd5sum debian.cnf\u003c/userinput\u003e"},{"line_number":122,"context_line":"    \u003c/screen\u003e"}],"source_content_type":"application/xml","patch_set":9,"id":"ba7be1f8_c91a867c","line":119,"updated":"2015-02-24 16:57:21.000000000","message":"After\n\nend with a colon:","commit_id":"87bcfb93580f6d9a3e8a87bed8b79b33520f2044"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"c9f6b9b36a2c2a52df57e0ce9e0863e4e41d9f78","unresolved":false,"context_lines":[{"line_number":122,"context_line":"    \u003c/screen\u003e"},{"line_number":123,"context_line":"  \u003cpara\u003eGet from the file the database password this can be done via:\u003c/para\u003e"},{"line_number":124,"context_line":"    \u003cscreen\u003e"},{"line_number":125,"context_line":"        \u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003ecat /etc/mysql/debian.cnf\u003c/userinput\u003e"},{"line_number":126,"context_line":"    \u003c/screen\u003e"},{"line_number":127,"context_line":"  \u003cpara\u003eThe result will look like this:\u003c/para\u003e"},{"line_number":128,"context_line":"  \u003cscreen\u003e\u003ccomputeroutput\u003e[client]"}],"source_content_type":"application/xml","patch_set":9,"id":"ba7be1f8_242427ae","line":125,"updated":"2015-02-24 16:57:21.000000000","message":"We don\u0027t use via in our Conventions, I\u0027d revise as:\n\nFrom the \u003cfilename\u003edebian.cnf\u003c/filename\u003e get the database password:","commit_id":"87bcfb93580f6d9a3e8a87bed8b79b33520f2044"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"c9f6b9b36a2c2a52df57e0ce9e0863e4e41d9f78","unresolved":false,"context_lines":[{"line_number":138,"context_line":"basedir \u003d /usr"},{"line_number":139,"context_line":"\u003c/computeroutput\u003e\u003c/screen\u003e"},{"line_number":140,"context_line":"\u003cpara\u003e"},{"line_number":141,"context_line":"Run the following query on every server except the primary node this will make sure that you can restart the database again. Do not forget to add the password from the debian.cnf."},{"line_number":142,"context_line":"\u003c/para\u003e"},{"line_number":143,"context_line":"    \u003cscreen\u003e\u003cprompt\u003emysql\u0026gt;\u003c/prompt\u003e \u003cuserinput\u003eGRANT SHUTDOWN ON *.* TO ‘debian-sys-maint’@’localhost\u0027 IDENTIFIED BY \u0027\u0026lt;debian.cnf password\u0026gt;\u0027;\u003c/userinput\u003e"},{"line_number":144,"context_line":"\u003cprompt\u003emysql\u0026gt;\u003c/prompt\u003e\u003cuserinput\u003eGRANT SELECT ON `mysql`.`user` TO ‘debian-sys-maint’@’localhost\u0027 IDENTIFIED BY \u0027\u0026lt;debian.cnf password\u0026gt;\u0027;\u003c/userinput\u003e\u003c/screen\u003e"}],"source_content_type":"application/xml","patch_set":9,"id":"ba7be1f8_245b472f","line":141,"updated":"2015-02-24 16:57:21.000000000","message":"\u003cfilename\u003e","commit_id":"87bcfb93580f6d9a3e8a87bed8b79b33520f2044"},{"author":{"_account_id":7923,"name":"Gauvain Pocentek","email":"gauvainpocentek@gmail.com","username":"gpocentek"},"change_message_id":"4334b9c0814a78094115e4479462994674cb3a93","unresolved":false,"context_lines":[{"line_number":48,"context_line":"    \u003c/listitem\u003e"},{"line_number":49,"context_line":"    \u003clistitem\u003e"},{"line_number":50,"context_line":"    \u003cpara\u003eAdjust the configuration:\u003c/para\u003e"},{"line_number":51,"context_line":"        \u003cpara\u003eIn the \u003cfilename\u003emy.conf\u003c/filename\u003e file, make the following changes:\u003c/para\u003e"},{"line_number":52,"context_line":"    \u003cprogramlisting language\u003d\"ini\"\u003equery_cache_size\u003d0"},{"line_number":53,"context_line":"binlog_format\u003dROW"},{"line_number":54,"context_line":"default_storage_engine\u003dinnodb"}],"source_content_type":"application/xml","patch_set":12,"id":"ba7be1f8_1e568bce","line":51,"updated":"2015-03-03 06:13:48.000000000","message":"I know this is not part of your patch, but we should give the absolute path (/etc/mysql/my.cnf).","commit_id":"9e36b9c9baecebde788a7866109d8d31cc223dbb"},{"author":{"_account_id":7923,"name":"Gauvain Pocentek","email":"gauvainpocentek@gmail.com","username":"gpocentek"},"change_message_id":"4334b9c0814a78094115e4479462994674cb3a93","unresolved":false,"context_lines":[{"line_number":57,"context_line":"    \u003c/listitem\u003e"},{"line_number":58,"context_line":"    \u003clistitem\u003e"},{"line_number":59,"context_line":"        \u003cpara\u003e"},{"line_number":60,"context_line":"            Create the \u003cfilename\u003e/etc/mysql/conf.d/wsrep.cnf\u003c/filename\u003e."},{"line_number":61,"context_line":"        \u003c/para\u003e"},{"line_number":62,"context_line":""},{"line_number":63,"context_line":"        \u003cpara\u003ePaste the following lines in this file:\u003c/para\u003e"}],"source_content_type":"application/xml","patch_set":12,"id":"ba7be1f8_7e494730","line":60,"updated":"2015-03-03 06:13:48.000000000","message":"Missing \"file\" at the end of the sentence.","commit_id":"9e36b9c9baecebde788a7866109d8d31cc223dbb"},{"author":{"_account_id":7923,"name":"Gauvain Pocentek","email":"gauvainpocentek@gmail.com","username":"gpocentek"},"change_message_id":"4334b9c0814a78094115e4479462994674cb3a93","unresolved":false,"context_lines":[{"line_number":65,"context_line":"wsrep_provider\u003d/usr/lib/galera/libgalera_smm.so"},{"line_number":66,"context_line":"wsrep_cluster_name\u003d\"Openstack\""},{"line_number":67,"context_line":"wsrep_sst_auth\u003dwsrep_sst:wspass"},{"line_number":68,"context_line":"wsrep_cluster_address\u003d\"gcomm://\u003creplaceable\u003ePRIMARY_NODE_IP\u003c/replaceable\u003e, gcomm://\u003creplaceable\u003eSECONDARY_NODE_IP\u003c/replaceable\u003e\""},{"line_number":69,"context_line":"wsrep_sst_method\u003drsync"},{"line_number":70,"context_line":"wsrep_node_address\u003d\"\u003creplaceable\u003ePRIMARY_NODE_IP\u003c/replaceable\u003e\""},{"line_number":71,"context_line":"wsrep_node_name\u003d\"\u003creplaceable\u003eNODE_NAME\u003c/replaceable\u003e\""}],"source_content_type":"application/xml","patch_set":12,"id":"ba7be1f8_3e126f09","line":68,"updated":"2015-03-03 06:13:48.000000000","message":"This should be:\n\nwsrep_cluster_address\u003d\"gcomm://\u003creplaceable\u003ePRIMARY_NODE_IP\u003c/replaceable\u003e,\u003creplaceable\u003eSECONDARY_NODE_IP\u003c/replaceable\u003e\"\n\n(gcomm:// should appear only once)","commit_id":"9e36b9c9baecebde788a7866109d8d31cc223dbb"},{"author":{"_account_id":7923,"name":"Gauvain Pocentek","email":"gauvainpocentek@gmail.com","username":"gpocentek"},"change_message_id":"4334b9c0814a78094115e4479462994674cb3a93","unresolved":false,"context_lines":[{"line_number":138,"context_line":"basedir \u003d /usr"},{"line_number":139,"context_line":"\u003c/computeroutput\u003e\u003c/screen\u003e"},{"line_number":140,"context_line":"\u003cpara\u003e"},{"line_number":141,"context_line":"Run the following query on every server except the primary node this will make sure that you can restart the database again."},{"line_number":142,"context_line":"Do not forget to add the password from the \u003cfilename\u003edebian.cnf\u003c/filename\u003e."},{"line_number":143,"context_line":"\u003c/para\u003e"},{"line_number":144,"context_line":"    \u003cscreen\u003e\u003cprompt\u003emysql\u0026gt;\u003c/prompt\u003e \u003cuserinput\u003eGRANT SHUTDOWN ON *.* TO ‘debian-sys-maint’@’localhost\u0027 IDENTIFIED BY \u0027\u0026lt;debian.cnf password\u0026gt;\u0027;\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":12,"id":"ba7be1f8_9e00bbac","line":141,"updated":"2015-03-03 06:13:48.000000000","message":"\"Run the following query on every server except the primary node. This will make sure...\"","commit_id":"9e36b9c9baecebde788a7866109d8d31cc223dbb"}]}