what does the primary hint do ?

[davecramer]

see $subject

[jesperpedersen]

It will select that server as the primary instead of going in order of the definitions.

[davecramer]

Hmm.. ok, so you give it a list of servers and how do you tell it you prefer the primary ?

[jesperpedersen]

It will prefer a primary - only if none is found will it choose a replica