mysql ocp課程概要與視聽內(nèi)容

Oracle數(shù)據(jù)庫培訓侯圣文MySQL

OCP課程概要與試聽內(nèi)容恩墨學院

傳DBA成功之路，授IT人立身業(yè)個人簡介MySQL5.0認證工程師（CMDBA）6+年MySQL學習和工作經(jīng)驗MySQL中國用戶組（CMUG）線下活動組織者之一2第一部分課程內(nèi)容介紹第一部分課程內(nèi)容介紹8天課時14個章節(jié)MySQL5.6OCP考前輔導課程安排第一天第1章背景及架構(gòu)介紹第2章安裝、配置及維護第二天第2章(繼續(xù))第三天第3章用戶管理及安全第4章事物與鎖第四天第5章存儲引擎第6章表維護課程安排(續(xù))第五天第7章備份與恢復第8章數(shù)據(jù)導入導出第六天第9章主從復制第10章獲取元數(shù)據(jù)第七天第11章數(shù)據(jù)類型第12章分區(qū)第13章MySQL內(nèi)部編程第八天第14章性能調(diào)優(yōu)簡介總結(jié)與考前輔導課程目標了解MySQL整體架構(gòu)能夠獨立完成數(shù)據(jù)庫環(huán)境搭建制定安全有效的備份與恢復方案為開發(fā)提供日常數(shù)據(jù)庫支持和數(shù)據(jù)庫開發(fā)規(guī)范培訓了解目前流行的數(shù)據(jù)庫高可用方案能夠獨立解決一些常見的數(shù)據(jù)庫故障和性能問題第二部分試聽內(nèi)容分享第一節(jié)MySQL產(chǎn)品介紹第二節(jié)MySQL技術介紹第一節(jié)MySQL產(chǎn)品介紹EventsMichael“Monty”WideniusMySQLAB,2Swedes&1Finn,1995AcquiredbySun,2008AcquiredbyOracle,201010PopularityTheworld'smostpopularopensourcedatabaseInstalledoneverycontinetintheworldRunson20+platformsReliability,excellentperformanceandeaseofuseLAMPFastestgrowing“Makesuperiordatabasesoftwareavailableandaffordabletoall!”11MySQLDatabaseServerEditions12MySQLCommunityEditionOpensource,noncommercialMySQLClusterCommunityEditionOpensource,noncommercial,clusterGPLMySQLClassicEditionEmbeddeddatabaseforOEMs,ISVs,VARsMySQLStandardEditionHigh-performance,scalableOLTPapplications,MySQLWorkbenchSEMySQLEnterpriseEditionEnterprisefeatures:monitoring,backup,scalability,security,auditing,highavailabilityOracleproductintegrationsMySQLClusterCarrierGradeEditionHigh-availability,fault-toleranceMySQLClusterManagerSupersetofMySQLCommercialEditionsCommercialMySQLForksandBranchesPerconaServer(XtraDB)Toolkit vs mysql-utilities(free)XtraBackup vs MEBMonitoringPlugins vs MEM|OEMXtraDBCluster vs MySQLClusterMariaDBGaleraClusterMaxScaleWebScaleSQLAlibaba,Facebook,Google,LinkedIn,andTwitterMySQLWebsitesMySQLDownloads

MySQL5.6ReferenceManual

PlanetMySQL

MySQLPerformanceBlog

ExampleDatabases

14MySQLCertificationTheOracleCertificationProgramvalidatesvariouslevelsofMySQLexpertise:Introductory:CertifiedAssociate(CMA)OracleCertifiedAssociate:MySQL5(retired)Intermediate:CertifiedProfessional(CMDBA/CMDEV)OracleCertifiedProfessional:MySQLDatabaseAdministratorOracleCertifiedProfessional:MySQLDeveloperAdvanced:CertifiedExpert(CMCDBA)OracleCertifiedExpert:MySQLClusterDatabaseAdministrator15第二節(jié)MySQL技術介紹Client/ServerArchitectureClientProgramsConnectors:C,C++,Java,Python,.NET,PHP,ODBCCmd-line:mysql,mysqladmin,mysqldump…GUI:MySQLWorkbench,SQLyog,phpMyAdmin…MySQLServerServer:software(mysqld)Host:physicalmachine(hardware,OS,network,etc…)FeaturesMulti-threadssingleprocessSimultaneousclientconnectionsModulararchitectureMultiplestorageenginesTransactionandnon-transaction17

mysqldMySQLServerProcessClient

ProcessTCP/IPmysqlClientProcessPHPSocket(localhost)?DatabaseTCP/IPTCP/IPLinuxWindowsPHPODBCCommunicationProtocolsConnectionspeedWindows:TCP/IP>NamedpipesLinux:Unixsocketfile>TCP/IPAnyplatform:JDBC~=NativeCclientlib>ODBC18DiskspaceDATADIRDatabasesDirectoriesTablesFiles:.frm,{.MYI,.MYD(MyISAM)},{.ibd,ibdata(InnoDB)}SystemdatabaseINFORMATION_SCHEMAPERFORMANCE_SCHEMATestdatabaseOthersLogfiles(general,error,slow,binary,redo,undo)statusfiles(.info,.index)19MemoryusageMemoryallocationcategoriesPer-threadmemoryDynamicallyallocated,eachsessionFreedwhenthesessionendsordoesn’tneedPer-instancememoryOncepreallocated,sharedamongallsessionsFreedwhentheserverisshutdownMemorydatastructuresThreadcacheAvoidtheoverheadofrenewingthreadDatabuffersandcachesGranttablebuffers,keybuffers,tablecache,querycache,hostcache,bufferpools,etc...Memorytables(engine)Onlymain-memoryasdatastoreInternaltemporarytablesMemoryorMyISAMtable,tmp_table_sizeClientspecificbuffersCommunicationbuffer(Threadstack,Connectionbuffer,resultbuffer),read/join/sortbuffer)20ServerPluginsServercomponentscanbeloadedatserverstartuporloadedandunloadedatruntimewithoutrestartingtheserve