⽤户需要什么样的数据库？开箱即⽤的开源数据库发⾏版：搅局者 Pigsty（63页）.pdf

1、户需要什么样的数据库？冯若航开箱即的开源数据库发版：搅局者 Pigsty2022-01-09是 分布式云原湖仓体流批时空超融合HTAP 数据库内核？户需要什么？户需要的是 解决案户 客户机器管理，络规划，安装部署，应接，基础设施，CMDB备份恢复，主从复制，连接池，可，故障切换，负载均衡，服务发现监控告警，动扩缩容，沙箱环境，动部署，安全加固，版本升级，模式变更，数据抽取，平台搭建，审计合规FederatedGeoSpatialTimeSeriesDistributiveOLAPStreamingFDWVIPDCSLoad BalancerMiddlewareDatabaseHA AgentM

2、onitorDNSAccessAlertTSDB DCSPigstyGraphNTPNTPDNSPatroni8008Consul8500Postgres5432primaryPgbouncer64329631PGBExporter9100NodeExporter5433543454365438Haproxy91019630PGExporter5433543454365438vip-managerPrometheus90908500ConsulServer80Yum Repo123NTPDServerDNSMASQ53AlertManager9093Grafana3000MetaDB5432p

3、rimaryhcyapgNginx808600ConsulDNSAnsibleCronjobsNTP/Chronyconsensusvisualizetrafficpeer nodesfiringscrapeexposeregisterconsensussuperviseleaderinquiryadminpoolingidentitymappinghealthcheckmetricsresolveinstalldelegatetime-syncPostgres5432primaryPostgreSQL是个够完美的数据库内核但使数据库内核功能，与架构产级数据系统，是完全不同的两件事什么是解决案

4、？质量价可扩展性可维护性可靠性成本开销钱多 快 好 省什么样的解决案？可靠，可扩展，可维护的完整解决案！（最好还不要钱！）开源免费的开箱即的PostgreSQL完整解决案Pigsty&Redis,Greenplum,etc架构演进A complex system that works is invariably found to have evolved from a simple system that works.The inverse proposition also appears to be true:A complex system designed from scratch ne

5、ver works and cannot be made to work.John Gall,Systemantics(1975)甲视有效的复杂系统总是从简单的系统演化来。反之亦然：从零设计的复杂系统没个能有效作的。架构演进?MasterPostgreSQLSlavePostgreSQL?Golangappapp?MasterMasterChatMasterDeviceMaster-Slave-OfflineCoreGolangChat ServiceGolangModerationGolangAccountGolangPaymentGolangCore ServiceGolangappPos

6、tgreSQLtables?Golang162738495XGolang162738495X?MSChatShard 1MSChatShard 2MSChatShard nMSGiftShard 1MSGiftShard 2MSGiftShard nMSShard 1MSShard 2MSShard nGolang162738495XGolang162738495XGolang162738495XMasterPostgreSQLSlavePostgreSQLSlavePostgreSQLSlavePostgreSQL?OfflinePostgreSQLReplicationGolangappa