Re: the upside
Apparently his term ends on 2016-10-31 - so yes, there will be a campaign (I've first typed that as campaingn, I wonder why, but it didin't look right) in the late summer / fall. If his party will put him forward as a candidate again. But as this is already his second term, he'll be entitled to a full pension from the job as mayor.
BTW, it's about an hour's drive from Quickborn to Hamburg and its Reeperbahn. Where you can see the Beatles-Platz and visit Beatlemania, the Beatles museum. Which is the only reason why so many people go there every night, honestly.