Event Timeline
Comment Actions
while read server port dbs; do for db in $dbs; do echo "$server $port $db:" $(sudo -i mysql.py -BN -h $server -P $port $db -e "show tables"); done; done < test.dbs db1075.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1 db1078.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1 db1079.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1 db1081.eqiad.wmnet 3306 test: t1 t2 db1083.eqiad.wmnet 3306 test: eltx db1084.eqiad.wmnet 3306 test: eltx db1085.eqiad.wmnet 3306 test: dsns replicate db1086.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1 db1088.eqiad.wmnet 3306 test: dsns replicate db1089.eqiad.wmnet 3306 test: eltx db1090.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1 db1091.eqiad.wmnet 3306 test: eltx db1093.eqiad.wmnet 3306 test: dsns replicate db1094.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1 db1095.eqiad.wmnet 3313 test: idbt ipblocks t3 t5 t6 test1 db1096.eqiad.wmnet 3315 test: db1096.eqiad.wmnet 3316 test: replicate db1098.eqiad.wmnet 3316 test: replicate db1098.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1 db1099.eqiad.wmnet 3311 test: eltx db1100.eqiad.wmnet 3306 test: db1101.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1 db1112.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1 db1113.eqiad.wmnet 3316 test: replicate db1116.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1 db1117.eqiad.wmnet 3325 test_labsdbaccounts: account account_host db1120.eqiad.wmnet 3306 test: db1121.eqiad.wmnet 3306 test: t1 t2 db1123.eqiad.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1 db1127.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1 db1130.eqiad.wmnet 3306 test: db1131.eqiad.wmnet 3306 test: dsns replicate db1133.eqiad.wmnet 3306 test_labsdbaccounts: account account_host db1134.eqiad.wmnet 3306 test: eltx db1135.eqiad.wmnet 3306 test: eltx db1136.eqiad.wmnet 3306 test: idbt t3 t5 t6 test1 db1138.eqiad.wmnet 3306 test: t1 t2 db1141.eqiad.wmnet 3306 test: t1 t2 db1144.eqiad.wmnet 3314 test: t1 t2 db1144.eqiad.wmnet 3315 test: db1145.eqiad.wmnet 3314 test: t1 t2 db1145.eqiad.wmnet 3315 test: db1148.eqiad.wmnet 3306 test: t1 t2 db1149.eqiad.wmnet 3306 test: t1 t2 db2073.codfw.wmnet 3306 test: t1 t2 db2074.codfw.wmnet 3306 test: idbt ipblocks t3 t5 t6 test1 db2076.codfw.wmnet 3306 test: replicate db2077.codfw.wmnet 3306 test: idbt t3 t5 t6 test1 db2078.codfw.wmnet 3325 test_labsdbaccounts: account account_host db2085.codfw.wmnet 3311 test: eltx db2086.codfw.wmnet 3317 test: idbt t3 t5 t6 test1 db2087.codfw.wmnet 3316 test: replicate db2087.codfw.wmnet 3317 test: idbt t3 t5 t6 test1 db2088.codfw.wmnet 3311 test: eltx db2089.codfw.wmnet 3316 test: replicate db2090.codfw.wmnet 3306 test: t1 t2 db2092.codfw.wmnet 3306 test: eltx db2093.codfw.wmnet 3306 test: db2093.codfw.wmnet 3306 test_labswiki: abuse_filter abuse_filter_action abuse_filter_history abuse_filter_log actor archive babel betafeatures_user_counts bv2017_edits category categorylinks change_tag change_ta g_def comment config content content_models cu_changes cu_log echo_email_batch echo_event echo_notification echo_target_page external_user externallinks filearchive flow_ext_ref flow_revision flow_subscription f low_topic_list flow_tree_node flow_tree_revision flow_wiki_ref flow_workflow geo_tags global_block_whitelist globalblocks globalimagelinks hidden historical_thread image imagelinks interwiki ip_changes ipblocks ipblocks_restrictions iwlinks job l10n_cache langlinks ldap_domains linter log_search logging mathoid module_deps msg_resource msg_resource_links oaiaudit oaiharvest oaiuser oathauth_users oathauth_users_restore oauth2_access_tokens oauth_accepted_consumer oauth_registered_consumer objectcache oldimage openstack_notification_event openstack_puppet_classes openstack_puppet_groups openstack_puppet_vars openstack_tokens p age page_props page_restrictions pagelinks profiling protected_titles querycache querycache_info querycachetwo recentchanges redirect revision revision_actor_temp revision_comment_temp searchindex site_identifie rs site_stats sites slot_roles slots spoofuser templatelinks text thread thread_history thread_pending_relationship thread_reaction titlekey trackbacks transcache updatelog updates uploadstash user user_daily_co ntribs user_former_groups user_groups user_message_state user_newtalk user_openid user_properties watchlist watchlist_expiry wikilove_log db2114.codfw.wmnet 3306 test: replicate db2118.codfw.wmnet 3306 test: idbt t3 t5 t6 test1 db2120.codfw.wmnet 3306 test: idbt t3 t5 t6 test1 db2121.codfw.wmnet 3306 test: idbt t3 t5 t6 test1 db2122.codfw.wmnet 3306 test: idbt t3 t5 t6 test1 db2135.codfw.wmnet 3306 test_labsdbaccounts: account account_host db2136.codfw.wmnet 3306 test: t1 t2 dbstore1003.eqiad.wmnet 3311 test: eltx dbstore1003.eqiad.wmnet 3317 test: idbt t3 t5 t6 test1 dbstore1004.eqiad.wmnet 3313 test: idbt ipblocks t3 t5 t6 test1 dbstore1004.eqiad.wmnet 3314 test: t1 t2 es1011.eqiad.wmnet 3306 test: es1013.eqiad.wmnet 3306 test: es1014.eqiad.wmnet 3306 test: es1017.eqiad.wmnet 3306 test: es2017.codfw.wmnet 3306 test: es2018.codfw.wmnet 3306 test: es2019.codfw.wmnet 3306 test: pc1008.eqiad.wmnet 3306 test:
Comment Actions
cat test.dbs | grep '\<test\>' | grep codfw | while read server port ignore; do echo "$server:$port"; sudo -i mysql.py -h $server -P $port -e "set sql_log_bin=0; drop database if exists test"; done
Comment Actions
Diff looks good:
kormat@cumin1001:~(0:0)$ diff -u test.dbs test.dbs.2 --- test.dbs 2020-07-28 12:02:26.882398853 +0000 +++ test.dbs.2 2020-07-28 12:41:32.236716003 +0000 @@ -42,27 +42,9 @@ db1145.eqiad.wmnet 3315 test db1148.eqiad.wmnet 3306 test db1149.eqiad.wmnet 3306 test -db2073.codfw.wmnet 3306 test -db2074.codfw.wmnet 3306 test -db2076.codfw.wmnet 3306 test -db2077.codfw.wmnet 3306 test db2078.codfw.wmnet 3325 test_labsdbaccounts -db2085.codfw.wmnet 3311 test -db2086.codfw.wmnet 3317 test -db2087.codfw.wmnet 3316 test -db2087.codfw.wmnet 3317 test -db2088.codfw.wmnet 3311 test -db2089.codfw.wmnet 3316 test -db2090.codfw.wmnet 3306 test -db2092.codfw.wmnet 3306 test -db2093.codfw.wmnet 3306 test test_labswiki -db2114.codfw.wmnet 3306 test -db2118.codfw.wmnet 3306 test -db2120.codfw.wmnet 3306 test -db2121.codfw.wmnet 3306 test -db2122.codfw.wmnet 3306 test +db2093.codfw.wmnet 3306 test_labswiki db2135.codfw.wmnet 3306 test_labsdbaccounts -db2136.codfw.wmnet 3306 test dbstore1003.eqiad.wmnet 3311 test dbstore1003.eqiad.wmnet 3317 test dbstore1004.eqiad.wmnet 3313 test @@ -71,7 +53,4 @@ es1013.eqiad.wmnet 3306 test es1014.eqiad.wmnet 3306 test es1017.eqiad.wmnet 3306 test -es2017.codfw.wmnet 3306 test -es2018.codfw.wmnet 3306 test -es2019.codfw.wmnet 3306 test pc1008.eqiad.wmnet 3306 test