Netflix Billing Migration to AWS

Netflix Billing Migration 관련 Tech Blog 자료를 보다 간략하게 정리를 했음 기존 Oracle 에서 AWS 의 MySQL 로 넘어 가는 과정을 정리 했는데 느끼는 점이 많음

IDC (ORACLE) -> AWS(EC2+MySQL5.6) -> AWS Auroa

Master Replication -> DBDC

Read Slave -> Async Replication

http://techblog.netflix.com/2016/06/netflix-billing-migration-to-aws.html http://techblog.netflix.com/2016/07/netflix-billing-migration-to-aws-part-ii.html http://techblog.netflix.com/2016/08/netflix-billing-migration-to-aws-part.html

###
# Netflix MySQL Billing Database
# MySQL 5.6 + Linux 
###

--
-- 01. Bluk Insert
--

innodb_log_file_size = 2048M
innodb_lru_scan_depth = 128
innodb_adaptive_hash_index = off
innodb_flush_neighbors = off
transaction_isolation = READ-COMMITTED
query_cache_size = 0
query_cache_type = 0
innodb_doublewrite = off


--
-- 02. High Transction
-- 

innodb_log_file_size = 2048M
innodb_lru_scan_depth = 128
innodb_adaptive_hash_index = off
innodb_flush_neighbors = off
transaction_isolation = READ-COMMITTED
query_cache_size = 0
query_cache_type = 0
innodb_doublewrite = off

innodb_max_dirty_pages_pct = 80
innodb_buffer_pool_instances = 8
innodb_log_buffer_size = 64<


--
-- 03 os kernel
--

kernel.numa_balancing = 0 # instead of numactl

vm.dirty_ratio = 40
vm.dirty_background_ratio = 5
vm.swappiness = 0
vm.aio-max-nr = 65535
vm.rq_affinity = 2
vm.scheduler = cfq