单例实践中如何mysql

import mysql.connector
from mysql.connector import pooling

class MySQLSingleton:
    _instance = None
    _connection_pool = None

    def __new__(cls, *args, **kwargs):
        if not cls._instance:
            cls._instance = super(MySQLSingleton, cls).__new__(cls)
            cls._connection_pool = pooling.MySQLConnectionPool(pool_name="mypool",
                                                              pool_size=5,
                                                              host='localhost',
                                                              database='mydb',
                                                              user='myuser',
                                                              password='mypassword')
        return cls._instance

    def get_connection(self):
        return self._connection_pool.get_connection()

# 使用示例
if __name__ == "__main__":
    db1 = MySQLSingleton()
    conn1 = db1.get_connection()
    cursor1 = conn1.cursor()
    cursor1.execute("SELECT * FROM mytable")
    result1 = cursor1.fetchall()

    db2 = MySQLSingleton()
    conn2 = db2.get_connection()
    cursor2 = conn2.cursor()
    cursor2.execute("SELECT * FROM mytable")
    result2 = cursor2.fetchall()

    print(result1)
    print(result2)