To make your queries go to the slave database, you need to set connection to read-only. In Play Framework 2.0 with Scala, this can’t be simpler:

def withReadOnlyConnection[A](block: Connection => A)(implicit app: Application): A = {
    DB.withConnection {
      connection =>
        try {
          connection.setAutoCommit(false)
          connection.setReadOnly(true)
          block(connection)
        } finally {
          connection.setReadOnly(false)
        }
    }
}

Now you can just wrap your database code as:

withReadOnlyConnection[Option[User]] {
   implicit connection: Connection =>

      SQL(....)
      etc, etc.
}

For additional info on Play and Anorm see: Anorm, simple SQL data access

If you have a cluster of read/write MySQL servers. Putting loadbalance: in the JDBC URL will ensure both read and write operations are distributed across servers.

What we needed is all write operations to go to master server and read-only operations to be equally distributed among multiple read-only slaves.

For that you need to:

1. Use special JDBC driver: com.mysql.jdbc.ReplicationDriver
2. Set replication: in the URL:
   
   
   1. jdbc:mysql:replication://master,slave1,slave2…/database?loadBalanceBlacklistTimeout=5000&loadBalanceConnectionGroup=ugc&loadBalanceEnableJMX=true&autoReconnect=true&autoReconnectForPools=true

After setting our connection pool like this, all load still ended up going to our single read/write master server.

The reason is that, for the ReplicationDriver to know that queries can go to read-only slaves, two conditions need to be met:

1. Auto commit needs to be turned off. (*)
2. Connection needs to be set to read-only.

^(*)There is a workaround to allow auto commit: Connector/J load-balancing for auto-commit-enabled deployments

Turns out, even if transaction is set to read-only, neither Spring nor JPA providers like Hibernate or EclipseLink will set JDBC connection to readOnly.

To ensure JDBC Connection is set to read-only, I created an annotation and a simple AOP interceptor.

Here is an example code:

One important thing is to set priority of this interceptor to be lower than the Spring’s transaction interceptor. That way we want to make sure transaction is created before we start modifying the connection. In other words, you would set order for @Transactional to be less than order for your new interceptor:

Now, if you want queries to execute on your pool of slave databases, you can just set an annotation on the service method:

References:

• Driver/Datasource Class Names, URL Syntax and Configuration Properties for Connector/J
• Todd Farmer’s blog about Connector/J
• Load balancing across MySQL servers using JDBC by Todd Huss
• Aspect Oriented Programming with Spring

javac Test.java

# Java interpreter
java Test
IndexOf(1111111111111xx1x) = -1 in 1111111111111xx1111111111111xx1

# BUG !! When HotSpot compiler is on
java -Xcompile Test
IndexOf(1111111111111xx1x) = 15 in 1111111111111xx1111111111111xx1

Seen on both Sun JDK 1.6.0_20 and OpenJDK 1.6.0_18

Update: This bug is fixed in Sun JDK 1.6.0_22

Encyclopedia of Life is an ambitious project to create “.. electronic page for each species of organism on Earth..” and Freebase is a open structured data repository recently purchased by Google.

Go to app: http://eolfetch.freebaseapps.com/ (you need to have Freebase account)

The problem was with ActiveMQ flow control and transacted routes in Camel.

When you have slow consumers, to prevent queues from growing infinitely, ActiveMQ has a limit of how many messages you can put in a queue. When limit is reached, producer is, by default, forced to wait until the resources free. You can set these limits on system level or per queue level. Problem arises when you have transacted Camel route and system limit is reached.

Route that moves messages from queue A to queue B is inside a JMS transaction – you can’t remove message from queue A until the message is successfully placed on queue B.

If system limit is reached, no new messages can be sent to any queue. So, producers are forced to wait, transaction doesn’t complete, messages can’t be taken off queue A and no resource gets freed. The  whole processing freezes.

There are numerous ways you can work around this problem. You can turn off flow control and potentially let queues grow indefinitely.

In our case, solution was to set per-queue limits so that system limits can never be reached. Sum of limits for all queues needs to be less than the system limit. That way, as consumer takes messages from queue B, new messages can come in, transactions can complete and messages can be taken off queue A. Messages are consumed from queues A and B at the same pace and the whole system works fine.

In our case, I’ve set memoryLimit to 10m for our 13 queues and system memoryUsage to 180m.

For details see :

• ActiveMQ Producer Flow Control
• ActiveMQ Slow Consumer Handling

If you mix fields that filter out stop words (plain text) and fields that do not filter out stop words (like author names), your simple queries might end up with no results.

By default, DisMax will display only results that contain all the words from your query string. If your query has stop words like “ants of madagascar”, stop word “of” might not be found in any of the fields – it’s not in author names and it’s filtered out in article body – and you will get zero results.

Possible workarounds:

• Relax Minimum Match (mm) requirement.
  Downside: Lowering mm will increase number of results. mm of 50% on “ants madagascar” will return all documents that have “ants” and all docs that have “madagascar” in them.
• Do not filter out stop words.
  Downside: Your index can get large and you might get large number of less relevant results.
• Use other indexing schemes like N-Grams.

This article explains the details.

Also see this and this discussion.

I tested following transformers:

• Xalan 2.7.1:
  • org.apache.xalan.processor.TransformerFactoryImpl
  • org.apache.xalan.xsltc.trax.TransformerFactoryImpl
  • org.apache.xalan.xsltc.trax.SmartTransformerFactoryImpl
• Sun-Xalan (an internal transformer factory present in Sun JDK 5 and 6):
  • com.sun.org.apache.xalan.internal.xsltc.trax.TransformerFactoryImpl
• Saxon 8.7:
  • net.sf.saxon.TransformerFactoryImpl

Here are the results for Mathematical Script Capital D character: 𝒟

Or, summarized in a table:

The results were the same regardless of the parser implementation. Xerces or Saxon.

Xalan’s handling of UTF-8 multi-byte characters seems to be seriously flawed. �� are not valid UTF-8 characters and both Xerces and Saxon parsers will throw SAXParseException when trying to parse documents that have them.

1.  
2.   public static interface Foo {
3.     public T getX();
4.   }
5.  
6.   public static class Bar implements Foo {
7.     public String getX() {
8.       return "Hello World";
9.     }
10.   }
11.  
12.   public static void main(String[] args) {
13.     Method[] methods = Bar.class.getDeclaredMethods();
14.  
15.     for (Method method : methods) {
16.       System.out.println(method.getReturnType().toString()+" "+method.getName());
17.     }
18.   }
19. }

Will return :

A) It’s illegal in Java to have two methods with the same signature returning different types.

B) The order in which these methods are returned would be completely random. For example, this can cause BeanUtils.copyProperties(..) to intermittently fail to copy some bean properties. BeanUtils would take the first get method returned, find that the return type is not matching corresponding set method and skip it.

The bug is present in both Java 5 and 6. There are several bugs filed around this problem. For example: 6422403 and 6528714. The bad news is that this is not going to be fixed until Java 7.

Update:
This is not a bug but a feature. One of the methods returned by introspection is synthetic. Unfortuntely, code written for Java prior to 1.5 like Commons BeanUtils do not recognize this and will break in described situation.

For example, go to this article. To view triples from the page use Firefox Operator plugin or GetN3. You should see following Dublin Core triples.

Currently supported DC terms are identifier, title, description, type, language, creator, subject, publisher

Read the article>