I have been using MySQL for over 10 years, I am very satisfied with capacity, performance and everything.

Our biggest client has 100 users and everything works, the database is bigger than 100Gb, having tables with more than 200 million rows.

As for backup, there are ways to do it smoothly and at runtime, just search.

I use Mertech driver, but DAB has improved the ODBC driver which is now very functional.

It still has the option of using Linux as a server which with a simpler equipment gets a good result.