???????? ??MySQL??汾??????????? ?????? ?? ????????JIRA????????????????????????XML????????????????е?????????μ?????? ??????????????MySQL?????????Confluence??JIRA??????? Confluence MySQL?????? ?????????MySQL???????????Confluence???JIRA?????Confluence????JIRA??????????????MySQL?????Confluence????????????????????JIRA?? ????????JIRA????????????????Setup Wizard?? 1.??????????MySQL????? ??????JIRA??????????????????????????磺 jiradbuser ??
????mysql> CREATE USER '< USERNAME>'@'< JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '< PASSWORD>'; ?????????????? jiradb ?????洢JIRA???????????????????UTF8???????????MySQL????????????????????
????CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin; ?????????????????????????????д??????????????????￡?
????GRANT SELECT??INSERT??UPDATE??DELETE??CREATE??DROP??ALTER??INDEX on < JIRADB>.* TO
????'< USERNAME>'@'< JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
????flush privileges;
????Tip:
??????????????????????????JIRA DB????????DB???????????????????
????SHOW GRANTS FOR < USERNAME>@< JIRA_SERVER_HOSTNAME>; 2.??MySQL JDBC?????????????÷?????
????????? ????JIRA???????????????MySQL?????? (Connector/J JDBC driver v5.1)?????????????JIRA???????????????????????????????????
??????MySQL JDBC????????????????÷?????
???????MySQL???????? ????? ???JIRA ???????????MySQL??????Connector/J JDBC driver v5.1??
????????????'Platform Independent'???????.tar.gz??.zip???????浵??????????jar?????磺mysql-connector-java-5.x.x-bin.jar???? ????? ????JIRA???????????????MySQL???? (JDBC Connector/J 5.1)???????????JIRA?????????????????????洢??<JIRA?????>/lib/ ???? ????MySQL JDBC????????<JIRA?????>/lib/ ????????JIRA????????windows installer???JIRA?????????????Windows installer???????????Setup Wizard??????????? ????JIRA/JIRA???????? ?????????JIRA????????????????????????????????JIRA??????Setup Wizard?? ??? ?????????MySQL Connector/J???????????????????Resin JDBC driver for MySQL?????? 3.????JIRA????????????MySQL?????
????????????JIRA??????????MySQL???????????
???????JIRA????? ??????????JIRA WAR??-???????????JIRA?????????????????????y??????浽JIRA??????dbconfig.xml????? ???JIRA???ù??? ??????????JIRA WAR??-???????????JIRA???????????y??????浽JIRA??????dbconfig.xml????? ??????? -??е?????JIRA WAR?????????????????????????JIRA????????????????????JIRA???????dbconfig.xml?????
??????????÷??????????
????JIRA setup wizard ????????????????JIRA???JIRA???????????? ????????'Configure Language and Database'???? Database Connection ? My own database ?? ???? Database Type ? MySQL ?? ????????????????????????????д??Ρ? ????????????檔 JIRA configuration tool ????????????JIRA???ù???? Windows: ?????????????????JIRA???????bin???????config.bat?? linux/Unix: ?????????????JIRA???????bin???????config.sh??
???????????????????????? ???? ?????????? ?????? Database ??????? Database type ? MySQL ?? ????????????????????????????д??Ρ? ????????????檔 ????JIRA?? Manually ???JIRA?????????μ?dbconfig.xml????? ????????????????????????????XML??????????￡????????????????? ?????????????????????????????????????????????????'amp;'???????'&'????? ???<database-type/>????????????????????磺mysql??????????????????????????JIRA????????????????????????????????????????μ??????????????????????н???? ?????????????JIRA??
???????????????Σ?
????setup wizard/configuration tool dbconfig.xml Description Hostname λ??< url>???????????????????????
????<url>jdbc:mysql:// dbserver :3306/jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB< /url> ???MySQL????????????????IP????? Port λ??< url>???????????????????????
????<url>jdbc:mysql://dbserver: 3306 /jiradb?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB < /url> MySQL???????????????TCP/IP??????????????????????? Database λ??< ;url>???????????????????????
????<url>jdbc:mysql://dbserver:3306/ jiradb ?useUnicode=true&characterEncoding=UTF8&sessionVariables=storage_engine=InnoDB < /url> MySQL?????JIRA?????????????????????????????????????????? Username λ??< username>?????????????????????
????< username> jiradbuser < /username> JIRA????????MySQL??????????????????????????????? Password λ??< password>?????????????????????
????< password> jiradbuser < /password> ??????MySQL?????????????????????
????dbconfig.xml??????

????4.???JIRA
????????JIRA?????MySQL????????ú??????????????JIRA??
??????????????JIRA??'recommended'?????????????????????????????? ?????????JIRA WAR????????????2???????÷???????Web??ó??? ?????????? ????????????????: ????е?????????????????? -?????MySQL??????????????localhost???????JIRA???????????????????????????????????127.0.0.1?????????????????????????????????????????????????????????????JIRA?JDBC??????д?????????? ?????? -???????????κ?????????MySQL????????????????????????????JRA-15731??????? Surviving Connection Closures ????????? JIRA 3.13 or above?? version 5.5.25 or higher of Tomcat 5?? version 6.0.13 or higher of Tomcat 6?? ???????????????? -JIRA??????????????????е????????????ο? ????????????? ?? ???InnoDB?洢???? - ???MySQL Server?汾??5.5?????????洢????MyISAM?????JIRA???????????????MySQL Server5.5?????汾??????????????JIRA?е?????????????????????????sessionVariables=storage_engine=InnoDB???????????????д??JIRA??MySQL???????????InnoDB?洢???棬?????JIRA?????'database transactions'?? ????????? -???JIRA??MySQL???'READ-COMMITTED'???????????????????е????????????????MySQL????????????????????????MySQL??????????????'row-based'????????JIRA?д?????????????????????? ???MySQL?????????????????????? ?? 4?????? -???JIRA?????MySQL???4????????