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: BSR <dheer.91@xxxxxxxxx>
Date: Thu, 24 Aug 2017 21:48:27 -0700 (PDT)
Delivery-date: Fri, 25 Aug 2017 00:48:37 -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=yCrtmDG5mPyCyHl81vsM3yNoXfc3b4aq6/w1A5EctyY=; b=FY8ilWal9ZG8GOLBuv5rcOZ+kgTejVdJ1rUh0k89o9rrQbhNkelAc+HNaGB8CFRLU/ /TQH8ZLdjwTzvjHDWW8PtyMcJ+wkBi46rcSPR/BCC5QavSWrg489SaTIawrsEtV0aDDA 94/zwcW09Vwi/Zk+aX4mJ8d7rSqtfiGBd7P2sS1qly8RU2vcbKjSJyuVwc+OhKTHgRhh /xzrRmZVhv604FAHa79ZTwiAjOXFln99tJuQEjl5LRTBeW+Py/YPV5NXCknXuqET7cb/ TyF73h2zMfF5Q167I7s35FQQy2Ma7TBJpzktihmVFJrlBC2X/4Hog8ZnOTW4ACuzcDHW /59Q==
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=yCrtmDG5mPyCyHl81vsM3yNoXfc3b4aq6/w1A5EctyY=; b=XPwXTjLZSUkOLnexOKFdanDqpgrVyEPVZtfChgEr1OXOfxtbNdknl53qoHhAjnvG4x WQ5QlpQU8AJHq8RhI1jZ1YiFQUbJiQW8bcxVZCv/0EK7pkitdc7EE9SECbnNylS2juxO vEqwJCD++1/nWfdUxp2vABlStOmyFRaHlmL7rtcMru7OZk1E2bjdgLme6re4YbNPrJP6 73BJDx32gyRH5fPJXIeavOx85ExWCwoJt9Sqrl62yUzE4jzkaux72pHH5FOhk6rgzhKI vKJmyClsUG5CHL96hxe9XK5PeKZsCjw8UwQI+nUOIKYca6pRnAJrBv2A+yd1QN7x2aq4 MQ4Q==
Envelope-to: traductor@xxxxxxxxxxx
In-reply-to: <b3144f97-d354-4397-acf7-5f7303782270@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>
Reply-to: mongodb-user@xxxxxxxxxxxxxxxx
Sender: mongodb-user@xxxxxxxxxxxxxxxx
*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/6*c944*f0*b-*d351-4*b06-9639-*c36*c187*f5815%40*googlegroups.*com.
Para más opciones, visita *https://grupos.*google.*com/*d/*optout.
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/6c944f0b-d351-4b06-9639-c36c187f5815%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Anterior por Tema] Tema Actual [Siguiente por Tema>