Nguyen Tan Vy v0112358

Bizcloud simple storage

s3fs cdn_simple /bizfly -o use_cache=/tmp/ -o parallel_count=25 -o passwd_file=/root/.passwd-bizfly -o sigv2 -o url=https://ss-hn-1.vccloud.vn

Viettel Cloudstorage

s3fs cdn_simple /viettel -o sigv2 -o use_path_request_style -o use_cache=/tmp/ -o parallel_count=25 -o passwd_file=/root/.passwd-viettel -o url=http://s1.cloudstorage.com.vn

Change the relay_log variable in the my.cnf to relay_log = /mnt/relay/mysql_relay_bin
Stop mysqld

systemctl stop mysqld

Move all relay_log to new location:

Odssey

Advanced multi-threaded PostgreSQL connection pooler and request router.

How to build odyssey on CentOS 7

yum install git cmake postgresql11-devel openssl-devel zlib-devel gcc -y
PATH=$PATH:/usr/pgsql-11/bin/
export PATH
LD_LIBRARY_PATH=/usr/pgsql-11/lib/

1/ On master

CREATE TABLE event_store (
id bigint DEFAULT nextval('public.eid_seq_1'::regclass) NOT NULL,
topic character varying(255),
created_at timestamp(6) without time zone DEFAULT now()
) PARTITION BY RANGE (created_at);

1/ Check index size

SELECT concat(table_schema,'.',table_name) tables,
concat(round(table_rows/1000000,2),'M') rows,
concat(round(data_length/(1024*1024*1024),2),'G') data_size,
concat(round(index_length/(1024*1024*1024),2),'G') index_size,
concat(round((data_length+index_length)/(1024*1024*1024),2),'G') total_size,
round(index_length/data_length,2) index_data_ratio
FROM information_schema.TABLES
WHERE table_name like "%PRIVILEGES%"

MongoDB with replica sets before switchover:

mongodb-01: {role: primary, priority: 9, hidden: 0}
mongodb-02: {role: secondary, priority: 1, hidden: 0}
mongodb-03: {role: secondary, priority: 1, hidden: 0}
mongodb-04: {role: secondary, priority: 7, hidden: 0}
mongodb-05: {role: secondary, priority: 1, hidden: 0}

MongoDB with replica sets after switchover:

The error message:

Error: Invalid resource type

  on vpc-prod-cicd-k8s.tf line 1, in resource "digitalocean_vpc" "vpc_prod_cicd_k8s":
   1: resource "digitalocean_vpc" "vpc_prod_cicd_k8s" {

The provider provider.digitalocean does not support resource type
"digitalocean_vpc".

	Numbers & types of operations (selects, updates, inserts, rollbacks, etc)
	Cache hit rates and sizing recommendations
	Query response times
	Table scans and index usage
	Temporary disk tables
	Abnormal connection events
	Replication status

-rmmod iptable_nat
-rmmod nf_nat_ipv4
-rmmod nf_nat
-rmmod nf_conntrack_ipv4
-rmmod nf_conntrack

	- How many transaction does the database handle per table, per hour?
	- Which table has the most inserts?
	- Do we delete data from this table?
	- Which hour has the highest peak of updates, and on which tables?