How much effective is self publishing of books?

There are several sites like amazon.com, lulu.com etc. , that helps us to do self publishing of books. How much effective is self publishing compared to traditional publishing through established publishers? Will the book get enough popularity if publlished through self publishing sites?