Facebook Messenger moved from NoSQL to SQL for better performance.
When FB Messenger launched, it used HBase. However, over time, the CPU started to exhaust itself due to Garbage Collection (of course, Java).
So, they moved to MySQL with a custom storage engine called MyRocks, which is an LSM Tree-based engine built on top of RocksDB.