)]}'
{"doc/source/admin/index.rst":[{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":9,"context_line":"   tls"},{"line_number":10,"context_line":"   acme"},{"line_number":11,"context_line":"   mariadb-backup-and-restore"},{"line_number":12,"context_line":"   mariadb-shards"},{"line_number":13,"context_line":"   production-architecture-guide"},{"line_number":14,"context_line":"   deployment-philosophy"}],"source_content_type":"text/x-rst","patch_set":1,"id":"7902dbad_2cdf6e5e","line":12,"range":{"start_line":12,"start_character":3,"end_line":12,"end_character":17},"updated":"2021-04-07 16:35:28.000000000","message":"I would suggest putting this in doc/source/reference/databases/mariadb-guide.rst","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":9,"context_line":"   tls"},{"line_number":10,"context_line":"   acme"},{"line_number":11,"context_line":"   mariadb-backup-and-restore"},{"line_number":12,"context_line":"   mariadb-shards"},{"line_number":13,"context_line":"   production-architecture-guide"},{"line_number":14,"context_line":"   deployment-philosophy"}],"source_content_type":"text/x-rst","patch_set":1,"id":"f38616a1_e92255e8","line":12,"range":{"start_line":12,"start_character":3,"end_line":12,"end_character":17},"in_reply_to":"7902dbad_2cdf6e5e","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"}],"doc/source/admin/mariadb-shards.rst":[{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":11,"context_line":"Each shard acts as the single source for this subset of data."},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."}],"source_content_type":"text/x-rst","patch_set":1,"id":"c982e265_a841e0e4","line":14,"range":{"start_line":14,"start_character":53,"end_line":14,"end_character":79},"updated":"2021-04-07 16:35:28.000000000","message":"Currently they aren\u0027t all accessible via ``kolla_internal_vip_address``.","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":11,"context_line":"Each shard acts as the single source for this subset of data."},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."}],"source_content_type":"text/x-rst","patch_set":1,"id":"d381dca8_f2a4062c","line":14,"updated":"2021-04-07 16:35:28.000000000","message":"Each shard is implemented as an independent Galera cluster.","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":11,"context_line":"Each shard acts as the single source for this subset of data."},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."}],"source_content_type":"text/x-rst","patch_set":1,"id":"cdaa43a6_625693b8","line":14,"range":{"start_line":14,"start_character":53,"end_line":14,"end_character":79},"in_reply_to":"c982e265_a841e0e4","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":11,"context_line":"Each shard acts as the single source for this subset of data."},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."}],"source_content_type":"text/x-rst","patch_set":1,"id":"2e537eb0_ffb6a4fe","line":14,"in_reply_to":"d381dca8_f2a4062c","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."},{"line_number":18,"context_line":"Another part of implementation is defined in ProxySQL documentation HERE \u003cTODO in followup patches\u003e."},{"line_number":19,"context_line":""},{"line_number":20,"context_line":"This setup can be used also without ProxySQL, just to deploy MariaDB clusters simultaneously"},{"line_number":21,"context_line":"for whatever reason user want to do it (for example cells)."},{"line_number":22,"context_line":""},{"line_number":23,"context_line":"Deployment"},{"line_number":24,"context_line":"~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":1,"id":"a5e28dee_b76dddef","line":21,"range":{"start_line":16,"start_character":0,"end_line":21,"end_character":59},"updated":"2021-04-07 16:35:28.000000000","message":"Let\u0027s not assume ProxySQL is supported just yet.\n\n This section explains how to configure multiple database shards. Currently, only one shard is accessible via the HAProxy load balancer and supported by the ``kolla-ansible mariadb_backup`` command. This will be improved in future by using ProxySQL, allowing load balanced access to all shards.","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":13,"context_line":"Kolla supports sharding on service\u0027s database level, so every database can be"},{"line_number":14,"context_line":"hosted on different shard while accessible through ``kolla_internal_vip_address``."},{"line_number":15,"context_line":""},{"line_number":16,"context_line":"This documentation only explains the part where mariadb role installs that shards"},{"line_number":17,"context_line":"and how to configure it."},{"line_number":18,"context_line":"Another part of implementation is defined in ProxySQL documentation HERE \u003cTODO in followup patches\u003e."},{"line_number":19,"context_line":""},{"line_number":20,"context_line":"This setup can be used also without ProxySQL, just to deploy MariaDB clusters simultaneously"},{"line_number":21,"context_line":"for whatever reason user want to do it (for example cells)."},{"line_number":22,"context_line":""},{"line_number":23,"context_line":"Deployment"},{"line_number":24,"context_line":"~~~~~~~~~~"}],"source_content_type":"text/x-rst","patch_set":1,"id":"1220f67c_377d09a1","line":21,"range":{"start_line":16,"start_character":0,"end_line":21,"end_character":59},"in_reply_to":"a5e28dee_b76dddef","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":22,"context_line":""},{"line_number":23,"context_line":"Deployment"},{"line_number":24,"context_line":"~~~~~~~~~~"},{"line_number":25,"context_line":""},{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"6a4c6c1b_0cc07dfd","line":25,"updated":"2021-04-07 16:35:28.000000000","message":"Each shard is identified by an integer ID, defined by ``mariadb_shard_id``. The default shard, defined by `mariadb_default_database_shard_id`` (default 0), identifies the shard that will be accessible via HAProxy and available for backing up.","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":22,"context_line":""},{"line_number":23,"context_line":"Deployment"},{"line_number":24,"context_line":"~~~~~~~~~~"},{"line_number":25,"context_line":""},{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"39794dac_978ffd96","line":25,"in_reply_to":"6a4c6c1b_0cc07dfd","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":24,"context_line":"~~~~~~~~~~"},{"line_number":25,"context_line":""},{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"#. Add ``mariadb_shard_id`` hostvar to hosts which are members"},{"line_number":30,"context_line":"   of common cluster (shard) as it is in example below:"}],"source_content_type":"text/x-rst","patch_set":1,"id":"871d29f9_2673278e","line":27,"range":{"start_line":27,"start_character":15,"end_line":27,"end_character":21},"updated":"2021-04-07 16:35:28.000000000","message":"in the way","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":24,"context_line":"~~~~~~~~~~"},{"line_number":25,"context_line":""},{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"#. Add ``mariadb_shard_id`` hostvar to hosts which are members"},{"line_number":30,"context_line":"   of common cluster (shard) as it is in example below:"}],"source_content_type":"text/x-rst","patch_set":1,"id":"d1c241bb_05cac346","line":27,"range":{"start_line":27,"start_character":15,"end_line":27,"end_character":21},"in_reply_to":"871d29f9_2673278e","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"8ac4c0e7c1fcba5be739dd5b8a28d74fb5e60c7a","unresolved":true,"context_lines":[{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"#. Add ``mariadb_shard_id`` hostvar to hosts which are members"},{"line_number":30,"context_line":"   of common cluster (shard) as it is in example below:"},{"line_number":31,"context_line":""},{"line_number":32,"context_line":"   .. code-block:: ini"},{"line_number":33,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"d64e34f5_d695e16c","line":30,"range":{"start_line":29,"start_character":0,"end_line":30,"end_character":55},"updated":"2021-04-07 16:35:28.000000000","message":"Could remove this bit?","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"73148096c865e2fa98ac7f9eb25f0fea87bb0e54","unresolved":false,"context_lines":[{"line_number":26,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"},{"line_number":27,"context_line":"inventory file in way described below:"},{"line_number":28,"context_line":""},{"line_number":29,"context_line":"#. Add ``mariadb_shard_id`` hostvar to hosts which are members"},{"line_number":30,"context_line":"   of common cluster (shard) as it is in example below:"},{"line_number":31,"context_line":""},{"line_number":32,"context_line":"   .. code-block:: ini"},{"line_number":33,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"5d04b7e8_53a4e09f","line":30,"range":{"start_line":29,"start_character":0,"end_line":30,"end_character":55},"in_reply_to":"d64e34f5_d695e16c","updated":"2021-05-13 07:40:26.000000000","message":"Done","commit_id":"ec846995ce792b3ee85ddd2c403cd2bd27ba5104"}],"doc/source/reference/databases/mariadb-guide.rst":[{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"891e8a22df88d3462ad4ea195a1097cde91f4d26","unresolved":true,"context_lines":[{"line_number":1,"context_line":".. _mariadb-guide:"},{"line_number":2,"context_line":""},{"line_number":3,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":4,"context_line":"MariaDB Shards"},{"line_number":5,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"A database shard, or simply a shard, is a horizontal partition of data"}],"source_content_type":"text/x-rst","patch_set":3,"id":"043256fe_5fa5c728","line":4,"range":{"start_line":4,"start_character":8,"end_line":4,"end_character":14},"updated":"2021-05-13 08:41:47.000000000","message":"MariaDB Guide","commit_id":"878ebf8e607a9877b47d2298a9302dfa11ca6cbf"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"891e8a22df88d3462ad4ea195a1097cde91f4d26","unresolved":true,"context_lines":[{"line_number":3,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":4,"context_line":"MariaDB Shards"},{"line_number":5,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"A database shard, or simply a shard, is a horizontal partition of data"},{"line_number":8,"context_line":"in a database or search engine. Each shard is held on a separate database"},{"line_number":9,"context_line":"server/cluster, to spread load. Some data within a database remains present"}],"source_content_type":"text/x-rst","patch_set":3,"id":"7c415493_a4721b2b","line":6,"updated":"2021-05-13 08:41:47.000000000","message":"Quick intro: Kolla Ansible supports deployment of a MariaDB/Galera cluster for use by OpenStack and other services.\n\nNew heading:\n\nMariaDB Shards\n~~~~~~~~~~~~~~\n\nShuffle other headings down one level","commit_id":"878ebf8e607a9877b47d2298a9302dfa11ca6cbf"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"891e8a22df88d3462ad4ea195a1097cde91f4d26","unresolved":true,"context_lines":[{"line_number":22,"context_line":"~~~~~~~~~~"},{"line_number":23,"context_line":""},{"line_number":24,"context_line":"Each shard is identified by an integer ID, defined by ``mariadb_shard_id``."},{"line_number":25,"context_line":"The default shard, defined by `mariadb_default_database_shard_id`` (default 0),"},{"line_number":26,"context_line":"identifies the shard that will be accessible via HAProxy and available for backing up."},{"line_number":27,"context_line":""},{"line_number":28,"context_line":"In order to deploy several MariaDB cluster, you will need to edit"}],"source_content_type":"text/x-rst","patch_set":3,"id":"3923bf7d_e1b611c7","line":25,"range":{"start_line":25,"start_character":30,"end_line":25,"end_character":31},"updated":"2021-05-13 08:41:47.000000000","message":"``","commit_id":"878ebf8e607a9877b47d2298a9302dfa11ca6cbf"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"15ff6e0d6c766174fbe4271cbdb61f5a88506aef","unresolved":true,"context_lines":[{"line_number":4,"context_line":"MariaDB Guide"},{"line_number":5,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Quick intro: Kolla Ansible supports deployment of a MariaDB/Galera cluster"},{"line_number":8,"context_line":"for use by OpenStack and other services."},{"line_number":9,"context_line":""},{"line_number":10,"context_line":"MariaDB Shards"}],"source_content_type":"text/x-rst","patch_set":4,"id":"3a3f3e85_ef29399f","line":7,"range":{"start_line":7,"start_character":0,"end_line":7,"end_character":13},"updated":"2021-05-17 09:13:04.000000000","message":"Remove!","commit_id":"51c8bdb7f431c5d306b116d6c8132635ad281c96"},{"author":{"_account_id":27339,"name":"Michal Arbet","email":"michal.arbet@ultimum.io","username":"michalarbet"},"change_message_id":"b8ed923eef82725dd85aa4795cc99b8b6174a897","unresolved":false,"context_lines":[{"line_number":4,"context_line":"MariaDB Guide"},{"line_number":5,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":6,"context_line":""},{"line_number":7,"context_line":"Quick intro: Kolla Ansible supports deployment of a MariaDB/Galera cluster"},{"line_number":8,"context_line":"for use by OpenStack and other services."},{"line_number":9,"context_line":""},{"line_number":10,"context_line":"MariaDB Shards"}],"source_content_type":"text/x-rst","patch_set":4,"id":"cac2f537_00b79ed3","line":7,"range":{"start_line":7,"start_character":0,"end_line":7,"end_character":13},"in_reply_to":"3a3f3e85_ef29399f","updated":"2021-05-17 13:37:43.000000000","message":"Done","commit_id":"51c8bdb7f431c5d306b116d6c8132635ad281c96"}]}