AWS Amplify and database in nitro

[maciej-jezierski]

Hi all, on amazon amplify I had encounter an issue when I run database connection in nitro. As a result I got too many connections to datbase.

I've setup database connection within nitro plugin, but I think amplify is starting the server for each request it leads to an error. What is correct setup for this one?

`export default defineNitroPlugin(async (nitroApp) => {
const config = useRuntimeConfig()

const pool = mysql2.createPool({
    uri: `mysql://${config.mysqlUser}:${config.mysqlPassword}@${config.mysqlHost}:${config.mysqlPort}/${config.mysqlDb}`,
    connectionLimit: 10, // Limit total connections
    queueLimit: 0, // Unlimited queue size
    waitForConnections: true, // Wait for available connection
    enableKeepAlive: true, // Enable keep-alive
    keepAliveInitialDelay: 0, // Start keep-alive immediately
    maxIdle: 10, // Maximum number of idle connections to keep
    idleTimeout: 60000, // Close idle connections after 60 seconds
})

nitroApp.hooks.hookOnce("close", async () => {
    await pool.end()
});

nitroApp.$mysql = pool

})`