亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

APP 項目架構設計

服務端架構

• 采用異步的微服務架構

• 實現了業務上的解耦
  

APP 項目架構設計

• 服務端：Tomcat

• 熱點數據放在高速緩存
  

系統架構方案

系統架構方案

MySQL 高性能高可用集群方案

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

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

• 數據量大

• 單挑價值不高
  

MySQL 高性能高可用集群方案

• 數據切分（分片）

• 負載均衡
  

單節點數據庫高可用測試

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

單節點數據庫壓力測試

測試案例

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

并發 100、500 和 1000 個連接，執行 5000 次查詢，單節點數據還可以正常應對，沒有太大的問題。

單節點數據庫壓力測試

測試案例

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

單節點數據庫的弊病

情況說明

• 大型互聯網程序用戶群體龐大，所以架構必須要特殊設計

• 單節點的數據庫無法滿足性能上的要求

• 單節點的數據庫沒有冗余設計，無法滿足高可用

Win10 x64 專業版或企業版/Linux/MacOS

Docker 虛擬機

內存 8GB 以上

掌握 PXC 集群 MySQL 方案的原理

掌握 PXC 集群的強一致性

掌握 PXC 集群的高可用方案

向大型互聯網應用看齊，學習架構設計和業務處理

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

“視頻學習”優于“看書學習”