It is fairly common. I have no idea percentage wise, or whether "most" people do it, but it is certainly fairly common.
Are you the one looking to be a second shooter? Or are you the one considering getting a second shooter?
If you are the one who wants to second-shoot, then there should be plenty of opportunities to do so. Ask around with friends and also try calling up advertised wedding photographers in your area. Don't do it for free, unless the person you are second shooting for is very well known and very good, and if you also really have zero portfolio to speak of. If they are less well known, and if you aren't completely desperate, then request some sort of fair compensation that takes into account that you are likely less experienced than they are. Also, you have to take into account that their reputation is more at risk than yours, and that they are spending money on advertising their business, etc., which you aren't (yet you're still reaping the benefits). I'd say about 25-35% of revenue is fair for a typical second shooter. OR payment by the photo - the more of the second shooter's photos end up going to the client, the more they get paid.
If you're the one looking for second shooters, then the above still applies: Pay them fairly based on what they contribute, and do your best to actually teach them whatever you can, and they will say good things about you and guarantee a steady stream of other 2nd shooters for your business whenever you should need them.
In either case, second shooting is a fairly low-risk option for everybody involved, and you shouldn't freak out too much about it either way. Just give it a try and see if it works out.