AFAIK Discourse uses PostgreSQL’s superawesome text search features:
https://meta.discourse.org/t/why-not-support-mysql/2568/3