{"action":"created","issue":{"url":"https://api.github.com/repos/quasar-analytics/quasar/issues/2395","repository_url":"https://api.github.com/repos/quasar-analytics/quasar","labels_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/2395/labels{/name}","comments_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/2395/comments","events_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/2395/events","html_url":"https://github.com/quasar-analytics/quasar/issues/2395","id":238235332,"number":2395,"title":"Working with Mongodb Replica Sets","user":{"login":"zeeiyerWork","id":24783629,"avatar_url":"https://avatars0.githubusercontent.com/u/24783629?v=3","gravatar_id":"","url":"https://api.github.com/users/zeeiyerWork","html_url":"https://github.com/zeeiyerWork","followers_url":"https://api.github.com/users/zeeiyerWork/followers","following_url":"https://api.github.com/users/zeeiyerWork/following{/other_user}","gists_url":"https://api.github.com/users/zeeiyerWork/gists{/gist_id}","starred_url":"https://api.github.com/users/zeeiyerWork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zeeiyerWork/subscriptions","organizations_url":"https://api.github.com/users/zeeiyerWork/orgs","repos_url":"https://api.github.com/users/zeeiyerWork/repos","events_url":"https://api.github.com/users/zeeiyerWork/events{/privacy}","received_events_url":"https://api.github.com/users/zeeiyerWork/received_events","type":"User","site_admin":false},"labels":[{"id":589268506,"url":"https://api.github.com/repos/quasar-analytics/quasar/labels/epic:%20Connector:%20MongoDB%20Overhaul","name":"epic: Connector: MongoDB Overhaul","color":"d93f0b","default":false},{"id":493374626,"url":"https://api.github.com/repos/quasar-analytics/quasar/labels/topic:%20MongoDB","name":"topic: MongoDB","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":{"login":"dugdun","id":828514,"avatar_url":"https://avatars1.githubusercontent.com/u/828514?v=3","gravatar_id":"","url":"https://api.github.com/users/dugdun","html_url":"https://github.com/dugdun","followers_url":"https://api.github.com/users/dugdun/followers","following_url":"https://api.github.com/users/dugdun/following{/other_user}","gists_url":"https://api.github.com/users/dugdun/gists{/gist_id}","starred_url":"https://api.github.com/users/dugdun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dugdun/subscriptions","organizations_url":"https://api.github.com/users/dugdun/orgs","repos_url":"https://api.github.com/users/dugdun/repos","events_url":"https://api.github.com/users/dugdun/events{/privacy}","received_events_url":"https://api.github.com/users/dugdun/received_events","type":"User","site_admin":false},"assignees":[{"login":"dugdun","id":828514,"avatar_url":"https://avatars1.githubusercontent.com/u/828514?v=3","gravatar_id":"","url":"https://api.github.com/users/dugdun","html_url":"https://github.com/dugdun","followers_url":"https://api.github.com/users/dugdun/followers","following_url":"https://api.github.com/users/dugdun/following{/other_user}","gists_url":"https://api.github.com/users/dugdun/gists{/gist_id}","starred_url":"https://api.github.com/users/dugdun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dugdun/subscriptions","organizations_url":"https://api.github.com/users/dugdun/orgs","repos_url":"https://api.github.com/users/dugdun/repos","events_url":"https://api.github.com/users/dugdun/events{/privacy}","received_events_url":"https://api.github.com/users/dugdun/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/quasar-analytics/quasar/milestones/19","html_url":"https://github.com/quasar-analytics/quasar/milestone/19","labels_url":"https://api.github.com/repos/quasar-analytics/quasar/milestones/19/labels","id":2394000,"number":19,"title":"August2017","description":"Work that will happen in the July iteration","creator":{"login":"zeeiyerWork","id":24783629,"avatar_url":"https://avatars0.githubusercontent.com/u/24783629?v=3","gravatar_id":"","url":"https://api.github.com/users/zeeiyerWork","html_url":"https://github.com/zeeiyerWork","followers_url":"https://api.github.com/users/zeeiyerWork/followers","following_url":"https://api.github.com/users/zeeiyerWork/following{/other_user}","gists_url":"https://api.github.com/users/zeeiyerWork/gists{/gist_id}","starred_url":"https://api.github.com/users/zeeiyerWork/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zeeiyerWork/subscriptions","organizations_url":"https://api.github.com/users/zeeiyerWork/orgs","repos_url":"https://api.github.com/users/zeeiyerWork/repos","events_url":"https://api.github.com/users/zeeiyerWork/events{/privacy}","received_events_url":"https://api.github.com/users/zeeiyerWork/received_events","type":"User","site_admin":false},"open_issues":34,"closed_issues":1,"state":"open","created_at":"2017-03-17T16:38:08Z","updated_at":"2017-06-30T00:38:28Z","due_on":"2017-08-31T07:00:00Z","closed_at":null},"comments":12,"created_at":"2017-06-23T19:39:38Z","updated_at":"2017-06-30T18:58:06Z","closed_at":null,"body":"Most Production Mongo deployments are executed as [replica sets.](https://docs.mongodb.com/manual/replication/)\r\n\r\nIn this case:\r\n- Our documentation needs to be updated to advise users on how to connect with the replica set (since a primary host may go down and be taken over by a secondary). The best practice for analytics is often to run an additional hidden node that is divorced from the nodes participating in the HA play. See [this blog](https://blog.mlab.com/2016/10/configuring-a-mongodb-replica-set-for-analytics/), for example.\r\n\r\n- Further, Mongodb allows queries to go against primary or secondary (for queries that may tolerate replication delays). Has such a requirement ever been voiced, where the end-user selectively wishes to execute some queries against Primary (for real-time data analytics) and some against Secondary (or Hidden) for queries that can tolerate delays. If so, do we need to handle it in our new Mongo connector implementation? \r\n\r\n@damonLL , @dugdun , @jdegoes -> Please opine."},"comment":{"url":"https://api.github.com/repos/quasar-analytics/quasar/issues/comments/312347811","html_url":"https://github.com/quasar-analytics/quasar/issues/2395#issuecomment-312347811","issue_url":"https://api.github.com/repos/quasar-analytics/quasar/issues/2395","id":312347811,"user":{"login":"dugdun","id":828514,"avatar_url":"https://avatars1.githubusercontent.com/u/828514?v=3","gravatar_id":"","url":"https://api.github.com/users/dugdun","html_url":"https://github.com/dugdun","followers_url":"https://api.github.com/users/dugdun/followers","following_url":"https://api.github.com/users/dugdun/following{/other_user}","gists_url":"https://api.github.com/users/dugdun/gists{/gist_id}","starred_url":"https://api.github.com/users/dugdun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dugdun/subscriptions","organizations_url":"https://api.github.com/users/dugdun/orgs","repos_url":"https://api.github.com/users/dugdun/repos","events_url":"https://api.github.com/users/dugdun/events{/privacy}","received_events_url":"https://api.github.com/users/dugdun/received_events","type":"User","site_admin":false},"created_at":"2017-06-30T18:58:06Z","updated_at":"2017-06-30T18:58:06Z","body":"It seems that even though we can use the settings area to pass in `readPreference` and a value of `secondary`, it doesn't seem that MongoDB will read from a secondary instance. I even stopped two of the three nodes so the remaining instance is forced to be a secondary node and I get a timeout error because it's trying to access the primary instance. Are we forcing the `readPreference` to be `primary`? I'll log a quasar issue about this.\r\n\r\nIt also appears that you have have a secure instance and pass in credentials if you want to pass in extra key/values via the settings interface. I'll do more testing around this to verify and enter an issue if necessary.\r\n\r\nUntil we can read from the secondary instance, I can't test that the above situations to verify that they work as expected."}}
{"actor":{"display_login":"dugdun"}}