How ReplicationDriver works

⇧

⇩

48 views

I am curious how com.mysql.jdbc.ReplicationDriver works. I have configuration with 1master & 1slave.

I want to force some queries to JUST on slave. But it selects DB randomly and sometimes run it on master.

Is it a way to force readonly connection to use just slave DB and never master?

java mysql jdbc replication

asked June 16, 2011 6:02 am CDT

Alexey

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

realm authentication no longer works through apache - mod_jk after upgrade still works via straight
January 11, 2011 03:41:22 AM
Hi- I recently upgraded tomcat, apache, apr and mod_jk. Now when I access via apache --> mod_jk on port 80 ie. www.mydomain.com/myappname/ the Velocity login page displays fine but after hitting the login button /admin/j_security_check displays…

Works
December 21, 2010 11:05:23 PM
Hi, Well after 21 hours I got my cluster to work. I went back to hadoop version 0.20.2 and hbase version 0.20.6 -Pete

how does ensureIndex works?
January 26, 2011 03:58:41 PM
Hello, I'm confused about ensureIndex, sometime it works and sometime I cannot get it to work? > db.logs.totalIndexSize() 275693568 > db.logs.dataSize() 234930628 > db.logs.getIndexes() [ { "name" : "_id_", "ns" : "apollo.logs", …

EL works in JSP but not in tag files
November 9, 2010 06:15:43 AM
Hello everyone, The problem is that EL expressions work well in JSPs, but get ignored in custom tags. i found several related posts on the web, but none helped me to solve this. On adding the line <%@ tag isELIgnored="false" %> i get the…

Re: Query works on one box, but not on the other?
January 30, 2011 09:35:45 PM
More hints. The data is strange as well.. i'm getting duplicate rows: { "_id" : ObjectId("4d4627d13d42ac0a61925540"), "frequency" : 2789403, "language" : "en", "morpheme" : "of" } { "_id" : ObjectId("4d4627d160920deb776f65f6"), "language" : "en",…

Query works on one box, but not on the other?
January 30, 2011 09:36:00 PM
Ok, I've been developing using the java drivers. I have mongodb 1.7.3 on my Mac and 1.7.4 on my Ubuntu server (aws in case it matters). The statement I'm executing is (this is the shell version): db.words.update( { "language" : "en",…

About community, and how it works
January 24, 2011 08:14:40 AM
Hi guys, I'm writing this as I'm currently unhappy about how this project operates I want to recall some elements about the way we work at The Apache Software Foundation, not that you don't know about those rules, but I'd like us to stick to…

how cache works?
June 9, 2011 02:36:16 PM
Hello, I cannot still understand how the cache works. Here is a little example. I have a "Category" class like this: public class Category { private int categoryId; private String name; private Category parentCategory; public int…

cassandra-cli: where a and b (works) vs. where b and a (doesn't)
January 18, 2011 04:55:06 AM
I put a secondary index on rc (IntegerType) and user_agent (AsciiType). Don't understand this bevahiour at all, can somebody explain? [def### @tracking] get crawler where user_agent=foo and rc=200; 0 Row Returned. [defa### @tracking] get crawler…

how does ProxyPass works
June 4, 2010 09:37:38 AM
I want to know how does directive ProxyPass and ProxyPassReverse work if I have an application on an internal webserver running on port 8080 on Lan but I want it to be accessible on internet via Server A which has public IP but firewall (which I do…

SQLite works strange
April 9, 2011 05:54:39 AM
Hello! We have performance trouble with SQLite. We have created custom function MY_FUNC(a TEXT, b TEXT) and bind it with sqlite3_create_function. So, we have 2 tables: Tbl1(id1 INTEGER, id2 INTEGER, str TEXT) 2 records Tbl2(id INTEGER, Tbl1_id…

tomcat 7.0.4 on MAC my app works on Windows get...
December 21, 2010 11:05:14 AM
tomcat 7.0.4 on MAC my app works on Windows get... SEVERE: Exception starting filter struts2 java.lang.NoClassDefFoundError: Lorg/apache/velocity/app/VelocityEngine; i have removed all other applications from the webapps and have restarted the…

Unmarshalling a HashMap only works sometimes
August 17, 2010 10:33:52 AM
Hello, we use a JAX-WS proxy (JaxWsProxyFactoryBean, CXF 2.2.3) to talk from app A (client) to app B (server) using SOAP. One of the methods called by A on B returns an object containing an object that contains, among other data members, a…

It's really a new and latest Database that works in a new way
March 21, 2011 05:25:16 AM
Hi to all I am new to Redis DB. I am also new to Ruby on rails. I am doing a project based on ruby on rails using redis as backend..........so please help me to get progress. It Inspires me beacuse...... It's really a new and latest Database…

Re: Want more info about logging works
December 3, 2010 05:50:23 PM
----- "Jeroen Geilman" <jero### @adaptr.nl> wrote: > On 12/01/2010 07:38 PM, ma### @manfbraun.de wrote: > > Hello ! > > > > I am just using this to log: > > > > LogFormat \ > > "%{%F…

which release of NMS works with activemq 5.2.0?
December 1, 2010 03:34:52 PM
I'm hoping someone knows the answer to this. I'm using activemq 5.2.0, which works great. I can successfully connect with java and do what I need. When I try to connect to activemq using NMS 1.4.0.2075 from VS2008 .Net 3.5, I get errors. I tried…

Can anyone shed some light on how MDB works ?
March 13, 2011 08:57:29 PM
I plan to look into the MDB failures in tck. Before I dive into it, Can anyone shed some light on how MDB works ? Specifically, I want to know: 1, Basic MDB deploy process in geronimo. 2, What's the key classes involved at…

Connection failed ssh works
March 3, 2011 05:27:19 AM
Hi, I am using cap 2.5.19, ruby 1.8.7, rails 3.0.4 and deploying via git. I didn't have any problems with deploy until yesterday when deploy suddenly stop working. I didn't change deploy script or any other crucial information for deploying. …

Does hint works in count?
March 3, 2011 09:55:09 PM
Hi everyone, I tried following command in mongodb: > db.smr.find().hint({$natural:1}).count() 1 > db.smr.find().count() 1 And I find following information in the log: Fri Mar 4 19:54:55 [conn250] run command test.$cmd { count: "smr", query:…

Re: camel 2.4 and cxf issue - works in 2.2
October 24, 2010 06:48:23 AM
Its possible, but your stack trace looks like you use Spring 3.0.3 and not 2.5.x... Christian Am 24.10.2010 02:32 schrieb "Hossein" <mamer### @csc.com>: I thought Camel 2.x supports Spring 2.5 and 3.0 and we can still use Spring 2.5 in…

Questions and Answers are licensed under cc-wiki license.

How ReplicationDriver works

0 Answers

Be the first to answer this question

Join with account you already have