Sex video with SO

So my boyfriend wants to video us having sex. Has anyone done this before? Just wondering if it ruins the mood knowing ur on camera the whole time. I'm not quite sure how I feel about it. He promised he wouldn't show anyone and it'd stay between us.