Have database replicas that only listen to INSERT statements (easy to implement in My/Maria SQL with BEFORE triggers), and design the software that works with the DB as append-only.