AWS Cloud, Python, Use sshtunneling to store rds data in a local database
1. config.py ----------------------------------------------------------------------- #SSH Cloud username = 'ubuntu' pkey = './aws.pem' pkey_password = '' gateway_url = 'anonymous.compute.amazonaws.com' local_bind_address = '0.0.0.0' local_port = 3307 #AmazoneDB remote_bind_address = 'anonymous.rds.amazonaws.com' remote_db_user = 'USERID' remote_db_password = 'PASSWORD' remote_port = 3306 select_db = 'DATABASE' #LocalTestDB dev_host = '192.168.0.XXX' dev_user = 'USERID' dev_password = 'PASSWORD' dev_port = 3306 db_charset = 'utf8' insert_db = 'DATABASE' ''' use mysql create database DATABASENAME; grant all privileges on DATABASENAME.* to USERID@localhost identified by 'PASSWORD'; grant all privileges on DATABASENAME.* to USERID@'%' identified by 'PASSWORD'; flush privileges; quit; END''' ''' create table logs ( seq i...