sql connection time-out crashed application

[merthanmerter]

I migrated to drizzle-orm from type-orm recently but now my app crashes when mysql database connection is idle for a while. I didn't encounter this with any other orm before. According to documentation, I tought drizzle manages opening and closing connections but it seems to be connecting only once. I came up with below approach but I'm not sure if this is a good practice. any ideas would be highly appreciated.

//* In-memory store for database connections
const store = new Map<string, mysql2.Connection>();

//* Utility function for database connection handling
async function createConnection(dbName: string) {
  const exconn = store?.get(dbName);
  if (exconn && (await ping(exconn))) {
    return exconn;
  }

  const conn = await mysql2.createConnection({ ...masterDbOptions, database: dbName });
  store.set(dbName, conn);
  return conn;
}

//* Function to establish shared database connection
export const sharedDb = async () => {
  if (!zenv?.DATABASE_NAME) return null;
  const connection = await createConnection(zenv.DATABASE_NAME);
  return drizzle(connection, { schema, mode: 'default' });
};

//* Function to establish tenant database connection with authorization
export const tenantDb = async ({ request, permissions }: { request: Request; permissions?: UserPermissions[] }) => {
  const { user, tenant } = await authenticate(request, { permissions });
  const connection = await createConnection(`tenant_${tenant}`);
  const conn = drizzle(connection, { schema: tenancySchema, mode: 'default' }) as MySql2Database<
    typeof tenancySchema
  > & { ctx: { user: string; tenant: string } };
  conn.ctx = { user: user.username, tenant };
  return conn;
};

//* ping function to check if server is alive
const ping = async (conn: mysql2.Connection): Promise<boolean> =>
  conn
    ?.ping()
    .then(() => true)
    .catch(() => false);