A similar issue surface if you want to use utf8mb4 as a character set (4-Byte UTF-8 Unicode Encoding). The feedback on Cloud SQL is
Filter utf8mb4 strings out of your data.
What is the lesson here?
Before choosing one of the main providers to host your database as a managed service, double check that they support all the not default configuration you might have in place or you would like to use. This is extremely important in case of migration across different cloud providers: you do not want to figure out you have a blocker when you are half way through the process.
Today I was back for “Devs Lunch Box” at Codemotion, talking about one of my favorite topics in the database world. You can find the recording of my short presentation “What is a serverless database?”here. The slides are available too.
A few devops conferences still go ahead, fully remotely, and it was a pleasure yesterday to be part of DevOps Pro Europe. Here are the slides and the video of my talk “Serverless Databases: The Good, the Bad, and the Ugly”.
How to run MySQL on AWS – the recording of my short talk for Codemotion “Devs Lunch Box” is now available on the Codemotion platform. In about 10 minutes, I covered the main ways to deploy a MySQL (or a PostgreSQL) database on the largest cloud provider.
Two years after my first conference in Poland, next May I will be in Poznań to talk about relational databases on the cloud at devopsdays. “Serverless databases: the good, the bad, and the ugly” will be the topic of my talk.