Designing for MaxScale's Consistent Critical Read Filter

MaxScale's Consistent Critical Read Filter (ccrfilter) detects when a statement modifies the database, and it attaches routing hints to any subsequent statements, so they get routed to the primary server.

Additional information is available in the MariaDB Knowledge Base.