James McClean was the hero as the Republic of Ireland secured a tense 1-0 victory over Wales in a shoot-out for a World Cup play-off spot at the Cardiff City Stadium.