Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

在我们安装Atlassian产品之前,我们需要做好数据库准备。

以下是各个产品对数据的参数配置要求

JIRA数据库

MySql

Code Block
languagesql
title数据库设置
linenumberstrue
[mysqld]
...
character-set-server=utf8mb4
collation-server=utf8mb4_bin

default-storage-engine=INNODB
innodb_default_row_format=DYNAMIC
innodb_log_file_size=2G
max_allowed_packet=256M

#not set sql_mode
#sql_mode = NO_AUTO_VALUE_ON_ZERO
max_connections = 500

log_bin_trust_function_creators = 1 
Panel
title本页内容

Table of Contents

Code Block
languagesql
title创建库及授权
linenumberstrue
CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb.* TO 'jirauser'@'%' IDENTIFIED BY 'PASSWORD';
flush privileges;

PostgreSQL

Code Block
languagesql
linenumberstrue
#创建数据库
CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
#为数据库用户进行授权
GRANT ALL PRIVILEGES ON DATABASE jiradb  TO jirauser


Oracle

Code Block
languagesql
linenumberstrue
-- 字符编码 AL32UTF8
#创建表空间
create tablespace jiradb datafile 'jiradb' size 100m;
create tablespace data_test datafile 'd:\oracle\oradata\data_1.dbf' size 200M;
create tablespace idx_test datafile 'd:\oracle\oradata\idx_1.dbf' size 200M;
#创建用户
create user jira identified by jira default tablespace jiradb quota unlimited on jiradb;
#对用户进行授权
grant connect to jira;
grant create table to jira;
grant create sequence to jira;
grant create trigger to jira;

Confluence数据库

MySql

Code Block
languagesql
title数据库设置
linenumberstrue
[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

#not set sql_mode
#sql_mode = NO_AUTO_VALUE_ON_ZERO

transaction-isolation=READ-COMMITTED
binlog_format=row
max_connections = 250

log_bin_trust_function_creators = 1 
Code Block
languagesql
title创建库及授权
linenumberstrue
CREATE DATABASE confluencedb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON confluencedb.* TO 'confluenceuser'@'%' IDENTIFIED BY '<password>';
flush privileges;

PostgreSQL

Code Block
languagesql
linenumberstrue
#创建数据库
CREATE DATABASE confluencedb WITH ENCODING 'UTF-8' LC_COLLATE 'UTF-8' LC_CTYPE 'UTF-8' TEMPLATE template0;
#为数据库用户进行授权
GRANT ALL PRIVILEGES ON DATABASE confluencedb TO confluenceuser

ORACLE

Code Block
languagesql
titleSQL
linenumberstrue
--字符编码:AL32UTF8
create user confluenceuser identified by 'password' default tablespace confluencedb quota unlimited on confluencedb;
--- 授权
grant connect to confluenceuser;
grant resource to confluenceuser;
grant create table to confluenceuser;
grant create sequence to confluenceuser;
grant create trigger to confluenceuser;


BitBucket数据库

Bitbucket Server在MySQL5.6.16之前的版本中并不是全部兼容的(并且不建议使用Mysql)

BitBucket Datacenter版本不支持Mysql

PostgreSQL

Code Block
languagesql
linenumberstrue
CREATE ROLE bitbucketuser WITH LOGIN PASSWORD '<password>' VALID UNTIL 'infinity';
CREATE DATABASE bitbucket WITH ENCODING='UTF8' OWNER=bitbucketuser CONNECTION LIMIT=-1;


ORACLE

Code Block
languagesql
collapsetrue
CREATE USER <user> IDENTIFIED BY <password> DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE to <user>;

SQLServer

Code Block
languagesql
linenumberstrue
CREATE DATABASE bitbucket
USE bitbucket
ALTER DATABASE bitbucket SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE bitbucket SET READ_COMMITTED_SNAPSHOT ON
ALTER DATABASE bitbucket COLLATE SQL_Latin1_General_CP1_CS_AS
SET NOCOUNT OFF
USE master
CREATE LOGIN bitbucketuser WITH PASSWORD= 'password', DEFAULT_DATABASE=bitbucket,CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
ALTER AUTHORIZATION ON DATABASE::bitbucket TO bitbucketuser

MySql

Code Block
languagesql
title创建库及授权
linenumberstrue
CREATE DATABASE bitbucketdb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON bitbucketdb.* TO 'bitbucketuser'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES

Crowd数据库

MySql

Code Block
languagesql
title数据库设置
linenumberstrue
[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

#not set sql_mode
#sql_mode = NO_AUTO_VALUE_ON_ZERO

transaction-isolation=READ-COMMITTED
max_connections = 250
log_bin_trust_function_creators = 1 
Code Block
languagesql
title创建库及授权
linenumberstrue
create database crowddb character set utf8 collate utf8_bin;
GRANT ALL PRIVILEGES ON crowddb.* TO 'crowduser'@'%' IDENTIFIED BY 'crowdpass';

Bamboo数据库

MySql

Code Block
languagesql
title数据库设置
linenumberstrue
[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

transaction-isolation=READ-COMMITTED
lower_case_table_names=1
max_connections = 250
log_bin_trust_function_creators = 1 
Code Block
languagesql
title创建库及授权
linenumberstrue
CREATE DATABASE bamboodb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT ALL PRIVILEGES ON bamboodb.* TO 'bamboouser'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

Crucible\FishEye 数据库

MySql

Code Block
languagesql
title数据库设置
linenumberstrue
[mysqld]
...
character-set-server=utf8
collation-server=utf8_bin

default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB

transaction-isolation=READ-COMMITTED
lower_case_table_names=1
max_connections = 250
log_bin_trust_function_creators = 1 
Code Block
languagesql
title创建库及授权
linenumberstrue
 SET GLOBAL storage_engine = 'InnoDB';
 CREATE DATABASE fisheye CHARACTER SET utf8 COLLATE utf8_bin;
 CREATE DATABASE crucible CHARACTER SET utf8 COLLATE utf8_bin;
 GRANT ALL PRIVILEGES ON fisheye.* TO 'fisheyeuser'@'%' IDENTIFIED BY 'password';
 GRANT ALL PRIVILEGES ON crucible.* TO 'crucibleuser'@'%' IDENTIFIED BY 'password';
 FLUSH PRIVILEGES;

创建用户

Code Block
languagesql
linenumberstrue
CREATE USER 'atlassian'@'%'  IDENTIFIED BY mysql_native_password 'atlassian';

建议

每一个应用创建一个新用户

不要使用root账户

Mysql数据驱动