Juergen Gotteswinter jserviceorg

## elasticache_dump_to_rdb.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jserviceorg
                / elasticache_dump_to_rdb.md
            
            
              Created
              May 28, 2021 07:36
                — forked from lmmendes/elasticache_dump_to_rdb.md
            
              
                Save Amazon ElastiCache Redis to file dump.rdb
              
          
    Instructions to DUMP localy a Elasticache Redis database

Connect to Redis CLI
$ redis-cli

Enable the current redis as a slave for the master node


## debian-install-zram.sh
#!/bin/bash
#

not_root() {
    echo "ERROR: You have to be root to execute this script"
    exit 1
}

zram_exists() {
    echo "ERROR: /etc/init.d/zram already exists"

## prometheus-extra-etcd-instance.yaml
# To be used with current stable/prometheus-operator helm chart on kops clusters
# where 4001/4002 ports are blocked from the worker nodes
#
# In you helm, disable etcd monitor by setting kubeEtcd.enabled=false
# Then apply this yaml, and you should see the etcd stats on your main instance
#
apiVersion: monitoring.coreos.com/v1
kind: Prometheus
metadata:
  name: prometheus-operator-prometheus-master

## plot_bonnie.sh
#!/bin/bash
#
# script formats bonnie output and calls gnuplot to create a png graph
# of various bonnie parameters.
#
# feed script bonnie++ output - it will attempt to find the last line of bonnie output
# which is all it really cares about anyway
#
# eg: Using uid:65534, gid:65534.
# Writing a byte at a time...done

## mysql-convert-myisam-to-innodb.sh
#!/bin/bash

for t in $(mysql --batch --column-names=false -e "select concat(TABLE_SCHEMA, '.', TABLE_NAME) from INFORMATION_SCHEMA.TABLES where ENGINE = 'MyISAM' and TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA <> 'mysql'" mysql); do
	mysql -e "alter table $t type=InnoDB";
done
	#!/bin/bash
	#

	not_root() {
	echo "ERROR: You have to be root to execute this script"
	exit 1
	}

	zram_exists() {
	echo "ERROR: /etc/init.d/zram already exists"
	# To be used with current stable/prometheus-operator helm chart on kops clusters
	# where 4001/4002 ports are blocked from the worker nodes
	#
	# In you helm, disable etcd monitor by setting kubeEtcd.enabled=false
	# Then apply this yaml, and you should see the etcd stats on your main instance
	#
	apiVersion: monitoring.coreos.com/v1
	kind: Prometheus
	metadata:
	name: prometheus-operator-prometheus-master
	#!/bin/bash
	#
	# script formats bonnie output and calls gnuplot to create a png graph
	# of various bonnie parameters.
	#
	# feed script bonnie++ output - it will attempt to find the last line of bonnie output
	# which is all it really cares about anyway
	#
	# eg: Using uid:65534, gid:65534.
	# Writing a byte at a time...done
	#!/bin/bash

	for t in $(mysql --batch --column-names=false -e "select concat(TABLE_SCHEMA, '.', TABLE_NAME) from INFORMATION_SCHEMA.TABLES where ENGINE = 'MyISAM' and TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA <> 'mysql'" mysql); do
	mysql -e "alter table $t type=InnoDB";
	done