python的mysql初始化_Python 实现MySQL实例初始化

腾讯云上的mysql实例，初始化的时候，需要自己点击“初始化按钮”，然后还要手动输入16位复杂的密码，这个操作比较繁琐，而且如果你一次建立多个实例，这个操作量就很大了，所以必须想办法提高效率，于是就有了下文，批量调用sdk api来实现。

代码准备：initstance.py

#!/usr/bin/python

from src.QcloudApi.qcloudapi import QcloudApi

from time import ctime,sleep

from getpwd import get_password

def initinstance(cdbid,no):

module = 'cdb'

action = 'CdbMysqlInit'

config = {

'Region': 'ap-shanghai',

'secretId': 'AKIDTsEEl8ZK9mHcotf4OYk2A7uYxxxxxxxx',

'secretKey': 'IOI0Zw87vYDvhR6a5QZXouomxxxxxxxx',

'method': 'get'

}

pwd=get_password(16)

params = {

'cdbInstanceId': cdbid,

'charset': 'utf8mb4',

'port': 3306,

'lowerCaseTableNames': 1,

'password': pwd

}

print params

try:

service = QcloudApi(module, config)

print service.generateUrl(action, params)

print service.call(action, params)

except Exception, e:

print 'exception:', e

def main():

# 这里添加 N多实例id，可以批量进行初始化，不用再界面点击操作了。

cdbids_hermes=["cdb-1hz14ogho","cdb-1417ds7su"]

for index,value in enumerate(cdbids_hermes):

initinstance(value,str((index+1)).zfill(2))

sleep(1)

if __name__ == '__main__':

main()

初始化实例脚本initstance.py，准备执行代码：

调试报错，需要安装qcloudapi-sdk-python-master.zip

[hy@orcl ] /data0/dbj1st$ python initstance.py

Traceback (most recent call last):

File "initstance.py", line 2, in

from src.QcloudApi.qcloudapi import QcloudApi

ImportError: No module named src.QcloudApi.qcloudapi

[hy@orcl ] /data0/dbj1st$

[hy@orcl ] /data0/dbj1st/promotion$ unzip qcloudapi-sdk-python-master.zip

Archive: qcloudapi-sdk-python-master.zip

e6cb9ff252cdb125e516525a2bb62d3410723adf

creating: qcloudapi-sdk-python-master/

extracting: qcloudapi-sdk-python-master/.gitignore

inflating: qcloudapi-sdk-python-master/README.md

inflating: qcloudapi-sdk-python-master/demo.py

creating: qcloudapi-sdk-python-master/src/

creating: qcloudapi-sdk-python-master/src/QcloudApi/

extracting: qcloudapi-sdk-python-master/src/QcloudApi/__init__.py

creating: qcloudapi-sdk-python-master/src/QcloudApi/common/

extracting: qcloudapi-sdk-python-master/src/QcloudApi/common/__init__.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/common/request.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/common/sign.py

creating: qcloudapi-sdk-python-master/src/QcloudApi/modules/

extracting: qcloudapi-sdk-python-master/src/QcloudApi/modules/__init__.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/account.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/base.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/bill.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/bm.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cbs.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cdb.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cdn.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cmem.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/cvm.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/dfw.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/eip.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/image.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/lb.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/live.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/market.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/monitor.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/redis.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/scaling.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/sec.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/snapshot.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/tdsql.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/trade.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/vod.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/vpc.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/wenzhi.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/modules/yunsou.py

inflating: qcloudapi-sdk-python-master/src/QcloudApi/qcloudapi.py

extracting: qcloudapi-sdk-python-master/src/__init__.py

[hy@orcl ] /data0/dbj1st/promotion$ ll

[hy@orcl ] /data0/dbj1st/promotion$ cp -r qcloudapi-sdk-python-master/src .

[hy@orcl ] /data0/dbj1st/promotion$

需要安装cassdk

[hy@orcl ] /data0/dbj1st/promotion$ python initstance.py

6

exception: No module named requests

[hy@orcl ] /data0/dbj1st/promotion$

[hy@orcl ] /data0/dbj1st/promotion$

[hy@orcl ] /data0/dbj1st/promotion$ sudo su

[root@dbj4st] /data0/dbj1st/promotion$ pip install cassdk

Collecting cassdk

Downloading cassdk-1.0.2.tar.gz

Building wheels for collected packages: cassdk

Running setup.py bdist_wheel for cassdk ... error

Complete output from command /bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-1_XMv6/cassdk/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmpzGF2_Dpip-wheel- --python-tag cp27:

usage: -c [global_opts] cmd1 [cmd1_opts] [cmd2 [cmd2_opts] ...]

or: -c --help [cmd1 cmd2 ...]

or: -c --help-commands

or: -c cmd --help

error: invalid command 'bdist_wheel'

----------------------------------------

Failed building wheel for cassdk

Running setup.py clean for cassdk

Failed to build cassdk

Installing collected packages: cassdk

Running setup.py install for cassdk ... done

Successfully installed cassdk-1.0.2

[root@dbj4st] /data0/dbj1st/promotion$

需要安装requests

[hy@orcl ] /data0/dbj1st/promotion$ python initstance.py

6

exception: No module named requests

[hy@orcl ] /data0/dbj1st/promotion$ sudo su

[root@dbj4st] /data0/dbj1st/promotion$ sudo pip install --upgrade urllib3

Collecting urllib3

Downloading urllib3-1.22-py2.py3-none-any.whl (132kB)

100% |████████████████████████████████| 133kB 186kB/s

Installing collected packages: urllib3

Successfully installed urllib3-1.22

[root@dbj4st] /data0/dbj1st/promotion$

[hy@orcl ] /data0/dbj1st/promotion$ sudo su

[root@dbj4st] /data0/dbj1st/promotion$ sudo pip install --upgrade requests

Collecting requests

Downloading requests-2.18.4-py2.py3-none-any.whl (88kB)

100% |████████████████████████████████| 92kB 9.9kB/s

Collecting certifi>=2017.4.17 (from requests)

Downloading certifi-2017.7.27.1-py2.py3-none-any.whl (349kB)

100% |████████████████████████████████| 358kB 36kB/s

Collecting chardet<3.1.0,>=3.0.2 (from requests)

Downloading chardet-3.0.4-py2.py3-none-any.whl (133kB)

100% |████████████████████████████████| 143kB 18kB/s

Collecting idna<2.7,>=2.5 (from requests)

Downloading idna-2.6-py2.py3-none-any.whl (56kB)

100% |████████████████████████████████| 61kB 16kB/s

Requirement already up-to-date: urllib3<1.23,>=1.21.1 in /usr/lib/python2.7/site-packages (from requests)

Installing collected packages: certifi, chardet, idna, requests

Found existing installation: chardet 2.2.1

Uninstalling chardet-2.2.1:

Successfully uninstalled chardet-2.2.1

Successfully installed certifi-2017.7.27.1 chardet-3.0.4 idna-2.6 requests-2.18.4

[root@dbj4st] /data0/dbj1st/promotion$

需要安装DependencyWarning

[laobanzhang@dbj1st] ~/dbj1st/promotion$python initstance.py

6

exception: cannot import name DependencyWarning

[laobanzhang@dbj1st] ~/dbj1st/promotion$

OK，执行成功：

[hy@orcl ] /data0/dbj1st/promotion$python initstance.py

6

7

{"code":0,"message":"","codeDesc":"Success","jobId":51783}

[hy@orcl ] /data0/dbj1st/promotion$