Hi All,
I am trying to setup metabase for our organisation which uses GCP for cloud infra. I was trying to point MB to the read-replica during installation but the installation fails with the following message:
01-15 10:59:20 ERROR metabase.core :: Metabase Initialization FAILED
liquibase.exception.DatabaseException: (conn=175320) The MySQL server is running with the --read-only option so it cannot execute this statement [Failed SQL: CREATE TABLE <DB_NAME>.DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, `DESCRIPTION` VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL)]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
Has anyone faced a similar issue? Does Metabase require write access to the DB during installation? I wanted to set it up on the replica DB to avoid any adverse impact on the production system.