Hello, I'm trying to use my shiny app with MySQL via Pooled connection:
pool <<- dbPool(drv = RMySQL::MySQL(),
dbname = "sigma401k",
host = "sigma401k.c4cj5sy73xe4.us-east-1.rds.amazonaws.com",
port = 3306,
username = "***",
password = "***")
I have no issues running this locally, maintaining connections, fetching/sending data in between R and SQL. However, when deployed, the app stays blank and times out, claiming no database connection is possible. My shiny.io logs say this:
I was previously using the RMySQL/DBI version of dbConnect / dbDisconnect for each query (I have about 10 queries in the app at various reactive stages), which is obviously not the way to go being slow and losing connections, but it did work when deployed. Is this an issue with package versions? See below for all the versions I'm running. I'd really like to use Pool but it's giving me fits. Thanks in advance!
devtools::install_github("hadley/dp...@v0.5.0")