My suggestion is to use a firebase real-time database for creating the instant chatting app. you can easily develop chatting app using the firebase database.
If you are an experienced developer then you can go throw the MySQL database. I had implemented chatting functionality in one of my android projects using MySQL database, you can download a sample app or source here.
https://itinsidenews.com/mymall-android-app-free-source-code