Is there a configuration option for Grails/GORM to allow for different hosts for read and write operations? I'd like to be able to have all of my SELECT queries hit a read replica host while INSERTS, UPDATES AND DELETES would hit the master database. I have been unable to find any documentation pointing to a simple solution to this issue.
Is there a configuration option for Grails/GORM to allow for different hosts for read and write operations?
No. You can configure GORM to communicate with as many different databases as you like and you can write code that only reads from certain databases and only writes to others but there is no way to tell GORM that all writes go to one place or set of places and reads go to another place or set of places.