前言
相信每位程序员对mysql应该都不陌生,MySQL是一个关系型数据库管理系统,由瑞典MySQL AB 公司开发,目前属于 Oracle 旗下产品。我们在日常开发中少不了要接触mysql。
腾讯云上的mysql实例,初始化的时候,需要自己点击“初始化按钮”,然后还要手动输入16位复杂的密码,这个操作比较繁琐,而且如果你一次建立多个实例,这个操作量就很大了,所以必须想办法提高效率,于是就有了下文,批量调用sdk api来实现。
本文主要给大家介绍了关于Python实现MySQL实例初始化的相关内容,分享出来供大家参考学习,下面话不多说了,来一起看看详细的介绍吧。
示例代码
代码准备:initstance.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
#!/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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
|
[hy@orcl ] / data0 / dbj1st$ python initstance.py Traceback (most recent call last): File "initstance.py" , line 2 , in <module> 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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
[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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
[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
1
2
3
4
|
[laobanzhang@dbj1st] ~ /dbj1st/promotion $ python initstance.py 6 exception: cannot import name DependencyWarning [laobanzhang@dbj1st] ~ /dbj1st/promotion $ |
OK,执行成功:
1
2
3
4
5
|
[hy@orcl ] /data0/dbj1st/promotion $ python initstance.py 6 7 { "code" :0, "message" : "" , "codeDesc" : "Success" , "jobId" :51783} [hy@orcl ] /data0/dbj1st/promotion $ |
总结
以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作具有一定的参考学习价值,如果有疑问大家可以留言交流,谢谢大家对服务器之家的支持。
原文链接:http://blog.csdn.net/mchdba/article/details/78453115