to rain cats and dogs

Does the phrase "to rain cats and dogs" exist? And does anybody use it? I have found it in one book in English and the explanation was "to rain heavily".

It is used on occasions but not in everyday situations. .. its raining cats and dogs can be said during heavy rain as you stated