Demixing of bosonic mixtures in optical lattices from macroscopic to microscopic scales.