MariaDB MaxScale 정리

Maxscale Readwritesplit

1. 라우팅 기준

1) master

• write statements
• transaction 내 모든 statements
• stored procedure calls
• user-defined function calls
• DDL statements(DROP, CREATE, ALTER TABLE)
• EXECUTE (prepared) statements that modify the database
• all statements using temporary tables

2) slave

• read-only database queries
• read-only queries to system, or user-defined variables
• SHOW statements
• system function calls

출처) MariaDB Maxscale ReadWritesSplit docs