While I mostly agree with David's summary above, I neither use it, nor hear other people using it, except possibly in a camp, jokey kind of way. Dropping "my" and just calling someone "dear" is a little more common, but "my dear" is a bit old-fashioned and not generally used much in my experience.