故障转移选项在mysql.connector中引发错误

Question

这是我的代码：

import mysql.connector
config = {
'user': 'bb123',
'password': 'tt',
'host': 'adb',
'failover': 'bdb',
}
self.conn = mysql.connector.connect(**self.config)

然而，我得到了这个错误：

return _get_failover_connection(**kwargs)
File "C:Python27libsite-packagesmysqlconnector__init__.py", line 109, in _get_failover_connection
diff = set(server.keys()) - support_cnx_args
AttributeError: 'str' object has no attribute 'keys'

如何启用故障转移数据库？

Answer 1

failover值应该是包含故障转移服务器连接详细信息的字典列表或元组。例如：

failoverConfig = {
'user': 'failover_user',
'password': 'failover_password',
'host': 'failover_host',
}
config = {
'user': 'testeng',
'password': 'testeng',
'host': 'adb',
'failover': [failover_config],
}