application.conf

// SOURCE:
// https://doc.akka.io/docs/akka-persistence-jdbc/3.5.2/
// https://github.com/akka/akka-persistence-jdbc/blob/v3.5.2/src/test/resources/mysql-shared-db-application.conf
// CHANGES:
// - Remove: include "general.conf"
// - change: host = ${docker.host} to host = "localhost"
// - Added: db.dbname = "cqrsdemo" (in original, dbname is hardcoded as mysql)


akka {
  persistence {
    journal {
      plugin = "jdbc-journal"
      // Enable the line below to automatically start the journal when the actorsystem is started
      // auto-start-journals = ["jdbc-journal"]
    }
    snapshot-store {
      plugin = "jdbc-snapshot-store"
      // Enable the line below to automatically start the snapshot-store when the actorsystem is started
      // auto-start-snapshot-stores = ["jdbc-snapshot-store"]
    }
  }
}

akka-persistence-jdbc {
  shared-databases {
    slick {
      profile = "slick.jdbc.MySQLProfile$"
      db {
        dbname = "cqrsdemo"
        host = "localhost" // ${docker.host}
        host = ${?MYSQL_HOST}
        port = "3306"
        port = ${?MYSQL_PORT}
        url = "jdbc:mysql://"${akka-persistence-jdbc.shared-databases.slick.db.host}":"${akka-persistence-jdbc.shared-databases.slick.db.port}"/"${akka-persistence-jdbc.shared-databases.slick.db.dbname}"?cachePrepStmts=true&cacheCallableStmts=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&connectionAttributes=none&verifyServerCertificate=false&useSSL=false&allowPublicKeyRetrieval=true&useUnicode=true&useLegacyDatetimeCode=false&serverTimezone=UTC&rewriteBatchedStatements=true"
        user = "root"
        user = ${?MYSQL_USER}
        password = "root"
        password = ${?MYSQL_PASSWORD}
        driver = "com.mysql.cj.jdbc.Driver"
        numThreads = 5
        maxConnections = 5
        minConnections = 1
      }
    }
  }
}

jdbc-journal {
  use-shared-db = "slick"
}

// the akka-persistence-snapshot-store in use
jdbc-snapshot-store {
  use-shared-db = "slick"
}

// the akka-persistence-query provider in use
jdbc-read-journal {
  use-shared-db = "slick"
}