)]}'
{"specs/liberty/sharding-sql.rst":[{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"0dc1e1d810d91985b75b012ce8dbb7a449490e1c","unresolved":false,"context_lines":[{"line_number":21,"context_line":"mysql, or postgres, will not scale to accommodate the data load. In many"},{"line_number":22,"context_line":"enviroments, the amount of data received can be in the order of gigabytes per"},{"line_number":23,"context_line":"minute. To manage this scale, the ability to easily write and read from"},{"line_number":24,"context_line":"multiple databsae instances is required."},{"line_number":25,"context_line":""},{"line_number":26,"context_line":"Proposed change"},{"line_number":27,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":1,"id":"ba3cc151_dddadf16","line":24,"updated":"2015-07-02 14:50:48.000000000","message":"In case you post another: s/bsae/base/","commit_id":"cf52f2ced6c2e09848f5dcd9922e1eaceadf55bb"},{"author":{"_account_id":11819,"name":"Chaoyi Huang","email":"joehuang@huawei.com","username":"joehuang"},"change_message_id":"ed1d80059e73455b337a58abeaab05fa64209fed","unresolved":false,"context_lines":[{"line_number":31,"context_line":"instance, localise queries, and distribute load. Doing so will enable better"},{"line_number":32,"context_line":"write and read response."},{"line_number":33,"context_line":""},{"line_number":34,"context_line":"The shard key will be configured by project_id and resource_id. This seems to"},{"line_number":35,"context_line":"be the main use case for those needing telemetry in production. Using the hash"},{"line_number":36,"context_line":"of those ids, we can bucketise the datapoints into a defined number of shards."},{"line_number":37,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"ba3cc151_aa2dac47","line":34,"updated":"2015-07-01 01:20:18.000000000","message":"if the sharding key is the combination of project_id and resource_id, then if a user issue a query which will ask for data from multiple resources will lead to query multiple sharded DBs (I have no exactly figure how many this kind of query), seems that using project_id is good enough.","commit_id":"cf52f2ced6c2e09848f5dcd9922e1eaceadf55bb"},{"author":{"_account_id":11819,"name":"Chaoyi Huang","email":"joehuang@huawei.com","username":"joehuang"},"change_message_id":"ed1d80059e73455b337a58abeaab05fa64209fed","unresolved":false,"context_lines":[{"line_number":36,"context_line":"of those ids, we can bucketise the datapoints into a defined number of shards."},{"line_number":37,"context_line":""},{"line_number":38,"context_line":"This ability will allow for greater storage capabilities but will also include"},{"line_number":39,"context_line":"some complexities. For one, we do not support adding/dropping shards as the"},{"line_number":40,"context_line":"data is sharded out to specific database instance. Also, the management of"},{"line_number":41,"context_line":"multiple databases will require more management requirements. "},{"line_number":42,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"ba3cc151_0ac5b859","line":39,"updated":"2015-07-01 01:20:18.000000000","message":"Sharding policy could be the job of other management software, so that the cloud admin can simplify the  sharding control and database maintainance.","commit_id":"cf52f2ced6c2e09848f5dcd9922e1eaceadf55bb"},{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"0dc1e1d810d91985b75b012ce8dbb7a449490e1c","unresolved":false,"context_lines":[{"line_number":38,"context_line":"This ability will allow for greater storage capabilities but will also include"},{"line_number":39,"context_line":"some complexities. For one, we do not support adding/dropping shards as the"},{"line_number":40,"context_line":"data is sharded out to specific database instance. Also, the management of"},{"line_number":41,"context_line":"multiple databases will require more management requirements. "},{"line_number":42,"context_line":""},{"line_number":43,"context_line":"Alternatives"},{"line_number":44,"context_line":"------------"}],"source_content_type":"text/x-rst","patch_set":1,"id":"ba3cc151_fdec83bc","line":41,"updated":"2015-07-02 14:50:48.000000000","message":"\"Also, the management of multiple databases will require more management requirements.\"\n\nThis statement is lacking in content.","commit_id":"cf52f2ced6c2e09848f5dcd9922e1eaceadf55bb"},{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"0dc1e1d810d91985b75b012ce8dbb7a449490e1c","unresolved":false,"context_lines":[{"line_number":95,"context_line":"-----------"},{"line_number":96,"context_line":""},{"line_number":97,"context_line":"Primary assignee:"},{"line_number":98,"context_line":"  \u003claunchpad-id or None\u003e"},{"line_number":99,"context_line":""},{"line_number":100,"context_line":"Other contributors:"},{"line_number":101,"context_line":"  \u003claunchpad-id or None\u003e"}],"source_content_type":"text/x-rst","patch_set":1,"id":"ba3cc151_5d0b2f7d","line":98,"updated":"2015-07-02 14:50:48.000000000","message":"something needs to happen here","commit_id":"cf52f2ced6c2e09848f5dcd9922e1eaceadf55bb"}]}