I have developed with other relational database engines such as postgresql which is also a SQL relational engine such as MYSQL, replicas streaming replication master slave between partitions by date field for much faster queries of millions of rows.