MySQL: Procedure for mysql certification
MySQL certification, exam, course &amp; cost details can all be found on the Oracle Education site here (Indian site linked to):

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=458&amp;get_params=p_track_id:MYSQLDBA56OCP

The certification process is simple enough to become a MySQL Certified Associate or Professional.  You just need to pass the relevant exams (e.g. for Oracle Certified Professional, MySQL 5.6 Database Administrator, you have to pass 1Z0-883 / MySQL 5.6 Database Administrator).

That's it.

For the Expert certification status things are a bit more complex, but check out the Oracle Education site linked above.

The cost is high if you do the courses and the exams.  If you're confident in your abilities and have lots of experience, you can do the exams without having done the courses, but in my experience, doing the course is a good grounding and they will cover everything that the exam requires.

How beneficial?  Well that depends on the job market, employer's requirements and your other skills.  Obviously a certification separates you from people who don't have one, but that's all you can realistically say.  There will be non-certified people with more experience than you.