Will mariadb use mutliple cores at all?
The short answer is yes. It will use a thread per connection by default which you can delegate queries to concurrently, which will utilize multiple cores on the operating system level.

Slave throughput can be dramatically improved by adding cores using parallel replication which is not enabled by default. https://mariadb.com/kb/en/library/parallel-replication/