I know that a lot of people do this but I would have very little faith in my tests if they were run against a different type of database than my production one.
Hence why they were run against MySql on CI.
But no unit test environment is ever going to emulate everything in production, nor should it.