第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

APP 項目架構(gòu)設(shè)計

服務端架構(gòu)

• 采用異步的微服務架構(gòu)

• 實現(xiàn)了業(yè)務上的解耦
  

APP 項目架構(gòu)設(shè)計

• 服務端：Tomcat

• 熱點數(shù)據(jù)放在高速緩存
  

系統(tǒng)架構(gòu)方案

系統(tǒng)架構(gòu)方案

MySQL 高性能高可用集群方案

• 不重要的數(shù)據(jù)先分配到緩存（Redis，MongoDB 等 NoSQL 數(shù)據(jù)庫）
  

MySQL 高性能高可用集群方案 Rep

• 數(shù)據(jù)量大

• 單挑價值不高
  

MySQL 高性能高可用集群方案

• 數(shù)據(jù)切分（分片）

• 負載均衡
  

單節(jié)點數(shù)據(jù)庫高可用測試

D:\軟件\MySQL\MySQL\bin>mysqlslap?-hlocalhost?-uroot?-pabc123456?-P3306?--concurrency=10000?--iterations=1?--auto-generate-sql?--auto-generate-sql-load-type=mixed?--auto-generate-sql-add-autoincrement?--engine=innodb?--number-of-queries=10000?--debug-info

mysqlslap:?Error?when?connecting?to?server:?2003?Can't?connect?to?MySQL?server?on?'localhost'(10061)
mysqlslap:?Error?when?connecting?to?server:?2003?Can't?connect?to?MySQL?server?on?'localhost'(10061)
mysqlslap:?Error?when?connecting?to?server:?2003?Can't?connect?to?MySQL?server?on?'localhost'(10061)
mysqlslap:?Error?when?connecting?to?server:?2003?Can't?connect?to?MySQL?server?on?'localhost'(10061)
mysqlslap:?Error?when?connecting?to?server:?2003?Can't?connect?to?MySQL?server?on?'localhost'(10061)
Benchmark
Running?for?engine?innodb
Average?number?of?seconds?to?run?all?queries:48.547?seconds
Minimum?number?of?seconds?to?run?all?queries:48.547seconds
Maximum?number?of?seconds?to?run?all?queries:48.547?seconds
Number?of?clients?running?queries:10000
Average?number?of?queries?per?client:?1

單節(jié)點數(shù)據(jù)庫壓力測試

測試案例

Benchmark
Running?for?engine?innodb
AVerage?number?of?seconds?to?run?all?queries:0.234?seconds
Minimum?number?of?seconds?to?run?all?queries:0.234?seconds
Maximum?number?of?seconds?to?run?all?queries:0.2340econds
Number?of?clients?running?queries:100
Avefage?number?of?quenes?per?client:50

Benchmark
Running?for?engine?innodb
verage?number?of?seconds?to?run?all?queries:1.656?seconds
Minimum?number?of?seconds?to?run?all?queries:1.656?seconds
Maxmum?number?of?seconds?to?run?all?queries:1.656?seconds
Number?of?dients?running?queries?500?
Average?number?of?queries?per?clent:10

Benchmark
Running?for?engine?innodb
Average?number?of?seconds?to?run?all?queries:2187?seconds
Minimum?number?of?seconds?to?run?all?queries2.18/seconds
Maximum?number?of?seconds?to?run?all?queries:2187?seconds
Number?of?dients?running?queries:1000
Average?number?of?quenes?per?client?5

并發(fā) 100、500 和 1000 個連接，執(zhí)行 5000 次查詢，單節(jié)點數(shù)據(jù)還可以正常應對，沒有太大的問題。

單節(jié)點數(shù)據(jù)庫壓力測試

測試案例

mysqlslap?-hlocalhost?-uroot?-pabc123456?-P3306
--concurrency=1000?--iterations=1?--auto-generate-sql
--auto-generate-sql-load-type=mixed
--auto-generate-sql-add-autoincrement
--engine=innodb
--number-of-queries=5000
--debug-info

單節(jié)點數(shù)據(jù)庫的弊病

情況說明

• 大型互聯(lián)網(wǎng)程序用戶群體龐大，所以架構(gòu)必須要特殊設(shè)計

• 單節(jié)點的數(shù)據(jù)庫無法滿足性能上的要求

• 單節(jié)點的數(shù)據(jù)庫沒有冗余設(shè)計，無法滿足高可用

Win10 x64 專業(yè)版或企業(yè)版/Linux/MacOS

Docker 虛擬機

內(nèi)存 8GB 以上

掌握 PXC 集群 MySQL 方案的原理

掌握 PXC 集群的強一致性

掌握 PXC 集群的高可用方案

向大型互聯(lián)網(wǎng)應用看齊，學習架構(gòu)設(shè)計和業(yè)務處理

由淺入深，循序漸進；案例由小到大，逐步擴展

“視頻學習”優(yōu)于“看書學習”