)]}'
{"doc/high-availability-guide/ha_aa_db/section_mysql_galera.xml":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"7141e804cd8cae7740edfea7973fc68f05c1b520","unresolved":false,"context_lines":[{"line_number":7,"context_line":""},{"line_number":8,"context_line":"\u003ctitle\u003eGalera Cluster for MySQL\u003c/title\u003e"},{"line_number":9,"context_line":""},{"line_number":10,"context_line":"\u003cpara\u003eGalera Cluster for MySQL is a synchronous replication solution that can improve availability and performance of MySQL service.  All Galera nodes are identical and fully representative of the cluster and allow unconstrained transparent \u003ccode\u003emysql\u003c/code\u003e client access, acting as a single-distributed MySQL server.\u003c/para\u003e"},{"line_number":11,"context_line":""},{"line_number":12,"context_line":"\u003cpara\u003eIt provides:\u003c/para\u003e"},{"line_number":13,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"da86d52c_c9bb560d","line":10,"updated":"2015-02-11 13:03:45.000000000","message":"Looks like you have an extra space here: \"service.  All\" and in few other sentences below.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":14,"context_line":"\u003citemizedlist\u003e"},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"\u003clistitem\u003e"},{"line_number":17,"context_line":"\u003cpara\u003eTransparent client connections, so that it is high compatible with existing applications;\u003c/para\u003e"},{"line_number":18,"context_line":"\u003c/listitem\u003e"},{"line_number":19,"context_line":""},{"line_number":20,"context_line":"\u003clistitem\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_bdf12797","line":17,"updated":"2015-01-04 20:19:55.000000000","message":"highly","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":18,"context_line":"\u003c/listitem\u003e"},{"line_number":19,"context_line":""},{"line_number":20,"context_line":"\u003clistitem\u003e"},{"line_number":21,"context_line":"\u003cpara\u003eSynchronous data safety semantics \u0026#8212; if a client received confirmation, transaction will be committed on every node; and,\u003c/para\u003e"},{"line_number":22,"context_line":"\u003c/listitem\u003e"},{"line_number":23,"context_line":""},{"line_number":24,"context_line":"\u003clistitem\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_ddec33be","line":21,"updated":"2015-01-04 20:19:55.000000000","message":"No spaces before and after an em-dash. https://wiki.openstack.org/wiki/Documentation/Markup_conventions#Emdashes\n\nAlso I\u0027m seeing double spaces after periods. Are you just testing our editing? :) Our books all have single space after period.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":49,"context_line":"\u003citemizedlist\u003e"},{"line_number":50,"context_line":"\u003ctitle\u003eSystem Requirements:\u003c/title\u003e"},{"line_number":51,"context_line":"\u003clistitem\u003e"},{"line_number":52,"context_line":"\u003cpara\u003eServer hardware for a minimum of three nodes;\u003c/para\u003e"},{"line_number":53,"context_line":"\u003c/listitem\u003e"},{"line_number":54,"context_line":"\u003clistitem\u003e"},{"line_number":55,"context_line":"\u003cpara\u003e100 Mbps or better network connectivity;\u003c/para\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_fd2acfe5","line":52,"updated":"2015-01-04 20:19:55.000000000","message":"Semicolons are not our convention. See https://wiki.openstack.org/wiki/Documentation/Conventions and use the links in the second bar to see more details on how to punctuate lists.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":69,"context_line":"\u003c/itemizedlist\u003e"},{"line_number":70,"context_line":""},{"line_number":71,"context_line":"\u003cvariablelist\u003e"},{"line_number":72,"context_line":"\u003ctitle\u003ePreparing the Servers\u003c/title\u003e"},{"line_number":73,"context_line":""},{"line_number":74,"context_line":"\u003cpara\u003eBefore you begin the installation, there are a few tasks you need to perform to prepare the servers for Galera Cluster.  You must perform the following steps for each node in your cluster.\u003c/para\u003e"},{"line_number":75,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_1d2ebbfa","line":72,"updated":"2015-01-04 20:19:55.000000000","message":"Using sentence style for headings: https://wiki.openstack.org/wiki/Documentation/Markup_conventions#Headings","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":96,"context_line":"\u003cvarlistentry\u003e"},{"line_number":97,"context_line":"\u003cterm\u003eFirewall Configuration\u003c/term\u003e"},{"line_number":98,"context_line":"\u003clistitem\u003e"},{"line_number":99,"context_line":"\u003cpara\u003eNext, you will need to change the firewall settings, so that the nodes can communicate with each other and so that you can interact with them.  For instance, if you use \u003ccode\u003eiptables\u003c/code\u003e, complete the following steps:\u003c/para\u003e"},{"line_number":100,"context_line":""},{"line_number":101,"context_line":"\u003cprogramlisting language\u003d\"bash\"\u003e"},{"line_number":102,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003eiptables -I INPUT -p tcp --dport 3306 -j ACCEPT\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_3d353746","line":99,"updated":"2015-01-04 20:19:55.000000000","message":"future tense is longer than necessary. \"Next, you need to change...\"\n\nor even:\n\n\"Next, change the firewall settings so that the ...\"","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":105,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003eiptables -I INPUT -p tcp --dport 4568 -j ACCEPT\u003c/userinput\u003e"},{"line_number":106,"context_line":"\u003c/programlisting\u003e"},{"line_number":107,"context_line":""},{"line_number":108,"context_line":"\u003cpara\u003eOnce this is done, you need to save \u003ccode\u003eiptables\u003c/code\u003e.  If your system uses \u003ccode\u003einit\u003c/code\u003e, run the following command:\u003c/para\u003e"},{"line_number":109,"context_line":""},{"line_number":110,"context_line":"\u003cprogramlisting language\u003d\"bash\"\u003e"},{"line_number":111,"context_line":"\u003cprompt\u003e#\u003c/prompt\u003e \u003cuserinput\u003eservice iptables save\u003c/userinput\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_5d38433d","line":108,"updated":"2015-01-04 20:19:55.000000000","message":"Once these commands complete, save the \u003ccode\u003eiptables\u003c/code\u003e.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":436,"context_line":""},{"line_number":437,"context_line":"\u003clistitem\u003e"},{"line_number":438,"context_line":"\u003corderedlist\u003e"},{"line_number":439,"context_line":"\u003ctitle\u003eEnabling the Debian Repository\u003c/title\u003e"},{"line_number":440,"context_line":""},{"line_number":441,"context_line":"\u003cpara\u003eThe procedure for enabling the Percona repository for Debian-based distributions requires that you first install Software Properties.  The package names many vary depending on your distribution. On Debian, run the following command:\u003c/para\u003e"},{"line_number":442,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_08d118cd","line":439,"updated":"2015-01-04 20:19:55.000000000","message":"Use repository for sentence-style title capitalization.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":473,"context_line":"\u003cpara\u003e\u003ccode\u003e\u003creplaceable\u003erelease\u003c/replaceable\u003e\u003c/code\u003e indicates the release codename for the distribution you are using.  For example, \u003ccode\u003ewheezy\u003c/code\u003e.\u003c/para\u003e"},{"line_number":474,"context_line":""},{"line_number":475,"context_line":"\u003cpara\u003eIn th event that you do not know which release codename you have installed on your server, you can find out using the following command:\u003c/para\u003e"},{"line_number":476,"context_line":""},{"line_number":477,"context_line":"\u003cprogramlisting language\u003d\"bash\"\u003e"},{"line_number":478,"context_line":"\u003cprompt\u003e$\u003c/prompt\u003e \u003cuserinput\u003elsb_release -a\u003c/userinput\u003e"},{"line_number":479,"context_line":"\u003ccomputeroutput\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_68d53cb6","line":476,"updated":"2015-01-04 20:19:55.000000000","message":"the event","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":570,"context_line":"\u003csection xml:id\u003d\"galera-config\"\u003e"},{"line_number":571,"context_line":"\u003ctitle\u003eConfiguration\u003c/title\u003e"},{"line_number":572,"context_line":""},{"line_number":573,"context_line":"\u003cpara\u003eWhen you have finished installing Galera Cluster on a server, you are ready to configure the database itself to serve as a node in the cluster.  You will need to edit the MySQL configuration file.\u003c/para\u003e"},{"line_number":574,"context_line":""},{"line_number":575,"context_line":"\u003cpara\u003eUsing a simple text editor, edit the \u003ccode\u003e/etc/my.cnf\u003c/code\u003e file.  It should look like this:\u003c/para\u003e"},{"line_number":576,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_03b9f9ca","line":573,"updated":"2015-01-04 20:19:55.000000000","message":"Even tighter prose suggestion:\n\nEdit the MySQL configuration file.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":597,"context_line":"\u003clistitem\u003e"},{"line_number":598,"context_line":"\u003cpara\u003e\u003ccode\u003ewsrep_cluster_name\u003c/code\u003e You will need to edit value for this parameter to use whatever name you find convenient for your cluster.\u003c/para\u003e"},{"line_number":599,"context_line":"\u003c/listitem\u003e"},{"line_number":600,"context_line":""},{"line_number":601,"context_line":"\u003clistitem\u003e"},{"line_number":602,"context_line":"\u003cpara\u003e\u003ccode\u003ewsrep_cluster_address\u003c/code\u003e You will need to edit the values for this parameter to provide a comma separated list that provides the IP addresses for each node in your cluster.\u003c/para\u003e"},{"line_number":603,"context_line":"\u003c/listitem\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_23b0b5dc","line":600,"updated":"2015-01-04 20:19:55.000000000","message":"Get rid of will where you can.\n\nEdit the value for this parameter, using a convenient descriptive name for your cluster.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":600,"context_line":""},{"line_number":601,"context_line":"\u003clistitem\u003e"},{"line_number":602,"context_line":"\u003cpara\u003e\u003ccode\u003ewsrep_cluster_address\u003c/code\u003e You will need to edit the values for this parameter to provide a comma separated list that provides the IP addresses for each node in your cluster.\u003c/para\u003e"},{"line_number":603,"context_line":"\u003c/listitem\u003e"},{"line_number":604,"context_line":""},{"line_number":605,"context_line":"\u003c/itemizedlist\u003e"},{"line_number":606,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_63c9dd59","line":603,"updated":"2015-01-04 20:19:55.000000000","message":"comma-separated","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":6926,"name":"Bogdan Dobrelya","email":"bdobreli@redhat.com","username":"bogdando"},"change_message_id":"90ffff1b4a70bebaba0fa0bf6406ef96924a1912","unresolved":false,"context_lines":[{"line_number":634,"context_line":"\u003c/listitem\u003e"},{"line_number":635,"context_line":""},{"line_number":636,"context_line":"\u003clistitem\u003e"},{"line_number":637,"context_line":"\u003cpara\u003eNo firewalls between the nodes.\u003c/para\u003e"},{"line_number":638,"context_line":"\u003c/listitem\u003e"},{"line_number":639,"context_line":""},{"line_number":640,"context_line":"\u003clistitem\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_6ce71ead","line":637,"updated":"2015-01-02 14:30:02.000000000","message":"There are rules for iptables were specified above. Perhaps. the correct sentence should be \"Firewall is configured to allow the MySQL traffic between the nodes\"","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":757,"context_line":"\u003c/orderedlist\u003e"},{"line_number":758,"context_line":""},{"line_number":759,"context_line":"\u003corderedlist\u003e"},{"line_number":760,"context_line":"\u003ctitle\u003eTesting the Cluster\u003c/title\u003e"},{"line_number":761,"context_line":""},{"line_number":762,"context_line":"\u003cpara\u003eWhen you have the cluster up and running, you may want to test certain features to ensure that they are working properly or to better acquaint yourself with how the cluster operates.\u003c/para\u003e"},{"line_number":763,"context_line":""}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_83c40942","line":760,"updated":"2015-01-04 20:19:55.000000000","message":"Sentence caps","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"},{"author":{"_account_id":964,"name":"Anne Gentle","email":"annegentle@justwriteclick.com","username":"annegentle"},"change_message_id":"2b3adeb245f81418f2723c789677c26d235e93f8","unresolved":false,"context_lines":[{"line_number":784,"context_line":"\u003c/listitem\u003e"},{"line_number":785,"context_line":""},{"line_number":786,"context_line":"\u003clistitem\u003e"},{"line_number":787,"context_line":"\u003cpara\u003e\u003ccode\u003ewsrep_cluster_size\u003c/code\u003e Here the value \u003ccode\u003e3\u003c/code\u003e indicates the number of nodes presently connected to the cluster.\u003c/para\u003e"},{"line_number":788,"context_line":"\u003c/listitem\u003e"},{"line_number":789,"context_line":""},{"line_number":790,"context_line":"\u003clistitem\u003e"}],"source_content_type":"application/xml","patch_set":2,"id":"3a961159_a3c3c536","line":787,"updated":"2015-01-04 20:19:55.000000000","message":"I think rather than \u003ccode\u003e the semantic markup is \u003cliteral\u003e but I\u0027d like Andreas to remind me.","commit_id":"a2bce2e982b3641dbaa38b5c66ec334d2e84ca68"}]}