mongodb-user
[Arriba] [Todas las Listas]

[mongodb-Usuario] Conectando Mongodb BI connector a esclavo en replica c

To: mongodb-user <mongodb-user@xxxxxxxxxxxxxxxx>
Subject: [mongodb-Usuario] Conectando Mongodb BI connector a esclavo en replica conjunto
From: BSR <dheer.91@xxxxxxxxx>
Date: Fri, 18 Aug 2017 17:16:19 -0700 (PDT)
Delivery-date: Fri, 18 Aug 2017 20:16:29 -0400
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlegroups.com; s=20161025; h=sender:date:from:to:message-id:subject:mime-version :x-original-sender:reply-to:precedence:mailing-list:list-id :list-post:list-help:list-archive:list-subscribe:list-unsubscribe; bh=dNrZc+jf2ZDiNOU134G2TYL6WgkflitvtZ7zG7f4Dik=; b=opx0H9LyP7ahHXCnbgtL+qhoUU8Dm8S3UV+AqS66FclB85ty6/w000y5EOvVUw2/up qD87pVmq8AHAg1gYGkEkhrAIHawZvNrOEm1ezMACl7oXEP5DBWfON8ZRb75W78rBUPCj sGVzJTaky+9Ew4LmSkpf1AcGIiEJiJgdNPIbAwxzB1NyxArYd8jZeQ4HI4crr7ngyoh9 EKojam5MP1a8PbVpJg28lPuFr7QI0LzFqx6sFqVBa1pdgv8Wpthwxi3/pH9qbsgcy4es OfvDUBU7Lnn5OrL9Z92BxymM34ihFtYh8BtsEDPASb9+oG/pDggiNpsmV2KDIVXgZVLc rasw==
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=date:from:to:message-id:subject:mime-version:x-original-sender :reply-to:precedence:mailing-list:list-id:list-post:list-help :list-archive:list-subscribe:list-unsubscribe; bh=dNrZc+jf2ZDiNOU134G2TYL6WgkflitvtZ7zG7f4Dik=; b=RGXm3qc3PBpVmNf0FHLhsAdMqJUCfSbyDLHbOltTeN55uDXB1MZN+9Y3rAjy9vEtu6 JYM9c34ChFhUu+D3a+DZYIP3FG8DebEYMwcDYJvPpgNqCrQ2Ldf1JVsbsf55sCx0ePVj Ap4lgHaiIKHA69CE/Vqrm5pDwLtWXhrmc+v7G2KRdq248KCD07Fq1RNIdt+1z0Qs2Epz gTgxhWrOPHhJ/Ov5WuQAK54pXyKgL8BWwJtMn40Pavwx3Ovx3du4TYrFp526/dMkODQA 8ILZPzPc6Sz7Hp1Pvqwjkg2Kj7P9UFt8K2HYcs1liVfxpBpVRLmdmA64V2JISMVnDFAw beqw==
Envelope-to: traductor@xxxxxxxxxxx
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
Reply-to: mongodb-user@xxxxxxxxxxxxxxxx
Sender: mongodb-user@xxxxxxxxxxxxxxxx
*Hi,

tengo 3 nodo *replica puso *setup , con uno del propósito de nodo está informando 
recientemente he instalado *mongodb *Bi *connector en *server *zzzzz que es un 
*replica(prioridad *zero)
cuándo *i ejecutar consultas por conectar a *mysqld , las consultas están siendo 
dirigidas a primario *server de *replica conjunto en vez de utilizar el leído *replica 
la copia

complace sugerir en cómo para hacer las consultas que vienen #por *mysqld pega sólo leído 
*replica copia 

*rs.*conf() Producción abajo
    "_#unknown{^*id" : "*s1-*rs1",
    "versión" : 9,
    "*protocolVersion" : *NumberLong(1),
    "miembros" : [
            "_#unknown{^*id" : 1,
            "anfitrión" : "*xxxxx",
            "*arbiterOnly" : falso,
            "*buildIndexes" : cierto,
            "escondido" : falso,
            "prioridad" : 1.0,
            "*tags" :
                "#nom" : "producción"
            },
            "*slaveDelay" : *NumberLong(0),
            "votos" : 1
        },
            "_#unknown{^*id" : 2,
            "anfitrión" : "*yyy",
            "*arbiterOnly" : falso,
            "*buildIndexes" : cierto,
            "escondido" : falso,
            "prioridad" : 1.0,
            "*tags" :
                "#nom" : "producción"
            },
            "*slaveDelay" : *NumberLong(0),
            "votos" : 1
        },
            "_#unknown{^*id" : 3,
            "anfitrión" : "*zzzzz",
            "*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")
    }
}

-- 
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/*ffbba07un-206*e-4*cc8-98*ac-*c788*d1*aab596%40*googlegroups.*com.
Para más opciones, visita *https://grupos.*google.*com/*d/*optout.
Hi,

I have 3 node replica set setup , with one of the node purpose is reporting 
I have recently installed mongodb Bi connector on server zzzzz which is a 
replica(priority zero)
when i execute queries by connecting to mysqld , the queries are being 
directed to primary server of replica set instead of using the read replica 
copy

please suggest on how to make queries coming through mysqld hit only read 
replica copy 

rs.conf() output below

{
    "_id" : "s1-rs1",
    "version" : 9,
    "protocolVersion" : NumberLong(1),
    "members" : [ 
        {
            "_id" : 1,
            "host" : "xxxxx",
            "arbiterOnly" : false,
            "buildIndexes" : true,
            "hidden" : false,
            "priority" : 1.0,
            "tags" : {
                "use" : "production"
            },
            "slaveDelay" : NumberLong(0),
            "votes" : 1
        }, 
        {
            "_id" : 2,
            "host" : "yyy",
            "arbiterOnly" : false,
            "buildIndexes" : true,
            "hidden" : false,
            "priority" : 1.0,
            "tags" : {
                "use" : "production"
            },
            "slaveDelay" : NumberLong(0),
            "votes" : 1
        }, 
        {
            "_id" : 3,
            "host" : "zzzzz",
            "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")
    }
}

-- 
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/ffbba07a-206e-4cc8-98ac-c788d1aab596%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Anterior por Tema] Tema Actual [Siguiente por Tema>