API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 12th, 2017
582
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.05 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "command": "create_cluster",
  3. "job_data": {
  4. "api_id": "1",
  5. "cluster_name": "",
  6. "cluster_type": "galera",
  7. "data_center": 0,
  8. "disable_firewall": true,
  9. "disable_selinux": true,
  10. "enable_mysql_uninstall": true,
  11. "generate_token": true,
  12. "mysql_cnf_template": "my.cnf.galera",
  13. "mysql_datadir": "/var/lib/mysql",
  14. "mysql_password": "mysql",
  15. "mysql_port": "3306",
  16. "mysql_version": "5.6",
  17. "nodes": [
  18. {
  19. "hostname": "10.133.32.67",
  20. "hostname_data": "10.133.32.67",
  21. "hostname_internal": "",
  22. "port": "3306"
  23. },
  24. {
  25. "hostname": "10.133.32.154",
  26. "hostname_data": "10.133.32.154",
  27. "hostname_internal": "",
  28. "port": "3306"
  29. },
  30. {
  31. "hostname": "10.133.34.74",
  32. "hostname_data": "10.133.34.74",
  33. "hostname_internal": "",
  34. "port": "3306"
  35. }
  36. ],
  37. "software_package": "",
  38. "ssh_keyfile": "/root/.ssh/id_rsa",
  39. "ssh_port": "22",
  40. "ssh_user": "root",
  41. "sudo_password": "",
  42. "type": "mysql",
  43. "user_id": 1,
  44. "vendor": "percona"
  45. }
  46. }
  47. Messages
  48. Copy to clipboard
  49.  
  50. [14:15:08]: 10.133.32.154: Installing percona-xtrabackup.
  51. [14:15:08]: 10.133.32.154: Installing percona-toolkit.
  52. [14:15:08]: 10.133.32.154: Installing percona-xtradb-cluster-galera-3.x.
  53. [14:15:08]: 10.133.32.154: Installing percona-xtradb-cluster-5.6.
  54. [14:15:08]: 10.133.32.154: Installing percona (galera) on debian.
  55. [14:15:08]: 10.133.32.154:3306: Proceeding.
  56. [14:15:08]: 10.133.32.154:3306: Waiting for dpkg lock.
  57. [14:15:08]: 10.133.32.154:3306: Installing the MySQL packages.
  58. [14:15:07]: 10.133.32.154:3306: Prepare MySQL environment (user/group).
  59. [14:15:07]: 10.133.32.154:3306: Cleaning old MySql packages: successfully removed packages.
  60. [14:14:41]: 10.133.32.154:3306: Removing old MySQL packages from the host.
  61. [14:14:23]: 10.133.32.154: Using external repositories.
  62. [14:14:23]: 10.133.32.154:3306: Total disk space: 30110 MB.
  63. [14:14:23]: 10.133.32.154:3306: Detected free disk space: 27193 MB.
  64. [14:14:23]: 10.133.32.154:3306: Checking free-disk space of '/var/lib/mysql'.
  65. [14:14:23]: 10.133.32.154:3306: Detected memory: 992 MB.
  66. [14:14:23]: 10.133.32.154:3306: Detecting total memory.
  67. [14:14:23]: 10.133.32.154:3306: mysql_server_id is not specified in the job, using '1'.
  68. [14:14:23]: 10.133.32.154:3306: Using template 'my.cnf.galera'.
  69. [14:14:23]: 10.133.32.154:3306: vendor='ubuntu' release='trusty' type='debian'.
  70. [14:14:23]: Cluster type is 'galera'.
  71. [14:14:23]: Using skip_name_resolve as all servers are defined by IP.
  72. [14:14:23]: 10.133.32.154: Verifying helper packages (checking 'socat').
  73. [14:14:23]: 10.133.32.154: Finished with helper packages.
  74. [14:14:16]: 10.133.32.154: Installing augeas-tools.
  75. [14:14:14]: 10.133.32.154: Installing bzip2.
  76. [14:14:12]: 10.133.32.154: Installing libmecab2.
  77. [14:14:11]: 10.133.32.154: Installing libnuma1.
  78. [14:14:08]: 10.133.32.154: Installing pigz.
  79. [14:14:06]: 10.133.32.154: Installing curl.
  80. [14:14:05]: 10.133.32.154: Installing wget.
  81. [14:14:02]: 10.133.32.154: Installing libdbd-mysql-perl.
  82. [14:13:59]: 10.133.32.154: Installing libssl1.0.0.
  83. [14:13:56]: 10.133.32.154: Installing lsb-release.
  84. [14:13:54]: 10.133.32.154: Installing socat.
  85. [14:13:53]: 10.133.32.154: Installing netcat-openbsd.
  86. [14:13:50]: 10.133.32.154: Installing netcat.
  87. [14:13:48]: 10.133.32.154: Installing libaio1.
  88. [14:13:47]: 10.133.32.154: Installing rsync.
  89. [14:13:45]: 10.133.32.154: Installing psmisc.
  90. [14:13:31]: 10.133.32.154: Proceeding.
  91. [14:13:31]: 10.133.32.154: Waiting for dpkg lock.
  92. [14:13:31]: 10.133.32.154: Installing helper packages.
  93. [14:13:31]: 10.133.32.154: Setting vm.swappiness = 1.
  94. [14:13:31]: 10.133.32.154: Tuning OS parameters.
  95. [14:13:30]: 10.133.32.154: Disabling firewall.
  96. [14:13:30]: 10.133.32.154: Checking SELinux status (enabled = false).
  97. [14:13:30]: 10.133.32.154: Check and disable AppArmor.
  98. [14:13:30]: Calling job: setupServer(10.133.32.154:3306).
  99. [14:13:30]: Generated & set RPC authentication token.
  100. [14:13:29]: Wait until cluster-1 starts up.
  101. [14:13:29]: Registering the cluster on the web UI.
  102. [14:13:29]: Sending SIGHUP to the controller process.
  103. [14:13:29]: Configuration written to '/etc/cmon.d/cmon_1.cnf'.
  104. [14:13:29]: Generating configuration for cluster cluster_1.
  105. [14:13:29]: Generating and writing the new configuration.
  106. [14:13:29]: 10.133.32.67:3306: Detected OS = 'debian'
  107. [14:13:29]: 10.133.32.67: Detecting the OS.
  108. [14:13:29]: 10.133.32.67:3306: The datadir is /var/lib/mysql/.
  109. [14:13:29]: Connected succesfully: 'cmon@178.62.207.95' -> '10.133.32.67:3306:0'.
  110. [14:13:24]: Granting controller 'cmon'@'10.133.27.126' on '10.133.32.67' (host was not allowed to connect).
  111. [14:13:24]: Determining data directories.
  112. [14:13:22]: 10.133.32.67: granting 'backupuser'.
  113. [14:13:21]: 10.133.32.67: granting cmon.
  114. [14:13:21]: 10.133.32.67:3306: Node is synced.
  115. [14:13:21]: Granting controller (178.62.207.95).
  116. [14:13:20]: Detected that skip_name_resolve is used on the target server(s).
  117. [14:13:20]: Check SELinux statuses.
  118. [14:13:20]: 10.133.32.67: Access with ssh/sudo granted.
  119. [14:13:19]: 10.133.32.67: Checking ssh/sudo.
  120. [14:13:19]: Checking that nodes are not in another cluster.
  121. [14:13:19]: Found in total 1 nodes.
  122. [14:13:19]: Found node: '10.133.32.67'
  123. [14:13:19]: 10.133.32.67: Got empty wsrep_node_address status variable.
  124. [14:13:19]: 10.133.32.67: Checking wsrep_node_address.
  125. [14:13:19]: 10.133.32.67: Creating and starting a cluster using first node.
  126. [14:13:18]: 10.133.32.67:3306: Verifying the MySQL user/password.
  127. [14:13:18]: Adding existing MySQL cluster.
  128. [14:13:18]: Verifying controller host and cmon password.
  129. [14:13:18]: Adding cluster with type 'galera', vendor 'percona'.
  130. [14:13:18]: 10.133.32.67:3306: Executing SET GLOBAL rpl_semi_sync_slave_enabled=1
  131. [14:13:18]: 10.133.32.67:3306: Executing INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';
  132. [14:13:17]: 10.133.32.67:3306: Executing SET GLOBAL rpl_semi_sync_master_timeout =1000
  133. [14:13:17]: 10.133.32.67:3306: Executing SET GLOBAL rpl_semi_sync_master_enabled=1
  134. [14:13:16]: 10.133.32.67:3306: Executing INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
  135. [14:13:15]: 10.133.32.67:3306: Secured installation.
  136. [14:13:15]: 10.133.32.67:3306: Executing FLUSH PRIVILEGES
  137. [14:13:15]: 10.133.32.67:3306: Executing DROP DATABASE IF EXISTS test
  138. [14:13:15]: 10.133.32.67:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Password=''
  139. [14:13:14]: 10.133.32.67:3306: Executing DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1')
  140. [14:13:13]: 10.133.32.67:3306: Executing DELETE FROM mysql.user WHERE User=''
  141. [14:13:13]: 10.133.32.67:3306: Securing installation.
  142. [14:13:13]: 10.133.32.67:3306: MySQL is installed and started.
  143. [14:13:12]: 10.133.32.67:3306: Grant addresses: 178.62.207.95
  144. [14:13:12]: 10.133.32.67:3306: GRANT cmon.
  145. [14:13:06]: 10.133.32.67:3306: Setting the MySQL root password.
  146. [14:13:06]: 10.133.32.67: Started MySQL daemon.
  147. [14:12:55]: 10.133.32.67: This may take a while to initialize.
  148. [14:12:55]: 10.133.32.67: (service='mysql', vendor='percona', OS=['ubuntu', '14.04']).
  149. [14:12:55]: 10.133.32.67: Starting MySQL daemon.
  150. [14:12:54]: 10.133.32.67:3306: Searching and removing '/usr/my.cnf'.
  151. [14:12:49]: 10.133.32.67: Updating the /etc/mysql/debian.cnf file.
  152. [14:12:49]: 10.133.32.67:3306: Installed MySQL system tables.
  153. [14:12:40]: 10.133.32.67:3306: Installing MySQL system tables.
  154. [14:12:38]: 10.133.32.67:3306: Uploading the generated my.cnf.
  155. [14:12:38]: 10.133.32.67:3306: Preparation of the MySQL configuration file.
  156. [14:12:38]: 10.133.32.67:3306: percona-xtrabackup 2.3 is installed.
  157. [14:12:38]: 10.133.32.67:3306: Verifying the xtrabackup installation.
  158. [14:12:33]: 10.133.32.67:3306: Verifying the MySQL installation.
  159. [14:11:55]: 10.133.32.67: Installing percona-xtrabackup.
  160. [14:11:55]: 10.133.32.67: Installing percona-toolkit.
  161. [14:11:55]: 10.133.32.67: Installing percona-xtradb-cluster-galera-3.x.
  162. [14:11:55]: 10.133.32.67: Installing percona-xtradb-cluster-5.6.
  163. [14:11:55]: 10.133.32.67: Installing percona (galera) on debian.
  164. [14:11:55]: 10.133.32.67:3306: Proceeding.
  165. [14:11:55]: 10.133.32.67:3306: Waiting for dpkg lock.
  166. [14:11:55]: 10.133.32.67:3306: Installing the MySQL packages.
  167. [14:11:53]: 10.133.32.67:3306: Prepare MySQL environment (user/group).
  168. [14:11:53]: 10.133.32.67:3306: Cleaning old MySql packages: successfully removed packages.
  169. [14:11:29]: 10.133.32.67:3306: Removing old MySQL packages from the host.
  170. [14:11:07]: 10.133.32.67: Using external repositories.
  171. [14:11:07]: 10.133.32.67:3306: Total disk space: 30110 MB.
  172. [14:11:07]: 10.133.32.67:3306: Detected free disk space: 27193 MB.
  173. [14:11:07]: 10.133.32.67:3306: Checking free-disk space of '/var/lib/mysql'.
  174. [14:11:07]: 10.133.32.67:3306: Detected memory: 992 MB.
  175. [14:11:07]: 10.133.32.67:3306: Detecting total memory.
  176. [14:11:06]: 10.133.32.67:3306: mysql_server_id is not specified in the job, using '1'.
  177. [14:11:06]: 10.133.32.67:3306: Using template 'my.cnf.galera'.
  178. [14:11:06]: 10.133.32.67:3306: vendor='ubuntu' release='trusty' type='debian'.
  179. [14:11:06]: Cluster type is 'galera'.
  180. [14:11:06]: Using skip_name_resolve as all servers are defined by IP.
  181. [14:11:06]: 10.133.32.67: Verifying helper packages (checking 'socat').
  182. [14:11:06]: 10.133.32.67: Finished with helper packages.
  183. [14:10:58]: 10.133.32.67: Installing augeas-tools.
  184. [14:10:57]: 10.133.32.67: Installing bzip2.
  185. [14:10:55]: 10.133.32.67: Installing libmecab2.
  186. [14:10:53]: 10.133.32.67: Installing libnuma1.
  187. [14:10:51]: 10.133.32.67: Installing pigz.
  188. [14:10:49]: 10.133.32.67: Installing curl.
  189. [14:10:47]: 10.133.32.67: Installing wget.
  190. [14:10:44]: 10.133.32.67: Installing libdbd-mysql-perl.
  191. [14:10:41]: 10.133.32.67: Installing libssl1.0.0.
  192. [14:10:39]: 10.133.32.67: Installing lsb-release.
  193. [14:10:36]: 10.133.32.67: Installing socat.
  194. [14:10:35]: 10.133.32.67: Installing netcat-openbsd.
  195. [14:10:33]: 10.133.32.67: Installing netcat.
  196. [14:10:32]: 10.133.32.67: Installing libaio1.
  197. [14:10:30]: 10.133.32.67: Installing rsync.
  198. [14:10:29]: 10.133.32.67: Installing psmisc.
  199. [14:10:14]: 10.133.32.67: Proceeding.
  200. [14:10:13]: 10.133.32.67: Waiting for dpkg lock.
  201. [14:10:13]: 10.133.32.67: Installing helper packages.
  202. [14:10:13]: 10.133.32.67: Setting vm.swappiness = 1.
  203. [14:10:13]: 10.133.32.67: Tuning OS parameters.
  204. [14:10:12]: 10.133.32.67: Disabling firewall.
  205. [14:10:12]: 10.133.32.67: Checking SELinux status (enabled = false).
  206. [14:10:12]: 10.133.32.67: Check and disable AppArmor.
  207. [14:10:12]: Calling job: setupServer(10.133.32.67:3306).
  208. [14:10:12]: 10.133.34.74:3306: Checking if host already exists in some other cluster.
  209. [14:10:12]: 10.133.32.154:3306: Checking if host already exists in some other cluster.
  210. [14:10:12]: 10.133.32.67:3306: Checking if host already exists in some other cluster.
  211. [14:10:12]: All 3 hosts are accessible by SSH.
  212. [14:10:12]: 10.133.34.74: Access with ssh/sudo granted.
  213. [14:10:11]: 10.133.32.154: Access with ssh/sudo granted.
  214. [14:10:10]: 10.133.32.67: Access with ssh/sudo granted.
  215. [14:10:10]: Checking ssh/sudo on 3 hosts.
  216. [14:10:10]: Verifying job parameters.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!