Skip to content

Instantly share code, notes, and snippets.

View jc1518's full-sized avatar
🐶

Jackie Chen jc1518

🐶
View GitHub Profile
@jc1518
jc1518 / k8s_jira_statefulset.yaml
Last active November 6, 2019 03:44
Jira statefulset config file on k8s
---
apiVersion: apps/v1
kind: StatefulSet
metadata:
name: jira
spec:
serviceName: jira
replicas: 3
selector:
matchLabels:
@jc1518
jc1518 / accounts.yaml
Created January 17, 2020 04:09
Ansbile playbook sample - get dictionary value
---
- hosts: localhost
vars:
accounts:
dev:
account: 123
contact: Jackie@123.com
uat:
account: 456
---
atl_db_root_password: "{{ (lookup('aws_secret', '/jira/database/master', region='ap-southeast-2')| from_json).get('password') }}"
current_epoch_time_sec: "{{ ansible_date_time.epoch }}"
delete_threshold_hours: '24'
@jc1518
jc1518 / a3.py
Created July 30, 2020 05:42
Automate Atlassian Addons POC
# a3 = Automate Atlassian Addons
def get_server_info(server, auth):
''' Check application version on the server '''
print("\n>>> Checking server information")
server_application = server.split('.')[0].split('-')[0]
url = "https://{}/rest/applinks/1.0/manifest".format(server)
headers = {'content-type': 'application/xml'}
response = requests.get(url, auth=auth, headers=headers)
response.raise_for_status()
@jc1518
jc1518 / s3_endpoint_policy_sample.json
Created August 26, 2020 06:26
s3_endpoint_policy_sample
{
"Version": "2012-10-17",
"Statement": [
{
"Sid": "MyTestDataBucketReadAccess",
"Effect": "Allow",
"Principal": {
"AWS": "*"
},
"Action": [
@jc1518
jc1518 / jira_ami_snappy.yaml
Created September 24, 2020 06:35
Code snippet for adding snappy support in Jira AMI
- name: Install dependencies for snappy
yum:
name:
- gcc
- gcc-c++
- automake
- snappy
- snappy-devel
- git
when: atl_product_family == "jira"
@jc1518
jc1518 / jira_restore_index_from_snapshot.yaml
Last active October 29, 2020 10:17
Code snippet for restoring Jira index files from snapshot
---
- name: Wait for index files folder ready
wait_for:
path: "{{ atl_product_home }}/caches/indexesV1"
delay: 60
sleep: 10
timeout: 120
ignore_errors: yes
@jc1518
jc1518 / jira_remove_old_operations.yaml
Created October 29, 2020 10:20
jira_remove_old_operations.yaml
---
- name: Delete old jira node operation records from replicatedindexoperation table
postgresql_query:
login_host: "{{ atl_db_host }}"
port: "{{ atl_db_port }}"
login_user: "{{ atl_db_root_user }}"
login_password: "{{ atl_db_root_password }}"
db: "{{ atl_jdbc_db_name }}"
query: DELETE FROM replicatedindexoperation AS Rep WHERE Rep.node_id NOT IN (SELECT node_id from clusternode)
---
- name: Check if this is a new cluster that has not been initialized
stat:
path: "{{ atl_product_home_shared }}/export/indexsnapshots"
register: snapshotfolder
- name: Remove offline jira nodes from clusternode table
postgresql_query:
login_host: "{{ atl_db_host }}"
@jc1518
jc1518 / on_prem_instance_profile.py
Last active December 10, 2020 13:14
Rotate AWS credential for on-prem servers which has tag on-prem:bamboo-agent
import os
import json
import logging
import time
import boto3
logger = logging.getLogger()
logger.setLevel(logging.INFO)
sts_client = boto3.client("sts")