To overcome the embedded metastore limitation, local metastore came to picture. This mode allows multiple sessions at the same time. Here you can use MySQL, as this runs on separate JVM than metastore/Hive service. MySQL is best as a standalone metastore.
In later cards, you will see how to configure with MySQL.