Microscopic and macroscopic instabilities of periodic composite solids