)]}'
{"specs/pike/mysql-cluster-support.rst":[{"author":{"_account_id":11904,"name":"Sean McGinnis","email":"sean.mcginnis@gmail.com","username":"SeanM"},"change_message_id":"fd5725f4e2625a851c4dc6bd8222431c9171ae42","unresolved":false,"context_lines":[{"line_number":34,"context_line":"Key Benefits for OpenStack:"},{"line_number":35,"context_line":""},{"line_number":36,"context_line":" - Highly-Available DB back-end"},{"line_number":37,"context_line":" - Massively scalible DB back-end"},{"line_number":38,"context_line":" - Reduced operational impact of planned or unplanned DB maintenance."},{"line_number":39,"context_line":" - Reduced complexity compared to InnoDB clustering."},{"line_number":40,"context_line":" - No shared storage or 3rd party clustering software required."}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_9cc0927e","line":37,"range":{"start_line":37,"start_character":13,"end_line":37,"end_character":21},"updated":"2017-02-12 01:38:01.000000000","message":"scalable","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":34,"context_line":"Key Benefits for OpenStack:"},{"line_number":35,"context_line":""},{"line_number":36,"context_line":" - Highly-Available DB back-end"},{"line_number":37,"context_line":" - Massively scalible DB back-end"},{"line_number":38,"context_line":" - Reduced operational impact of planned or unplanned DB maintenance."},{"line_number":39,"context_line":" - Reduced complexity compared to InnoDB clustering."},{"line_number":40,"context_line":" - No shared storage or 3rd party clustering software required."}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_81127755","line":37,"range":{"start_line":37,"start_character":13,"end_line":37,"end_character":21},"in_reply_to":"fa31d9ce_9cc0927e","updated":"2017-02-14 22:14:59.000000000","message":"Thanks for catching this.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"f51355b989adae9ac824dbef9b92edc47ba2f41c","unresolved":false,"context_lines":[{"line_number":76,"context_line":"   cinder.conf file for this enhancement to work. Otherwise, this"},{"line_number":77,"context_line":"   enhancement will default to InnoDB with no change in behavior."},{"line_number":78,"context_line":""},{"line_number":79,"context_line":"Proposed change"},{"line_number":80,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":" - Enhance oslo.db to add the configuration setting of"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_087faa15","line":79,"range":{"start_line":79,"start_character":0,"end_line":79,"end_character":15},"updated":"2017-02-14 10:43:54.000000000","message":"Is there a migration path from InnoDB to NDB being proposed or does this affect only new deployments?","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":76,"context_line":"   cinder.conf file for this enhancement to work. Otherwise, this"},{"line_number":77,"context_line":"   enhancement will default to InnoDB with no change in behavior."},{"line_number":78,"context_line":""},{"line_number":79,"context_line":"Proposed change"},{"line_number":80,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":" - Enhance oslo.db to add the configuration setting of"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_21a38b01","line":79,"range":{"start_line":79,"start_character":0,"end_line":79,"end_character":15},"in_reply_to":"fa31d9ce_087faa15","updated":"2017-02-14 22:14:59.000000000","message":"For the initial push, this will be for new deployments. But for the second phase, I\u0027d like to deliver a migration script where one would take a dump of their current MySQL DB and import it into MySQL Cluster. The operator would have to setup the MySQL Cluster and handle configuration file changes to point to the cluster.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"6669569ddecafd1e7076e44d138399b6a28eec6b","unresolved":false,"context_lines":[{"line_number":76,"context_line":"   cinder.conf file for this enhancement to work. Otherwise, this"},{"line_number":77,"context_line":"   enhancement will default to InnoDB with no change in behavior."},{"line_number":78,"context_line":""},{"line_number":79,"context_line":"Proposed change"},{"line_number":80,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":81,"context_line":""},{"line_number":82,"context_line":" - Enhance oslo.db to add the configuration setting of"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_f30e978a","line":79,"range":{"start_line":79,"start_character":0,"end_line":79,"end_character":15},"in_reply_to":"fa31d9ce_21a38b01","updated":"2017-02-15 09:45:31.000000000","message":"Works for me.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"f51355b989adae9ac824dbef9b92edc47ba2f41c","unresolved":false,"context_lines":[{"line_number":106,"context_line":""},{"line_number":107,"context_line":"These changes will be validated and tested to ensure that:"},{"line_number":108,"context_line":""},{"line_number":109,"context_line":" - Zero impact to functionality of APIs, CLIs, and service processes."},{"line_number":110,"context_line":" - Zero impact on operators using MySQL InnoDB."},{"line_number":111,"context_line":" - Minimal operator overhead for enabling NDB functionality."},{"line_number":112,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_28f8ee7a","line":109,"range":{"start_line":109,"start_character":0,"end_line":109,"end_character":69},"updated":"2017-02-14 10:43:54.000000000","message":"Can you make sure that our complicated UPDATE (...) WHERE (...) clauses still work? We\u0027re utilizing this technique to make sure our resource state changes are atomic.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":106,"context_line":""},{"line_number":107,"context_line":"These changes will be validated and tested to ensure that:"},{"line_number":108,"context_line":""},{"line_number":109,"context_line":" - Zero impact to functionality of APIs, CLIs, and service processes."},{"line_number":110,"context_line":" - Zero impact on operators using MySQL InnoDB."},{"line_number":111,"context_line":" - Minimal operator overhead for enabling NDB functionality."},{"line_number":112,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_811fd706","line":109,"range":{"start_line":109,"start_character":0,"end_line":109,"end_character":69},"in_reply_to":"fa31d9ce_28f8ee7a","updated":"2017-02-14 22:14:59.000000000","message":"MySQL Cluster does support atomic transactions. These are synchronous across the cluster to ensure data integrity. This feature is listed here: https://www.mysql.com/products/cluster/features.html","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"f51355b989adae9ac824dbef9b92edc47ba2f41c","unresolved":false,"context_lines":[{"line_number":141,"context_line":"- attach_time -\u003e TinyText"},{"line_number":142,"context_line":"- display_description -\u003e TinyText"},{"line_number":143,"context_line":""},{"line_number":144,"context_line":"This logic will be implemented in the 001_cinder_init.py and the"},{"line_number":145,"context_line":"models.py files respectively. This will allow these columns to fit"},{"line_number":146,"context_line":"within NDB row limit of 14k characters. It will have zero affect"},{"line_number":147,"context_line":"on the default MySQL InnoDB database schema."}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_e5aeff96","line":144,"range":{"start_line":144,"start_character":38,"end_line":144,"end_character":56},"updated":"2017-02-14 10:43:54.000000000","message":"We don\u0027t have that file now.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":141,"context_line":"- attach_time -\u003e TinyText"},{"line_number":142,"context_line":"- display_description -\u003e TinyText"},{"line_number":143,"context_line":""},{"line_number":144,"context_line":"This logic will be implemented in the 001_cinder_init.py and the"},{"line_number":145,"context_line":"models.py files respectively. This will allow these columns to fit"},{"line_number":146,"context_line":"within NDB row limit of 14k characters. It will have zero affect"},{"line_number":147,"context_line":"on the default MySQL InnoDB database schema."}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_81e6f712","line":144,"range":{"start_line":144,"start_character":38,"end_line":144,"end_character":56},"in_reply_to":"fa31d9ce_e5aeff96","updated":"2017-02-14 22:14:59.000000000","message":"I mistyped, it\u0027s 061_cinder_init.py. I\u0027ll fix this in the spec.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":7198,"name":"Jay Bryant","email":"jungleboyj@electronicjungle.net","username":"jsbryant"},"change_message_id":"9999fa30f11496d290ae7064e6af94bfe810d135","unresolved":false,"context_lines":[{"line_number":169,"context_line":"Performance Impact"},{"line_number":170,"context_line":"------------------"},{"line_number":171,"context_line":""},{"line_number":172,"context_line":"None."},{"line_number":173,"context_line":""},{"line_number":174,"context_line":"Other deployer impact"},{"line_number":175,"context_line":"---------------------"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_c6506c0d","line":172,"range":{"start_line":172,"start_character":0,"end_line":172,"end_character":5},"updated":"2017-02-12 19:04:32.000000000","message":"There is no performance impact?  The performance is the same as InnoDB?","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":169,"context_line":"Performance Impact"},{"line_number":170,"context_line":"------------------"},{"line_number":171,"context_line":""},{"line_number":172,"context_line":"None."},{"line_number":173,"context_line":""},{"line_number":174,"context_line":"Other deployer impact"},{"line_number":175,"context_line":"---------------------"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_01a8478c","line":172,"range":{"start_line":172,"start_character":0,"end_line":172,"end_character":5},"in_reply_to":"fa31d9ce_c6506c0d","updated":"2017-02-14 22:14:59.000000000","message":"What I\u0027ll put here is that there shouldn\u0027t be any performance impact on the default MySQL InnoDB. For MySQL Cluster, there will be increased performance because of the way it scales and load balances MySQL API requests. I\u0027ll add this to the spec.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"f51355b989adae9ac824dbef9b92edc47ba2f41c","unresolved":false,"context_lines":[{"line_number":216,"context_line":"Work Items"},{"line_number":217,"context_line":"----------"},{"line_number":218,"context_line":""},{"line_number":219,"context_line":"- Implement the changes the SQL Alchemy scripts and the models.py file."},{"line_number":220,"context_line":""},{"line_number":221,"context_line":"Dependencies"},{"line_number":222,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_c5e57bdc","line":219,"updated":"2017-02-14 10:43:54.000000000","message":"\"to the\"?","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":216,"context_line":"Work Items"},{"line_number":217,"context_line":"----------"},{"line_number":218,"context_line":""},{"line_number":219,"context_line":"- Implement the changes the SQL Alchemy scripts and the models.py file."},{"line_number":220,"context_line":""},{"line_number":221,"context_line":"Dependencies"},{"line_number":222,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_61974348","line":219,"in_reply_to":"fa31d9ce_c5e57bdc","updated":"2017-02-14 22:14:59.000000000","message":"Good catch. I\u0027ll fix.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"f51355b989adae9ac824dbef9b92edc47ba2f41c","unresolved":false,"context_lines":[{"line_number":235,"context_line":"Documentation Impact"},{"line_number":236,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":237,"context_line":""},{"line_number":238,"context_line":"Documentation will need to be added to the database configuration section for"},{"line_number":239,"context_line":"the cinder.conf to explain the feature and how to enable it."},{"line_number":240,"context_line":""},{"line_number":241,"context_line":"References"},{"line_number":242,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_a5bde7b8","line":239,"range":{"start_line":238,"start_character":0,"end_line":239,"end_character":60},"updated":"2017-02-14 10:43:54.000000000","message":"We also need developer documentation for that - explaining exactly how to deal with all the stuff listed in \"Developer impact\" section.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":19283,"name":"Octave Orgeron","email":"octave.orgeron@oracle.com","username":"oorgeron"},"change_message_id":"4113f56c2dcf2a15f13d94b4881762769fc43f7a","unresolved":false,"context_lines":[{"line_number":235,"context_line":"Documentation Impact"},{"line_number":236,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":237,"context_line":""},{"line_number":238,"context_line":"Documentation will need to be added to the database configuration section for"},{"line_number":239,"context_line":"the cinder.conf to explain the feature and how to enable it."},{"line_number":240,"context_line":""},{"line_number":241,"context_line":"References"},{"line_number":242,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":3,"id":"fa31d9ce_a19dbb67","line":239,"range":{"start_line":238,"start_character":0,"end_line":239,"end_character":60},"in_reply_to":"fa31d9ce_a5bde7b8","updated":"2017-02-14 22:14:59.000000000","message":"Agreed, I\u0027ll add that to the list.","commit_id":"bcb6903fcca34ce340aeb01873528c0815f9d555"},{"author":{"_account_id":11600,"name":"Michał Dulko","email":"michal.dulko@gmail.com","username":"dulek"},"change_message_id":"82232061823bdc494700731e8547497169475817","unresolved":false,"context_lines":[{"line_number":130,"context_line":" - Create a stub in oslo.db to enable \"with_variant\" functionality"},{"line_number":131,"context_line":"   for table column changes."},{"line_number":132,"context_line":" - Create a stub in oslo.db to transparently change any table create"},{"line_number":133,"context_line":"   or update operations that include \"engine\u003dInnoDB\" to "},{"line_number":134,"context_line":"   \"engine\u003dndbcluster\"."},{"line_number":135,"context_line":" - Reducing the column sizes across service databases where"},{"line_number":136,"context_line":"   appropriate and sensible. Doing this would impact both InnoDB and"}],"source_content_type":"text/x-rst","patch_set":4,"id":"fa31d9ce_13432bb3","line":133,"range":{"start_line":133,"start_character":55,"end_line":133,"end_character":56},"updated":"2017-02-15 09:46:23.000000000","message":"This trailing space is why Jenkins is failing.","commit_id":"8affdd8e2dc97d2227ff7314cc926e1592962c78"},{"author":{"_account_id":11904,"name":"Sean McGinnis","email":"sean.mcginnis@gmail.com","username":"SeanM"},"change_message_id":"295c4168b5ce99eba90ae11764e590c3e724753f","unresolved":false,"context_lines":[{"line_number":79,"context_line":"   cinder.conf file for this enhancement to work. Otherwise, this"},{"line_number":80,"context_line":"   enhancement will default to InnoDB with no change in behavior."},{"line_number":81,"context_line":""},{"line_number":82,"context_line":"Proposed change"},{"line_number":83,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":84,"context_line":""},{"line_number":85,"context_line":" - Enhance oslo.db to add the boolean configuration setting of"}],"source_content_type":"text/x-rst","patch_set":8,"id":"df140735_3f24340d","line":82,"range":{"start_line":82,"start_character":0,"end_line":82,"end_character":15},"updated":"2017-05-29 16:52:36.000000000","message":"All of these proposed chances are for things outside of Cinder. I would like to see this reference the patches to implement those changes and some detail of what actually is proposed to be changed in Cinder to take advantage of them.","commit_id":"3818b30017b387f6f44e55a8656722e1f37ee84f"},{"author":{"_account_id":4523,"name":"Eric Harney","email":"eharney@redhat.com","username":"eharney"},"change_message_id":"d512e54cfeb4e282607fb866266220a48ecfc251","unresolved":false,"context_lines":[{"line_number":181,"context_line":"- migration_status -\u003e String(64)"},{"line_number":182,"context_line":"- replication_status -\u003e String(64)"},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"This logic will be implemented in the 061_cinder_init.py module"},{"line_number":185,"context_line":"This will allow these columns to fit within NDB row limit of"},{"line_number":186,"context_line":"14k characters. It will have zero affect on the default MySQL"},{"line_number":187,"context_line":"InnoDB database schema."}],"source_content_type":"text/x-rst","patch_set":10,"id":"9f6a8fd7_b84a6c24","line":184,"range":{"start_line":184,"start_character":38,"end_line":184,"end_character":56},"updated":"2018-05-02 14:06:45.000000000","message":"This probably won\u0027t work since it means you\u0027ll end up with different schemas for new installs vs upgrades of existing installations.","commit_id":"c66f2ff1cb27510c9ac545185d4d7aacf63ff4b1"},{"author":{"_account_id":11904,"name":"Sean McGinnis","email":"sean.mcginnis@gmail.com","username":"SeanM"},"change_message_id":"c293a7f545427cc06941426b438dacd206065288","unresolved":false,"context_lines":[{"line_number":181,"context_line":"- migration_status -\u003e String(64)"},{"line_number":182,"context_line":"- replication_status -\u003e String(64)"},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"This logic will be implemented in the 061_cinder_init.py module"},{"line_number":185,"context_line":"This will allow these columns to fit within NDB row limit of"},{"line_number":186,"context_line":"14k characters. It will have zero affect on the default MySQL"},{"line_number":187,"context_line":"InnoDB database schema."}],"source_content_type":"text/x-rst","patch_set":10,"id":"9f6a8fd7_18e038fa","line":184,"range":{"start_line":184,"start_character":38,"end_line":184,"end_character":56},"in_reply_to":"9f6a8fd7_b84a6c24","updated":"2018-05-02 14:10:52.000000000","message":"Do we need to worry about upgrades for this? Will we support upgrading from non-clustered to clustered DB instances?","commit_id":"c66f2ff1cb27510c9ac545185d4d7aacf63ff4b1"}]}
