金融行業(yè)數(shù)據(jù)庫架構(gòu)分析

1、金融行業(yè)數(shù)據(jù)庫架構(gòu)分析What a DBA ？優(yōu)化網(wǎng)站數(shù)據(jù)庫對開發(fā)人員進行培訓(xùn)網(wǎng)站架構(gòu)調(diào)整數(shù)據(jù)庫硬件性能壓力測試數(shù)據(jù)庫安全自動化數(shù)字化運維平臺2-31What a DBA ？3-31歸納為：數(shù)據(jù)安全標(biāo)準(zhǔn)化自動化可視化性能成本數(shù)據(jù)安全4-31Delay Data RollBackBackupMssql/mysqlMssql/mysql Read OnlyOperateDBALog BacpupHA5-31DBAs Operate LogReport /mailMssql/mysqlGreenplumMssql/mysql記錄DBA操作，提供審計功能支持 BI 血緣系統(tǒng)特殊操作分類提醒6-31DB

2、As Operate Log7-31DBAs Operate Log8-31DBAs Privilege auditDBAPrivilege auditYYcommitRollback & Log9-31Create table 必須要有主鍵，主鍵長度=20字節(jié)， 必須包含colum comment、dev_ownerDrop table 必須先改名，再刪除字段中包含varchar(max) nvarchar(max) Text、image 會提示個人用戶賬號高頻次登錄失敗會提示并禁用賬號.審核規(guī)范示例：DBAs Privilege audit10-31標(biāo)準(zhǔn)化11-31DB&OS Instal

3、l &Configure/Per Test數(shù)據(jù)庫安 裝操作系統(tǒng) 加固性能壓測12-31數(shù)據(jù)庫一鍵安裝MysqlMssql 操作系統(tǒng)加固Linux Windows性能壓測MysqlSysbenchmysqlslap MssqlSqlioOstressSqlsimDiskspdDB&OS Install &Configure/Per Test13-31Meta Data- Datadictionary14-31Meta Data-Datadictionary15-31Meta Data-DB/OSMeta DataWindowsMetaData16-31Meta Data-DB/OSMeta Da

4、taLinux MetaData17-31Meta Data-DB/OSMeta DataMssqlServer MetaData18-31Meta Data-DB/OSMeta DataMysql MetaData19-31DB Features ConfigureMssqlLogshippingMirrorAlwaysOnClusterSSBCDCMysqlMHA20-31DB Features ConfigureHostN ode1HostN ode2StorageWWMSSQL1 MSSQL2HostN ode1HostN ode2StorageWMSSQL1MSSQL2WMssqlL

5、oad balance21-31High Safety MirrorCluster/Always on clusterDB Features ConfigureMysqlMHA/SlaveSlave01-1-3306Mater02-3406Master01-3306Slave01-2-3406Slave01-2-3306Slave02-1-3406/MHASlave0222-31自動化可視化23-31自動化可視化24-31自動化可視化25-31自動化可視化26-31性能成本服務(wù)器硬件成本、折舊率數(shù)據(jù)存儲生命周期業(yè)務(wù)性能指標(biāo)TPS、QPS、Iops27-31性能成本28-31性能成本29-31性能