mongodb-user
[Arriba] [Todas las Listas]

[mongodb-Usuario] Re: Conectando Mongodb BI connector a esclavo en repli

To: mongodb-user <mongodb-user@xxxxxxxxxxxxxxxx>
Subject: [mongodb-Usuario] Re: Conectando Mongodb BI connector a esclavo en replica conjunto
From: "B.S.Reddy" <dheer.91@xxxxxxxxx>
Date: Fri, 25 Aug 2017 09:00:00 -0700 (PDT)
Delivery-date: Fri, 25 Aug 2017 12:00:10 -0400
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20161025; h=sender:date:from:to:message-id:in-reply-to:references:subject :mime-version:x-original-sender:reply-to:precedence:mailing-list :list-id:list-post:list-help:list-archive:list-subscribe :list-unsubscribe; bh=atZG7YlRykTQlHi2IDsLFEViXbtDBFIr5xQdSEAZvw8=; b=Kw98zKO/Lt127UFA9N4+TmcKtGyw6wUVM18uAehcSuVYbiidkVMO718C/krkEMQCev GSqtufThhIWY6wwDNaEcu/cKHRZVHvOLrj0NrVp9bQyHMxi2IVzmBnWuUibauByVqRJT matYZjjOnuNdTbinVjIpMT9Zaz3+upRucfIyT2chaPllRs0enXQjjJ324nx146VRpYOu 294GGtmYPzLcN4VYBTDdeZ2RVOpeoUzeNdVe19Oq7NmN0ljCVLW2BL1kJ0avfiJ5ztoE KIq5DG3OFN6V+lHyzlxPSPlCHb0w6K1xgOlzehqzo1NPn7PyoAxujw1ajKtevHehXg4b LKjg==
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:message-id:in-reply-to:references:subject:mime-version :x-original-sender:reply-to:precedence:mailing-list:list-id :list-post:list-help:list-archive:list-subscribe:list-unsubscribe; bh=atZG7YlRykTQlHi2IDsLFEViXbtDBFIr5xQdSEAZvw8=; b=DLvLJerqF6NxxHY8grxX1y0xUPG3QuLA1+6G9yAr1Jqc3xs7MTOPtyE9iWOkXo66C5 ZBTsoUmcx/e53SkuEXjRs7lpWw206CYJ2KdBj6G/lcGsjlrFXrumYJkkY6yn7yHjgC0+ w9LNMJOJf/By63Y/7iok7SVB448bhTlEqoogYOz3U7tCZIm4zzrDC9bQgHls5kpXo+J7 zJt41tpsixhqrY7Wq77yk6io5Ag4FSbyzUyixC1EI58U7QQ8gNHBV2BzMthNldYUOk0y RVHSTk7qz6UK/8ydUE56ErzKsnNG79cbYMmEe5Q07fKvYjmYVy5hAkzeNBe4OM/QmaFh bX2w==
Envelope-to: traductor@xxxxxxxxxxx
In-reply-to: <7ad04562-e52c-4546-8d45-e43455c18d21@googlegroups.com>
List-archive: <https://groups.google.com/group/mongodb-use>
List-help: <https://groups.google.com/support/>, <mailto:mongodb-user+help@googlegroups.com>
List-id: <mongodb-user.googlegroups.com>
List-post: <https://groups.google.com/group/mongodb-user/post>, <mailto:mongodb-user@googlegroups.com>
List-subscribe: <https://groups.google.com/group/mongodb-user/subscribe>, <mailto:mongodb-user+subscribe@googlegroups.com>
List-unsubscribe: <mailto:googlegroups-manage+1044811755470+unsubscribe@googlegroups.com>, <https://groups.google.com/group/mongodb-user/subscribe>
Mailing-list: list mongodb-user@xxxxxxxxxxxxxxxx; contact mongodb-user+owners@xxxxxxxxxxxxxxxx
References: <ffbba07a-206e-4cc8-98ac-c788d1aab596@googlegroups.com> <6f3272f5-da25-4acf-95e7-8641e67ec377@googlegroups.com> <741975be-77c8-4dd1-a907-104d6a9b2838@googlegroups.com> <b3144f97-d354-4397-acf7-5f7303782270@googlegroups.com> <6c944f0b-d351-4b06-9639-c36c187f5815@googlegroups.com> <7ad04562-e52c-4546-8d45-e43455c18d21@googlegroups.com>
Reply-to: mongodb-user@xxxxxxxxxxxxxxxx
Sender: mongodb-user@xxxxxxxxxxxxxxxx
*thanks  *craig Para vuestras respuestas rápidas 

