)]}'
{"doc/ha-guide/source/controller-ha-galera-config.rst":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":17,"context_line":""},{"line_number":18,"context_line":"Galera Cluster requires that you open four ports to network traffic:"},{"line_number":19,"context_line":""},{"line_number":20,"context_line":"- On ``3306`` Galera Cluster uses TCP for database client connections"},{"line_number":21,"context_line":"  and State Snapshot Transfers methods that require the client,"},{"line_number":22,"context_line":"  (that is, ``mysqldump``)."},{"line_number":23,"context_line":"- On ``4567`` Galera Cluster uses TCP for replication traffic.  Multicast"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c34f7369","line":20,"range":{"start_line":20,"start_character":2,"end_line":20,"end_character":13},"updated":"2016-01-05 12:59:16.000000000","message":"Please add a comma after each port:\n\n- On ``3306``,","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":35,"context_line":"^^^^^^^^^^^^^"},{"line_number":36,"context_line":""},{"line_number":37,"context_line":"For many Linux distributions, you can configure the firewall using"},{"line_number":38,"context_line":"the ``iptables`` utility.  To do so, complete the following steps:"},{"line_number":39,"context_line":""},{"line_number":40,"context_line":"#. For each cluster node, run the following commands, replacing"},{"line_number":41,"context_line":"   ``NODE-IP-ADDRESS`` with the IP address of the cluster node"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_886bdaf0","line":38,"range":{"start_line":38,"start_character":26,"end_line":38,"end_character":27},"updated":"2016-01-05 12:59:16.000000000","message":"extra space, please check in other lines as well.","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":67,"context_line":""},{"line_number":68,"context_line":""},{"line_number":69,"context_line":"#. Make the changes persistent.  For servers that use ``init``, use"},{"line_number":70,"context_line":"   the ``save`` command:"},{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   .. code-block:: console"},{"line_number":73,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_2519b779","line":70,"range":{"start_line":70,"start_character":3,"end_line":70,"end_character":24},"updated":"2016-01-05 12:59:16.000000000","message":"the :command:`save` command:","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":74,"context_line":"      # service save iptables"},{"line_number":75,"context_line":""},{"line_number":76,"context_line":"   For servers that use ``systemd``, you need to save the current packet"},{"line_number":77,"context_line":"   filtering to the path of the file that ``iptables`` reads when it starts"},{"line_number":78,"context_line":"   This path can vary by distribution, but common locations are in the"},{"line_number":79,"context_line":"   ``/etc`` directory, such as:"},{"line_number":80,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_054a7355","line":77,"range":{"start_line":77,"start_character":69,"end_line":77,"end_character":75},"updated":"2016-01-05 12:59:16.000000000","message":"a period is missing","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":81,"context_line":"   - ``/etc/sysconfig/iptables``"},{"line_number":82,"context_line":"   - ``/etc/iptables/iptables.rules``"},{"line_number":83,"context_line":""},{"line_number":84,"context_line":"   When you find the correct path, run the ``iptables-save`` command:"},{"line_number":85,"context_line":""},{"line_number":86,"context_line":"   .. code-block:: console"},{"line_number":87,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_255e9712","line":84,"range":{"start_line":84,"start_character":43,"end_line":84,"end_character":69},"updated":"2016-01-05 12:59:16.000000000","message":":command:`iptables-save` command:","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":122,"context_line":"      # firewall-cmd --add-port\u003d4567/udp"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"#. To make this configuration persistent, repeat the above commands"},{"line_number":125,"context_line":"   with the ``--permanent`` option."},{"line_number":126,"context_line":""},{"line_number":127,"context_line":"   .. code-block:: console"},{"line_number":128,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c5845b5f","line":125,"range":{"start_line":125,"start_character":12,"end_line":125,"end_character":35},"updated":"2016-01-05 12:59:16.000000000","message":":option:`--permanent` option.","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":253,"context_line":""},{"line_number":254,"context_line":"While all of the configuration parameters available to the standard MySQL,"},{"line_number":255,"context_line":"MariaDB or Percona XtraDB database server are available in Galera Cluster,"},{"line_number":256,"context_line":"there are some that you must define an the outset to avoid conflict or"},{"line_number":257,"context_line":"unexpected behavior."},{"line_number":258,"context_line":""},{"line_number":259,"context_line":"- Ensure that the database server is not bound only to to the localhost,"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_259bf773","line":256,"range":{"start_line":256,"start_character":36,"end_line":256,"end_character":42},"updated":"2016-01-05 12:59:16.000000000","message":"an or the?","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":307,"context_line":"  performance, it introduces certain dangers.  Operating system failures can"},{"line_number":308,"context_line":"  erase the last second of transactions.  While you can recover this data"},{"line_number":309,"context_line":"  from another node, if the cluster goes down at the same time"},{"line_number":310,"context_line":"  (in the event of a data center power outage), you lose this data for good."},{"line_number":311,"context_line":""},{"line_number":312,"context_line":"- Define the InnoDB memory buffer pool size.  The default value is 128 MB,"},{"line_number":313,"context_line":"  but to compensate for Galera Cluster\u0027s additional memory usage, scale"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c88a321b","line":310,"range":{"start_line":310,"start_character":67,"end_line":310,"end_character":75},"updated":"2016-01-05 12:59:16.000000000","message":"I believe it\u0027s better to replace this with something like \"permanently\".","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":370,"context_line":"Additional parameters"},{"line_number":371,"context_line":"^^^^^^^^^^^^^^^^^^^^^^"},{"line_number":372,"context_line":""},{"line_number":373,"context_line":"For a complete list of the available parameters, you can run the"},{"line_number":374,"context_line":"``SHOW VARIABLES`` command from within the database client:"},{"line_number":375,"context_line":""},{"line_number":376,"context_line":".. code-block:: mysql"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_8858ba8b","line":373,"range":{"start_line":373,"start_character":49,"end_line":373,"end_character":56},"updated":"2016-01-05 12:59:16.000000000","message":"remove \"you can\"","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":391,"context_line":"   | wsrep_sync_wait              | 0     |"},{"line_number":392,"context_line":"   +------------------------------+-------+"},{"line_number":393,"context_line":""},{"line_number":394,"context_line":"For the documentation of these parameters, wsrep Provider options and status"},{"line_number":395,"context_line":"variables available in Galera Cluster, see `Reference"},{"line_number":396,"context_line":"\u003chttp://galeracluster.com/documentation-webpages/reference.html\u003e`_."}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c8f0f269","line":394,"range":{"start_line":394,"start_character":58,"end_line":394,"end_character":65},"updated":"2016-01-05 12:59:16.000000000","message":"options,","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"}],"doc/ha-guide/source/controller-ha-galera-install.rst":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":87,"context_line":"Packages in the Galera Cluster Debian repository are now available for"},{"line_number":88,"context_line":"installation on your system."},{"line_number":89,"context_line":""},{"line_number":90,"context_line":""},{"line_number":91,"context_line":""},{"line_number":92,"context_line":""},{"line_number":93,"context_line":"Red Hat"},{"line_number":94,"context_line":"--------"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_23e3ef34","line":91,"range":{"start_line":90,"start_character":0,"end_line":91,"end_character":0},"updated":"2016-01-05 12:59:16.000000000","message":"one empty line is enough","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":94,"context_line":"--------"},{"line_number":95,"context_line":""},{"line_number":96,"context_line":"For Red Hat Enterprise Linux and Red Hat-based Linux distributions, the"},{"line_number":97,"context_line":"process is more straightforward.  In this file, only enter the text for"},{"line_number":98,"context_line":"the repository you want to use."},{"line_number":99,"context_line":""},{"line_number":100,"context_line":"- For Galera Cluster for MySQL, using your preferred text editor, create a"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_a3cd9fb8","line":97,"range":{"start_line":97,"start_character":33,"end_line":97,"end_character":34},"updated":"2016-01-05 12:59:16.000000000","message":"extra space","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"}],"doc/ha-guide/source/controller-ha-galera-manage.rst":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":4,"context_line":"When you finish the installation and configuration process on each"},{"line_number":5,"context_line":"cluster node in your OpenStack database, you can initialize Galera Cluster."},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Before you attempt this, check that you have the following ready:"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"- Database hosts with Galera Cluster installed.  You need a"},{"line_number":10,"context_line":"  minimum of three hosts;"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_63200749","line":7,"range":{"start_line":7,"start_character":25,"end_line":7,"end_character":30},"updated":"2016-01-05 12:59:16.000000000","message":"verify","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Before you attempt this, check that you have the following ready:"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"- Database hosts with Galera Cluster installed.  You need a"},{"line_number":10,"context_line":"  minimum of three hosts;"},{"line_number":11,"context_line":"- No firewalls between the hosts;"},{"line_number":12,"context_line":"- SELinux and AppArmor set to permit access to ``mysqld``;"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c3bc53de","line":9,"range":{"start_line":9,"start_character":48,"end_line":9,"end_character":49},"updated":"2016-01-05 12:59:16.000000000","message":"extra space. Please check in other lines as well.","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":154,"context_line":"- Each instance has its own IP address;"},{"line_number":155,"context_line":""},{"line_number":156,"context_line":"  OpenStack services are configured with the list of these IP"},{"line_number":157,"context_line":"  addresses so they can select on of the addresses from those"},{"line_number":158,"context_line":"  available."},{"line_number":159,"context_line":""},{"line_number":160,"context_line":"- Galera runs behind HAProxy."}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_c3069385","line":157,"range":{"start_line":157,"start_character":31,"end_line":157,"end_character":33},"updated":"2016-01-05 12:59:16.000000000","message":"one?","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":159,"context_line":""},{"line_number":160,"context_line":"- Galera runs behind HAProxy."},{"line_number":161,"context_line":""},{"line_number":162,"context_line":"  HAProxy the load balances incoming requests and exposes just one IP"},{"line_number":163,"context_line":"  address for all the clients."},{"line_number":164,"context_line":""},{"line_number":165,"context_line":"  Galera synchronous replication guarantees a zero slave lag. The"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_03482bcb","line":162,"range":{"start_line":162,"start_character":10,"end_line":162,"end_character":13},"updated":"2016-01-05 12:59:16.000000000","message":"remove the","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":201,"context_line":"      MYSQL_HOST\u003d\"localhost\""},{"line_number":202,"context_line":"      MYSQL_PORT\u003d\"3306\""},{"line_number":203,"context_line":""},{"line_number":204,"context_line":"#. Log into the database client and grant the ``clustercheck`` user"},{"line_number":205,"context_line":"   ``PROCESS`` privileges."},{"line_number":206,"context_line":""},{"line_number":207,"context_line":"   .. code-block:: mysql"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_636d6730","line":204,"range":{"start_line":204,"start_character":3,"end_line":204,"end_character":11},"updated":"2016-01-05 12:59:16.000000000","message":"Log in to","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":19779,"name":"Chason Chan","display_name":"chenxing","email":"chason.chan@foxmail.com","username":"chenxing"},"change_message_id":"2cc248f49fd8bc5ce6bdc895d863c0531267d4c8","unresolved":false,"context_lines":[{"line_number":236,"context_line":"        flags \u003d REUSE"},{"line_number":237,"context_line":"     }"},{"line_number":238,"context_line":""},{"line_number":239,"context_line":"#. Start the ``xinetd`` daemon for ``clustercheck``.  For servers"},{"line_number":240,"context_line":"   that use ``init``, run the following commands:"},{"line_number":241,"context_line":""},{"line_number":242,"context_line":"   .. code-block:: console"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_f6bab7e0","line":239,"range":{"start_line":239,"start_character":52,"end_line":239,"end_character":54},"updated":"2016-01-04 08:18:45.000000000","message":"One space is enough.","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"}],"doc/ha-guide/source/controller-ha-galera.rst":[{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":2,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":3,"context_line":""},{"line_number":4,"context_line":"The first step is to install the database that sits at the heart of the"},{"line_number":5,"context_line":"cluster. To implement High Availability, run an instance of the database on"},{"line_number":6,"context_line":"each controller node and use Galera Cluster to provide replication between"},{"line_number":7,"context_line":"them. Galera Cluster is a synchronous multi-master database cluster, based"},{"line_number":8,"context_line":"on MySQL and the InnoDB storage engine. It is a high-availability service"}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_fe1b3071","line":5,"range":{"start_line":5,"start_character":22,"end_line":5,"end_character":39},"updated":"2016-01-05 12:59:16.000000000","message":"high availability","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":8,"context_line":"on MySQL and the InnoDB storage engine. It is a high-availability service"},{"line_number":9,"context_line":"that provides high system uptime, no data loss, and scalability for growth."},{"line_number":10,"context_line":""},{"line_number":11,"context_line":"You can achieve High Availability for the OpenStack database in many"},{"line_number":12,"context_line":"different ways, depending on the type of database that you want to use."},{"line_number":13,"context_line":"There are three implementations of Galera Cluster available to you:"},{"line_number":14,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_be285887","line":11,"range":{"start_line":11,"start_character":16,"end_line":11,"end_character":33},"updated":"2016-01-05 12:59:16.000000000","message":"high availability","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"},{"author":{"_account_id":14947,"name":"Maria Zlatkova","email":"mzlatkova@mirantis.com","username":"mzlatkova"},"change_message_id":"b980a1801a95e5d4c98d450f9283a85d1669bf4a","unresolved":false,"context_lines":[{"line_number":20,"context_line":"- `Percona XtraDB Cluster \u003chttp://www.percona.com/\u003e`_ The XtraDB"},{"line_number":21,"context_line":"  implementation of Galera Cluster from Percona."},{"line_number":22,"context_line":""},{"line_number":23,"context_line":"In addition to Galera Cluster, you can also achieve High Availability"},{"line_number":24,"context_line":"through other database options, such as PostgreSQL, which has its own"},{"line_number":25,"context_line":"replication system."},{"line_number":26,"context_line":""}],"source_content_type":"text/x-rst","patch_set":5,"id":"fa69d971_fe3250f1","line":23,"range":{"start_line":23,"start_character":52,"end_line":23,"end_character":69},"updated":"2016-01-05 12:59:16.000000000","message":"high availability","commit_id":"6da40239133d7a8f40b0817551e0029d5408aa83"}]}