-
Notifications
You must be signed in to change notification settings - Fork 85
/
ali_rds_copy_database_between_instance_test.yml
90 lines (74 loc) · 2.67 KB
/
ali_rds_copy_database_between_instance_test.yml
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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
---
- name: Validate module ali_rds_database
hosts: localhost
remote_user: root
roles:
- vpc
- vswitch
tasks:
- name: Changed. Create a new RDS Instance
alibaba.alicloud.ali_rds_instance:
state: present
engine: SQLServer
engine_version: 2012_web
db_instance_class: mssql.x2.medium.w1
db_instance_storage: 30
db_instance_net_type: Intranet
security_ip_list: 10.23.12.24/24
pay_type: PostPaid
vswitch_id: '{{ vswitches.vswitches.0.id }}'
db_instance_description: ansible_test_rds
register: rds
- name: Get the existing rds
alibaba.alicloud.ali_rds_instance_info:
name_prefix: '{{ rds.instances.name }}'
register: rds
- name: Changed. Create another RDS Instance
alibaba.alicloud.ali_rds_instance:
state: present
engine: SQLServer
engine_version: 2012_web
db_instance_class: mssql.x2.medium.w1
db_instance_storage: 30
db_instance_net_type: Intranet
security_ip_list: 10.23.12.24/24
pay_type: PostPaid
vswitch_id: '{{ vswitches.vswitches.0.id }}'
db_instance_description: ansible_test_rds2
register: rds2
- name: Get the existing rds
alibaba.alicloud.ali_rds_instance_info:
name_prefix: '{{ rds2.instances.name }}'
register: rds2
- name: Create Database
alibaba.alicloud.ali_rds_database:
db_instance_id: '{{ rds.instances.0.id }}'
db_name: ansible_test
character_set_name: utf8
db_description: create for ansible test
state: present
- name: Get the existing db
alibaba.alicloud.ali_rds_database_info:
name_prefix: ansible_test
db_instance_id: '{{ rds.instances.0.id }}'
register: db
- name: Changed. Copy Database Between Instances
alibaba.alicloud.ali_rds_database:
db_instance_id: '{{ rds.instances.0.id }}'
db_name: '{{ db.databases.0.name }}'
target_db_instance_id: '{{ rds2.instances.0.id }}'
target_db_name: ansible_test2
- name: No Changed. Copy Database Between Instances
alibaba.alicloud.ali_rds_database:
db_instance_id: '{{ rds.instances.0.id }}'
db_name: '{{ db.databases.0.name }}'
target_db_instance_id: '{{ rds2.instances.0.id }}'
target_db_name: ansible_test2
- name: Changed. Deleting rds
alibaba.alicloud.ali_rds_instance:
state: absent
db_instance_description: '{{ rds.instances.0.name }}'
- name: Changed. Deleting another rds
alibaba.alicloud.ali_rds_instance:
state: absent
db_instance_description: '{{ rds.instances.0.name }}'