Pretty trival to setup read replicas using log shipping in MSSQL and postgresql to offload analytical loads to secondary servers.
I work on a monolith that does this, but its usually not even necessary a single db server on modern hardware with proper resource governing can handle quite a bit.
I work on a monolith that does this, but its usually not even necessary a single db server on modern hardware with proper resource governing can handle quite a bit.