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

APP 項(xiàng)目架構(gòu)設(shè)計(jì)

服務(wù)端架構(gòu)

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

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

APP 項(xiàng)目架構(gòu)設(shè)計(jì)

• 服務(wù)端：Tomcat

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

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

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

MySQL 高性能高可用集群方案

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

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

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

• 單挑價(jià)值不高
  

MySQL 高性能高可用集群方案

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

• 負(fù)載均衡
  

單節(jié)點(diǎn)數(shù)據(jù)庫(kù)高可用測(cè)試

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é)點(diǎn)數(shù)據(jù)庫(kù)壓力測(cè)試

測(cè)試案例

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 個(gè)連接，執(zhí)行 5000 次查詢，單節(jié)點(diǎn)數(shù)據(jù)還可以正常應(yīng)對(duì)，沒(méi)有太大的問(wèn)題。

單節(jié)點(diǎn)數(shù)據(jù)庫(kù)壓力測(cè)試

測(cè)試案例

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é)點(diǎn)數(shù)據(jù)庫(kù)的弊病

情況說(shuō)明

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

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

• 單節(jié)點(diǎn)的數(shù)據(jù)庫(kù)沒(méi)有冗余設(shè)計(jì)，無(wú)法滿足高可用

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

Docker 虛擬機(jī)

內(nèi)存 8GB 以上

掌握 PXC 集群 MySQL 方案的原理

掌握 PXC 集群的強(qiáng)一致性

掌握 PXC 集群的高可用方案

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

由淺入深，循序漸進(jìn)；案例由小到大，逐步擴(kuò)展

“視頻學(xué)習(xí)”優(yōu)于“看書(shū)學(xué)習(xí)”