I got a question about a new system to be located in Azure. The system will have a fair amount of traffic, perhaps somewhere around 100 requests per second. Each request will be handled and logged. Perhaps the log items will be updated with more data during the request (which usually will last a few seconds). My guess is that we will have tables with a few 100 miljon rows.
I've been working for a long time with development using Visual Studio, I also was certified for an older version of SQL Server. So my first instinct is to go with Azure SQL.
MariaDB is also an option mentioned, due to the significant difference in cost. I have worked a bit with MariaDB, but from my (limited) experience, it is slower and less flexible. But I have hard to pull out facts or differences to motivate the higher cost.
Perhaps you guys can help me with some input on this?
Or perhaps my instinct is wrong, and MariaDB is as suitable as Azure SQL for this system?