can Borderline personality disorder people actually have a successful marriage?

and by successful, i mean no cheating. ive been with my husband for 5 years now, and he has driven me crazy every single year. some days he gets upset by everything, and he tells me how im a piece of sh@@t, literally, despite me supporting him through all his madness and leaving behind dreams to take care of him. he recently started acting bored by me and everything, and i ask him whats wrong. he gets angry by the questions since he says i ask them all the time, but his behavior is terrible ALL THE TIME. I honestly dont know how other ppl with bpd spouses deal with it. can you acutally have a successful marriage? or will it always be filled with this agony that he causes me more than not?