当第一次连接失败时，如何在Node.js中重试数据库连接？

const mysql = require('mysql');

function connectWithRetry(options, retries = 5, delay = 1000) {
  const connection = mysql.createConnection(options);

  connection.connect(error => {
    if (error) {
      if (retries > 0) {
        console.log(`Connection failed, retrying in ${delay / 1000} seconds...`);
        setTimeout(() => {
          connectWithRetry(options, retries - 1, delay * 2);
        }, delay);
      } else {
        console.error('All connection attempts failed:', error);
        throw error;
      }
    } else {
      console.log('Connected to the database!');
      // 连接成功后的操作
    }
  });

  connection.on('error', error => {
    if (error.code === 'PROTOCOL_CONNECTION_LOST') {
      console.error('Database connection was closed. Reconnecting...');
      connectWithRetry(options, retries, delay);
    } else {
      console.error('Database error:', error);
      throw error;
    }
  });
}

const dbOptions = {
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
};

connectWithRetry(dbOptions);