Why MySQL, though? Postgres with pgvector seems to be far better suited (and far more popular) for vector-DB applications.