I am running Btrfs on about a dozen machines (solid state and spinning disks). All of them are servers and run "business-critical" stuff. No issues during the last 2 years, everything flawless.
The ability to scrub your data and have strong data integrity guarantees is just one of the benefits of Btrfs. I'm also using transparent compression (GZIP and ZSTD) and even RAID1 (disk replacement procedure worked flawless last time I had to use it).
For workloads such as MariaDB (heavily updated-in-place files) you may want to go ahead and disable CoW features, though. This leaves you without data checksumming (InnoDB uses it's own checksumming - not losing much there) but you still get a lot of the other great Btrfs features.