[MaxScale & MariaDB]
Checklist & Issue Consistency select after insert : cloudsave inbox function get_user_id in file function.php leaderboard receiptvalidation function get_user_id in file function.php referral function get_user_id in file function.php function get_referral in file function.php survey function get_user_id in file function.php
Unsafe statements : https://mariadb.com/kb/en/library/unsafe-statements-for-replication/
Solusi using filter hint : -- maxscale route to master Filter hint hanya berfungsi untuk service readwritesplit Load balance readwritesplit tidak bisa di test dengan round robin Load balance readconnroute bisa di test dengan round robin Service readconnroute tidak bisa digunakan untuk write dan read secara bersamaan
Need rework all services, separate read and write services, read query using read-service, write query using write-service
No Need rework, readwritesplit bisa di load balance seperti round robin menggunakan config berikut: router_options=slave_selection_criteria=LEAST_GLOBAL_CONNECTIONS max_slave_connections=1