En viernes, 25 agosto 2017 07:56:27 *UTC-7, Craig Wilson escribió:
>
> Correcto... Detectaremos que es un *replica conjunto y descubrir todo los 
> otros miembros. Prueba esto:
>
> **mongodb://*mong02.*sub.*biz:27017 
> <*http://*mong02.*sub.*biz:27017/>/?Conecta=solo*
>
> También parece seremos liberar #uno 2.2.1 *patch en algún momento la semana próxima 
> proporcionó nuestro probando va *ok.
>
> En jueves, agosto 24, 2017 en 11:48:27 PM *UTC-5, *B.*S.*Reddy Escribió:
>>
>> *Hi,
>>
>> *thanks para la respuesta rápida, cómo tener que *i conectarlo a él directamente?
>>
>> Cuándo *i uso *uri tan abajo  las consultas todavía están yendo a primario(*mong04) 
>> en vez de pegar *mong02
>>
>> **mongodb://*mong02.*sub.*biz:27017 <*http://*mong02.*sub.*biz:27017/>*
>>
>>
>>
>> En jueves, 24 agosto 2017 17:03:55 *UTC-7, Craig Wilson escribió:
>>>
>>> *Hi BSR,
>>>
>>> tuvimos un *bug relacionado a *readPreferenceTags. Ha sido fijado como de ayer 
>>> y será en #uno 2.2.1 *patch liberación. No tengo una ETA en 
>>> aquello. Mientras tanto, continúa probar sin *tags y tendríamos que tener 
>>> 2.2.1 fuera de antes de que lo necesitas para producción. Si todavía sólo tienes que conectar 
>>> a la caja sola durante probar, entonces justo conectar directamente a él. 
>>>
>>> *Sorry '*bout El *bug,
>>> Craig
>>>
>>> En jueves, agosto 24, 2017 en 4:11:04 PM *UTC-5, el BSR escribió:
>>>>
>>>> estamos evaluando  *mongodb BI *connector en nuestro *Dev *enviroment ,y afrontando 
>>>> el abajo asunto , sería grande si nos puedes ayudar 
>>>>
>>>>  estoy utilizando abajo *URI opción en *mongosqld.*conf Archivo de modo que todo lee 
>>>> punto a *mong02 cuál ha *tags "uso:informando"  (mencionado *rs.*conf() Producción 
>>>> abajo):
>>>> **mongodb:*
>>>> * red:*
>>>> *  *uri: *mongodb://*mong02.*sub.*biz:27017 
>>>> <*http://*mong02.*sub.*biz:27017>,*mong03.*sub.*biz:27017 
>>>> <*http://*mong03.*sub.*biz:27017>,*mong04.*sub.*biz:27017/?*replicaSet=*s1-*rs1&*readPreference=secundario&*readPreferenceTags=uso:informando 
>>>> <*http://*mong04.*sub.*biz:27017/?*replicaSet=*s1-*rs1&*readPreference=secundario&*readPreferenceTags=uso:informando>*
>>>>
>>>> cuándo *i prueba conectar a *mongosqld utilizando *mysql cliente *i estoy consiguiendo 
>>>> abajo error: 
>>>>
>>>> *"ERROR 2013 (*HY000): conexión Perdida a *MySQL *server en 'leyendo 
>>>> paquete de comunicación inicial', error de sistema: 0"*
>>>>
>>>> pero si uso *primaryPreferred gusta abajo *i soy capaz de conectar de *mysql 
>>>> cliente, pero las consultas no están siendo dirigidas a *mong02(secundario) en cambio 
>>>> están corriendo en máquina primaria (*mong04) así que algunos preferencia qué leída 
>>>> *tags no está jugando una función aquí
>>>>
>>>> **mongodb:*
>>>> * red:*
>>>> *  *uri: *mongodb://*mong02.*sub.*biz:27017 
>>>> <*http://*mong02.*sub.*biz:27017>,*mong03.*sub.*biz:27017 
>>>> <*http://*mong03.*sub.*biz:27017>,*mong04.*sub.*biz:27017/?*replicaSet=*s1-*rs1&*readPreference=*primaryPreferred&*readPreferenceTags=uso:informando 
>>>> <*http://*mong04.*sub.*biz:27017/?*replicaSet=*s1-*rs1&*readPreference=*primaryPreferred&*readPreferenceTags=uso:informando>*
>>>>
>>>> Si *i totalmente sacar *readPreferenceTags opción , *i soy habiendo ningún asunto 
>>>> en conectar pero mi requisito es para señalar todo lee de BI *connector a único 
>>>> *Mong02 máquina (cuál es  un secundario con prioridad 0)
>>>>
>>>>
>>>> */* 1*
>>>> *    "_#unknown{^*id" : "*s1-*rs1",*
>>>> *    "versión" : 23,*
>>>> *    "*protocolVersion" : *NumberLong(1),*
>>>> *    "miembros" : [*
>>>> *            "_#unknown{^*id" : 1,*
>>>> *            "anfitrión" : "*mong03.*sub.*biz:27017 
>>>> <*http://*mong03.*sub.*biz:27017>",*
>>>> *            "*arbiterOnly" : falso,*
>>>> *            "*buildIndexes" : cierto,*
>>>> *            "escondido" : falso,*
>>>> *            "prioridad" : 1.0,*
>>>> *            "*tags" :*
>>>> *                "#nom" : "producción"*
>>>> *            },*
>>>> *            "*slaveDelay" : *NumberLong(0),*
>>>> *            "votos" : 1*
>>>> *        },*
>>>> *            "_#unknown{^*id" : 2,*
>>>> *            "anfitrión" : "*mong04.*sub.*biz:27017 
>>>> <*http://*mong04.*sub.*biz:27017>",*
>>>> *            "*arbiterOnly" : falso,*
>>>> *            "*buildIndexes" : cierto,*
>>>> *            "escondido" : falso,*
>>>> *            "prioridad" : 1.0,*
>>>> *            "*tags" :*
>>>> *                "#nom" : "secundario2"*
>>>> *            },*
>>>> *            "*slaveDelay" : *NumberLong(0),*
>>>> *            "votos" : 1*
>>>> *        },*
>>>> *            "_#unknown{^*id" : 3,*
>>>> *            "anfitrión" : "*mong02.*sub.*biz:27017 
>>>> <*http://*mong02.*sub.*biz:27017>",*
>>>> *            "*arbiterOnly" : falso,*
>>>> *            "*buildIndexes" : cierto,*
>>>> *            "escondido" : falso,*
>>>> *            "prioridad" : 0.0,*
>>>> *            "*tags" :*
>>>> *                "#nom" : "informando"*
>>>> *            },*
>>>> *            "*slaveDelay" : *NumberLong(0),*
>>>> *            "votos" : 1*
>>>> *        }*
>>>> *    ],*
>>>> *    "*settings" :*
>>>> *        "#unknown{^*chainingAllowed" : cierto,*
>>>> *        "*heartbeatIntervalMillis" : 2000,*
>>>> *        "*heartbeatTimeoutSecs" : 10,*
>>>> *        "*electionTimeoutMillis" : 10000,*
>>>> *        "*catchUpTimeoutMillis" : 2000,*
>>>> *        "*getLastErrorModes" : {},*
>>>> *        "*getLastErrorDefaults" :*
>>>> *            "#unknown{^*w" : 1,*
>>>> *            "*wtimeout" : 0*
>>>> *        },*
>>>> *        "*replicaSetId" : *ObjectId("58742*e1*ed639*ab53#uno840*ba48")*
>>>> *    }*
>>>> *}*
>>>>
>>>>
>>>>
>>>> En miércoles, 23 agosto 2017 17:04:08 *UTC-7, *Wan *Bachtiar escribió:
>>>>>
>>>>> complacer sugerir en cómo para hacer las consultas que vienen #por *mysqld pega sólo 
>>>>> leído *replica copia 
>>>>>
>>>>> *Hi, 
>>>>>
>>>>> *MongoDB *Connector para BI *mongosqld proporciona una opción —*mongo-*uri 
>>>>> <*https://*docs.*mongodb.*com/*bi-*connector/Referencia/maestra/*mongosqld/#*cmdoption-*mongo-*uri> para 
>>>>> especificar conexión *URI 
>>>>> <*https://*docs.*mongodb.*com/Conexión/de referencia/manual-cadena/#*mongodb-*uri> 
>>>>> que apoya Opciones de Preferencia Leída 
>>>>> <*https://*docs.*mongodb.*com/Conexión/de referencia/manual-conexiones/#de cadena-leído-preferencia> 
>>>>> para *readPreference y/o *readPreferenceTags
>>>>>
>>>>> el Valor que menciona que *MongoDB *Connector para el BI es disponible con *MongoDB 
>>>>> Empresa 
>>>>> <*https://www.mongodb.com/productos/*mongodb-empresa-adelantado> *v3.2+. 
>>>>> Si vuestra empresa o la organización ya tiene una suscripción de apoyo 
>>>>> comercial y tú han más allá cuestiona recomendaría abrir un 
>>>>> caso en el Portal de Apoyo Comercial <*http://apoyo.*mongodb.*com> 
>>>>> Incluyendo con el siguiendo información: 
>>>>>
>>>>>    - *MongoDB *Connector para versión de BI que tú’*re utilizando 
>>>>>    - Las opciones que especificas para ejecutar *mongosqld 
>>>>>
>>>>> *Alternatively, si estás evaluando *MongoDB la Empresa complace sentir 
>>>>> libre de enviarme un mensaje privado con vuestros detalles de contacto, puedo pedir 
>>>>> un *MongoDB Ejecutivo de Cuenta para contactarte.
>>>>>
>>>>> Consideraciones,
>>>>> *Wan. 
>>>>> ​
>>>>>
>>>>

-- 
Recibiste este mensaje porque eres *subscribed al *Google Grupos "*mongodb-grupo"
de usuario.

Para otro *MongoDB opciones de apoyo técnico, ve: *https://*docs.*mongodb.*com/Apoyo/manual/
--- 
recibiste este mensaje porque eres *subscribed al *Google Grupos "*mongodb-grupo" de usuario.
A *unsubscribe de este grupo y la parón que recibe *emails de él, enviar un *email a *mongodb-usuario+unsubscribe@xxxxxxxxxxxxxxxx.
A correo a este grupo, envía *email a *mongodb-user@xxxxxxxxxxxxxxxx.
Visita este grupo en *https://grupos.*google.*com/Grupo/*mongodb-usuario.
Para ver esta discusión en la visita de web *https://grupos.*google.*com/*d/*msgid/*mongodb-Usuario/03*bd8*f40-027*b-40#uno2-83*d8-*d5#uno3*dd5*b0#uno17%40*googlegroups.*com.
Para más opciones, visita *https://grupos.*google.*com/*d/*optout.
thanks craig  for your quick responses 

On Friday, 25 August 2017 07:56:27 UTC-7, Craig Wilson wrote:
>
> Right... we'll detect that it's a replica set and discover all the other 
> members. Try this:
>
> *mongodb://mong02.sub.biz:27017 
> <http://mong02.sub.biz:27017/>/?connect=single*
>
> Also looks like we will be releasing a 2.2.1 patch sometime next week 
> provided our testing goes ok.
>
> On Thursday, August 24, 2017 at 11:48:27 PM UTC-5, B.S.Reddy wrote:
>>
>> Hi,
>>
>> thanks for the quick response, how should i connect it to it directly?
>>
>> when i use uri as below  the queries are still going to primary(mong04) 
>> instead of hitting mong02
>>
>> *mongodb://mong02.sub.biz:27017 <http://mong02.sub.biz:27017/>*
>>
>>
>>
>> On Thursday, 24 August 2017 17:03:55 UTC-7, Craig Wilson wrote:
>>>
>>> Hi BSR,
>>>
>>> We had a bug related to readPreferenceTags. It has been fixed as of 
>>> yesterday and will be in a 2.2.1 patch release. I don't have an ETA on 
>>> that. In the meantime, continue testing without tags and we should have 
>>> 2.2.1 out before you need it for production. If you still must only connect 
>>> to the single box during testing, then just connect directly to it. 
>>>
>>> Sorry 'bout the bug,
>>> Craig
>>>
>>> On Thursday, August 24, 2017 at 4:11:04 PM UTC-5, BSR wrote:
>>>>
>>>> we are evaluating  mongodb BI connector in our Dev enviroment ,and 
>>>> facing the below issue , it would be great if you can help us 
>>>>
>>>>  I am using below URI option in mongosqld.conf file so that all reads 
>>>> point to mong02 which has tags "use:reporting"  (mentioned rs.conf() output 
>>>> below):
>>>> *mongodb:*
>>>> * net:*
>>>> *  uri: mongodb://mong02.sub.biz:27017 
>>>> <http://mong02.sub.biz:27017>,mong03.sub.biz:27017 
>>>> <http://mong03.sub.biz:27017>,mong04.sub.biz:27017/?replicaSet=s1-rs1&readPreference=secondary&readPreferenceTags=use:reporting 
>>>> <http://mong04.sub.biz:27017/?replicaSet=s1-rs1&readPreference=secondary&readPreferenceTags=use:reporting>*
>>>>
>>>> when i try connecting to mongosqld using mysql client i am getting 
>>>> below error: 
>>>>
>>>> *"ERROR 2013 (HY000): Lost connection to MySQL server at 'reading 
>>>> initial communication packet', system error: 0"*
>>>>
>>>> but if use primaryPreferred like below i am able to connect from mysql 
>>>> client, but the queries are not being directed to mong02(secondary) instead 
>>>> they are running on primary machine (mong04) so some how read preference 
>>>> tags is not playing a role here
>>>>
>>>> *mongodb:*
>>>> * net:*
>>>> *  uri: mongodb://mong02.sub.biz:27017 
>>>> <http://mong02.sub.biz:27017>,mong03.sub.biz:27017 
>>>> <http://mong03.sub.biz:27017>,mong04.sub.biz:27017/?replicaSet=s1-rs1&readPreference=primaryPreferred&readPreferenceTags=use:reporting 
>>>> <http://mong04.sub.biz:27017/?replicaSet=s1-rs1&readPreference=primaryPreferred&readPreferenceTags=use:reporting>*
>>>>
>>>> If i totally remove readPreferenceTags option , i am having no issues 
>>>> in connecting but my requirement is to point all reads from BI connector to 
>>>> only Mong02 machine (which is  a secondary with priority 0)
>>>>
>>>>
>>>> */* 1 */*
>>>> *{*
>>>> *    "_id" : "s1-rs1",*
>>>> *    "version" : 23,*
>>>> *    "protocolVersion" : NumberLong(1),*
>>>> *    "members" : [ *
>>>> *        {*
>>>> *            "_id" : 1,*
>>>> *            "host" : "mong03.sub.biz:27017 
>>>> <http://mong03.sub.biz:27017>",*
>>>> *            "arbiterOnly" : false,*
>>>> *            "buildIndexes" : true,*
>>>> *            "hidden" : false,*
>>>> *            "priority" : 1.0,*
>>>> *            "tags" : {*
>>>> *                "use" : "production"*
>>>> *            },*
>>>> *            "slaveDelay" : NumberLong(0),*
>>>> *            "votes" : 1*
>>>> *        }, *
>>>> *        {*
>>>> *            "_id" : 2,*
>>>> *            "host" : "mong04.sub.biz:27017 
>>>> <http://mong04.sub.biz:27017>",*
>>>> *            "arbiterOnly" : false,*
>>>> *            "buildIndexes" : true,*
>>>> *            "hidden" : false,*
>>>> *            "priority" : 1.0,*
>>>> *            "tags" : {*
>>>> *                "use" : "secondary2"*
>>>> *            },*
>>>> *            "slaveDelay" : NumberLong(0),*
>>>> *            "votes" : 1*
>>>> *        }, *
>>>> *        {*
>>>> *            "_id" : 3,*
>>>> *            "host" : "mong02.sub.biz:27017 
>>>> <http://mong02.sub.biz:27017>",*
>>>> *            "arbiterOnly" : false,*
>>>> *            "buildIndexes" : true,*
>>>> *            "hidden" : false,*
>>>> *            "priority" : 0.0,*
>>>> *            "tags" : {*
>>>> *                "use" : "reporting"*
>>>> *            },*
>>>> *            "slaveDelay" : NumberLong(0),*
>>>> *            "votes" : 1*
>>>> *        }*
>>>> *    ],*
>>>> *    "settings" : {*
>>>> *        "chainingAllowed" : true,*
>>>> *        "heartbeatIntervalMillis" : 2000,*
>>>> *        "heartbeatTimeoutSecs" : 10,*
>>>> *        "electionTimeoutMillis" : 10000,*
>>>> *        "catchUpTimeoutMillis" : 2000,*
>>>> *        "getLastErrorModes" : {},*
>>>> *        "getLastErrorDefaults" : {*
>>>> *            "w" : 1,*
>>>> *            "wtimeout" : 0*
>>>> *        },*
>>>> *        "replicaSetId" : ObjectId("58742e1ed639ab53a840ba48")*
>>>> *    }*
>>>> *}*
>>>>
>>>>
>>>>
>>>> On Wednesday, 23 August 2017 17:04:08 UTC-7, Wan Bachtiar wrote:
>>>>>
>>>>> please suggest on how to make queries coming through mysqld hit only 
>>>>> read replica copy 
>>>>>
>>>>> Hi, 
>>>>>
>>>>> MongoDB Connector for BI mongosqld provides an option —mongo-uri 
>>>>> <https://docs.mongodb.com/bi-connector/master/reference/mongosqld/#cmdoption-mongo-uri> to 
>>>>> specify connection URI 
>>>>> <https://docs.mongodb.com/manual/reference/connection-string/#mongodb-uri> 
>>>>> which supports Read Preference Options 
>>>>> <https://docs.mongodb.com/manual/reference/connection-string/#connections-read-preference> 
>>>>> for readPreference and/or readPreferenceTags
>>>>>
>>>>> Worth mentioning that MongoDB Connector for BI is available with MongoDB 
>>>>> Enterprise 
>>>>> <https://www.mongodb.com/products/mongodb-enterprise-advanced> v3.2+. 
>>>>> If your company or organisation already has a commercial support 
>>>>> subscription and you have further questions I would recommend to open a 
>>>>> case in the Commercial Support Portal <http://support.mongodb.com> 
>>>>> including with the following information: 
>>>>>
>>>>>    - MongoDB Connector for BI version that you’re using 
>>>>>    - The options that you specify to execute mongosqld 
>>>>>
>>>>> Alternatively, if you are evaluating MongoDB Enterprise please feel 
>>>>> free to send me a private message with your contact details, I can request 
>>>>> a MongoDB Account Executive to contact you.
>>>>>
>>>>> Regards,
>>>>> Wan. 
>>>>> ​
>>>>>
>>>>

-- 
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.

For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
--- 
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user+unsubscribe@xxxxxxxxxxxxxxxx.
To post to this group, send email to mongodb-user@xxxxxxxxxxxxxxxx.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/03bd8f40-027b-40a2-83d8-d5a3dd5b0a17%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Anterior por Tema] Tema Actual [Siguiente por Tema>