Paste P17244

aqs transfer script
ActivePublic
Actions

Authored by hnowlan on Sep 7 2021, 9:57 AM.

Tags

None

Referenced Files

	F34635525: aqs transfer script
	Sep 7 2021, 9:57 AM

Subscribers

None

	export SRCS=(aqs1004 aqs1007)
	export DSTS=(aqs1010 aqs1011)
	export TABLES=(local_group_default_T_unique_devices local_group_default_T_mediarequest_top_files local_group_default_T_mediarequest_top_files local_group_default_T_mediarequest_top_files local_group_default_T_mediarequest_top_files local_group_default_T_lgc_pagecounts_per_project local_group_default_T_top_percountry local_group_default_T_top_pageviews local_group_default_T_editors_bycountry local_group_default_T_mediarequest_per_referer local_group_default_T_top_bycountry local_group_default_T_top_pageviews)

	for TABLE in "${TABLES[@]}"; do
	for i in "${!SRCS[@]}"; do sudo transfer.py "${SRCS[$i]}.eqiad.wmnet:/srv/cassandra-a/data/$TABLE" "${DSTS[$i]}.eqiad.wmnet:/home/hnowlan/${TABLE}-a" ; done
	for i in "${!SRCS[@]}"; do sudo transfer.py "${SRCS[$i]}.eqiad.wmnet:/srv/cassandra-b/data/$TABLE" "${DSTS[$i]}.eqiad.wmnet:/home/hnowlan/${TABLE}-b" ; done
	done

Event Timeline

hnowlan created this paste.Sep 7 2021, 9:57 AM