OceanBase学习记录（十）社区版docker安装

　　〔rootobserver01〕catetcredhatrelease
　　CentOSLinuxrelease7。6。1810（Core）
　　安装docker
　　服务器可以连接互联网，网络配置文件配置DNS1关键字并输入正确的dns服务器地址1。1。1。配置本地yum源mountdevcdrommntmount：devsr0iswriteprotected，mountingreadonlycdetcyum。repos。dmkdirbakmvCentOSbakvicentos。repoyuminstallyumutils1。1。3150。el7。noarch
　　下载docker源yumconfigmanageraddrepohttp：mirrors。aliyun。comdockercelinuxcentosdockerce。repoyumconfigmanageraddrepohttp：mirrors。aliyun。comdockercelinuxcentosdockerce。repowgetOetcyum。repos。dCentOSBase。repohttp：mirrors。aliyun。comrepoCentos7。repowgetOetcyum。repos。depel。repohttp：mirrors。aliyun。comrepoepel7。repo1。1。2。执行安装docker〔rootobserver01yum。repos。d〕yumyinstalldockercedockerceclicontainerd。io1。1。3。Docker常用命令查看docker版本dockerversion显示docker系统的信息dockerinfo日志信息dockerlogs故障检查servicedockerstatus启动关闭dockerservicedockerstartstop查看容器日志dockerlogsf容器名orID清理命令，危险！！！清理不用的容器dockercontainerprune清理不用的镜像dockerimageprune清理不用的卷dockervolumeprune1。1。4。安装ob〔rootobserver01yum。repos。d〕systemctlstartdocker启动docker〔rootobserver01yum。repos。d〕dockersearchoceanbase查看docker版的ob镜像NAMEDESCRIPTIONSTARSOFFICIALAUTOMATEDoceanbaseoceanbasexeOceanBaseDatabase2。2ExpressEdition3oceanbaseobceminiobceminiisaministandalonetestimagefo3obpilotoceanbasece3stepstorunanOceanBaseCEdockerinyou2oceanbaseoceanbaseceOceanBaseisopensourcenow。Thisisthedo2zibuyu886oceanbasececlusterOceanBasececluster1oceanbaseobceoperatorobceoperator1huweijieoceanbasecedeploy0oceanbasecentos70superbigfuoceanbase0hongweiqinanolisosoceanbaseAtentativedeployofoceanbase。0stutiredboycentosobBuildenvironmentforOceanBase3。1CE。Crea0〔rootobserver01yum。repos。d〕dockerpullobpilotoceanbasece：latest下载镜像latest：Pullingfromobpilotoceanbasece7a0437f04f83：Pullcomplete615dc48ac9f1：Pullcompleteb10c1cdae3af：Pullcomplete4f4fb700ef54：Pullcompletec0f6c94a6a6a：Pullcomplete792630f35e24：PullcompleteDigest：sha256：7ac28415cf27ba19cb47acb67a55ebf9848ad73a63d80b7e2e85d653233dbaebStatus：Downloadednewerimageforobpilotoceanbasece：latestdocker。ioobpilotoceanbasece：latest〔rootobserver01yum。repos。d〕dockerimages查看镜像REPOSITORYTAGIMAGEIDCREATEDSIZEobpilotoceanbasecelatest943379e0b05b7weeksago2。25GBdockerrunitdm10Gp2881：2881p2883：2883nameoceanbaseceobpilotoceanbasece：latestdockerexecitoceanbasecebash启动docker〔admin07f6a5ad8c5c〕obdclusterstartobdemo启动集群GetlocalrepositoriesandpluginsokOpensshconnectionokClusterparamconfigcheckokCheckbeforestartobserverok〔WARN〕（127。0。0。1）Therecommendedvalueoffs。aiomaxnris1048576（Currentvalue：65536）CheckbeforestartobproxyokStartobserverokobserverprogramhealthcheckokConnecttoobserverokInitializeclusterClusterbootstrapokWaitforobserverinitokobserveripversionportzonestatus127。0。0。13。1。12881zone1activeStartobproxyokobproxyprogramhealthcheckokConnecttoobproxyokInitializeclusterobproxyipportprometheusportstatus127。0。0。128832884activeobdemorunning〔admin07f6a5ad8c5c〕
　　进入docker容器〔rootobserver01〕dockerexecitoceanbasecebash〔admin07f6a5ad8c5c〕lsbmsql。sqlobproxyoceanbasecereadme。mdreadme。md文件里面有集群的部署信息，包括集群名称连接用户名密码等信息
　　连接ob集群〔admin07f6a5ad8c5c〕obclienth127。1urootsysobcesingleP2883prootPWD123cAoceanbaseWelcometotheOceanBase。Commandsendwith；org。密码及集群名称查看md文件YourMySQLconnectionidis8Serverversion：5。6。25OceanBase3。1。1（r48c615943cbd25a6f7b8bdfd8677a13a21709a05e）（BuiltOct21202110：52：05）Copyright（c）2000，2018，Oracle，MariaDBCorporationAbandothers。Typehelp；orhforhelp。Typectoclearthecurrentinputstatement。MySQL〔oceanbase〕MySQL〔oceanbase〕MySQL〔oceanbase〕showdatabases；DatabaseoceanbaseinformationschemamysqlSYSLBACSYSORAAUDITORtest7rowsinset（0。002sec）1。1。5。查看集群的config。yaml
　　里面包括的相关的密码和集群信息〔admin07f6a5ad8c5cobdemo〕pwdhomeadmin。obdclusterobdemo〔admin07f6a5ad8c5cobdemo〕lsconfig。yaml〔admin07f6a5ad8c5cobdemo〕catconfig。yamlOnlyneedtoconfigurewhenremoteloginisrequireduser：username：yourusernamepassword：yourpasswordifneedkeyfile：yoursshkeyfilepathifneedport：yoursshport，default22timeout：sshconnectiontimeout（second），default30oceanbasece：servers：Pleasedontusehostname，onlyIPcanbesupported127。0。0。1global：TheworkingdirectoryforOceanBaseDatabase。OceanBaseDatabaseisstartedunderthisdirectory。Thisisarequiredfield。homepath：homeadminoceanbaseceThedirectoryfordatastorage。Thedefaultvalueishomepathstore。datadir：data1Thedirectoryforclog，ilog，andslog。Thedefaultvalueisthesameasthedatadirvalue。redodir：datalog1Pleasesetdevnameasthenetworkadaptorsnamewhoseipisinthesettingofsevers。ifsetseversas127。0。0。1，pleasesetdevnameasloifcurrentipis192。168。1。10，andtheipsnetworkadaptorsnameiseth0，pleaseuseeth0devname：lomysqlport：2881ExternalportforOceanBaseDatabase。Thedefaultvalueis2881。rpcport：2882InternalportforOceanBaseDatabase。Thedefaultvalueis2882。zone：zone1clusterid：1pleasesetmemorylimittoasuitablevaluewhichismatchingresource。memorylimit：8GThemaximumrunningmemoryforanobserversystemmemory：4GThereservedsystemmemory。systemmemoryisreservedforgeneraltenants。Thedefaultvalueis30G。stacksize：512Kcpucount：16cachewashthreshold：1Gminfullresourcepoolmemory：268435456workerspercpuquota：10schemahistoryexpiretime：1dThevalueofnetthreadcounthadbetterbesameascpuscorenumber。netthreadcount：4majorfreezedutytime：Disableminorfreezetimes：10enableseparatesysclog：0enablemergebyturn：FALSEdatafilediskpercentage：20Thepercentageofthedatadirspacetothetotaldiskspace。Thisvaluetakeseffectonlywhendatafilesizeis0。Thedefaultvalueis90。datafilesize：5Gsysloglevel：ERRORSystemloglevel。ThedefaultvalueisINFO。enablesyslogwf：falsePrintsystemlogswhoselevelsarehigherthanWARNINGtoaseparatelogfile。Thedefaultvalueistrue。enablesyslogrecycle：trueEnableautosystemlogrecyclingornot。Thedefaultvalueisfalse。maxsyslogfilecount：4Themaximumnumberofreservedlogfilesbeforeenablingautorecycling。Thedefaultvalueis0。observerclustername，consistentwithobproxysclusternameappname：obcesinglerootpassword：rootPWD123rootuserpassword，canbeemptyproxyropassword：proxyROPWD123proxyrouserpasword，consistentwithobproxysobserversyspassword，canbeemptyobproxy：servers：127。0。0。1depends：oceanbaseceglobal：listenport：2883Externalport。Thedefaultvalueis2883。prometheuslistenport：2884ThePrometheusport。Thedefaultvalueis2884。homepath：homeadminobproxyoceanbaserootserverlistformat：ip：mysqlport，ip：mysqlportrslist：127。0。0。1：2881enableclustercheckout：falseobserverclustername，consistentwithoceanbasecesappnameclustername：obcesingleobproxysyspassword：proxySYSPWD123obproxysysuserpassword，canbeemptyobserversyspassword：proxyROPWD123proxyrouserpasword，consistentwithoceanbasecesproxyropassword，canbeemptyautomaticmatchworkthread：falseworkthreadnum：12xflushloglevel：ERRORmonitorloglevel：ERRORsysloglevel：ERRORlogdirsizethreshold：1Genablecompressionprotocol：false〔admin07f6a5ad8c5cobdemo〕1。1。6。通过obproxy连接集群〔admin07f6a5ad8c5cobdemo〕obclienth127。1urootsysobcesingleP2883prootPWD123cAoceanbaseWelcometotheOceanBase。Commandsendwith；org。YourMySQLconnectionidis13Serverversion：5。6。25OceanBase3。1。1（r48c615943cbd25a6f7b8bdfd8677a13a21709a05e）（BuiltOct21202110：52：05）Copyright（c）2000，2018，Oracle，MariaDBCorporationAbandothers。Typehelp；orhforhelp。Typectoclearthecurrentinputstatement。MySQL〔oceanbase〕showdatabases；DatabaseoceanbaseinformationschemamysqlSYSLBACSYSORAAUDITORtest7rowsinset（0。016sec）1。1。7。通过observer连接〔admin07f6a5ad8c5cobdemo〕obclienth127。1urootP2881prootPWD123cAoceanbaseWelcometotheOceanBase。Commandsendwith；org。YourMySQLconnectionidis3221518706Serverversion：5。7。25OceanBase3。1。1（r48c615943cbd25a6f7b8bdfd8677a13a21709a05e）（BuiltOct21202110：52：05）Copyright（c）2000，2018，Oracle，MariaDBCorporationAbandothers。Typehelp；orhforhelp。Typectoclearthecurrentinputstatement。MySQL〔oceanbase〕1。1。8。创建租户数据库及表obclienth127。1urootsysobcesingleP2883prootPWD123cAoceanbasealterresourceunitsysunitconfigmincpu5；CREATEresourceunitS4C1Gmaxcpu4，mincpu4，maxmemory1G，minmemory1G，maxiops10000，miniops1000，maxsessionnum1000000，maxdisksize1024G；CREATEresourcepoolmypoolunitS4C1G，unitnum1；createtenantobmysqlresourcepoollist（mypool），primaryzoneRANDOM，commentmysqltenantinstance，charsetutf8setobtcpinvitednodes，obcompatibilitymodemysql；exit；1。1。9。登陆obmysql租户obclienth127。1urootobmysqlobcesingleP2883pcAtestEnterpassword：WelcometotheOceanBase。Commandsendwith；org。YourMySQLconnectionidis9Serverversion：5。6。25OceanBase3。1。1（r48c615943cbd25a6f7b8bdfd8677a13a21709a05e）（BuiltOct21202110：52：05）Copyright（c）2000，2018，Oracle，MariaDBCorporationAbandothers。Typehelp；orhforhelp。Typectoclearthecurrentinputstatement。MySQL〔test〕MySQL〔test〕showdatabases；Databaseoceanbaseinformationschemamysqltest4rowsinset（0。002sec）MySQL〔test〕sourcebmsql。sqlQueryOK，1rowaffected（0。034sec）QueryOK，0rowsaffected（0。054sec）QueryOK，0rowsaffected（0。023sec）QueryOK，0rowsaffected（0。038sec）TablegroupnameTablenameDatabasenameoceanbaseNULLNULLtpccgroupNULLNULL2rowsinset（0。034sec）GrantsfortpccGRANTUSAGEON。TOtpccGRANTSELECTONoceanbase。TOtpccGRANTALLPRIVILEGESONtpccdb。TOtpcc3rowsinset（0。072sec）DatabasechangedQueryOK，0rowsaffected（0。145sec）QueryOK，0rowsaffected（0。040sec）QueryOK，0rowsaffected（0。078sec）QueryOK，0rowsaffected（0。158sec）QueryOK，0rowsaffected（0。209sec）QueryOK，0rowsaffected（0。213sec）QueryOK，0rowsaffected（0。312sec）QueryOK，0rowsaffected（0。370sec）QueryOK，0rowsaffected（0。242sec）QueryOK，0rowsaffected（0。234sec）QueryOK，0rowsaffected（0。177sec）QueryOK，0rowsaffected（0。183sec）MySQL〔tpccdb〕
　　1。1。10。启停命令obdclusterstopobdemoobdclusterstartobdemo