Shulou(Shulou.com)06/01 Report--

Introduction

JIRA is a project and transaction tracking tool produced by Atlassian, which is widely used in defect tracking, customer service, requirements collection, process approval, task tracking, project tracking and agile management. Many enterprises and Internet companies are using Jira as an internal process management system for team collaboration and problem list management.

The background database of JIRA can choose to use embedded database or professional database such as MySQL/PGSQL. Generally speaking, most enterprises choose MySQL as the underlying data storage. However, with the continuous accumulation of problem work orders, the amount of data supported by MySQL may soon reach a bottleneck for larger enterprises. Users can choose to replace MySQL's default InnoDB engine with SequoiaDB distributed database to achieve elastic horizontal expansion while maintaining complete compatibility with Jira applications.

JIRA is a popular management system based on Java architecture. Because Atlassian provides defect tracking services for many open source projects free of charge, in the open source field, its awareness is much higher than other products, and it is easier to use. At the same time, open source is another feature, when users buy their software, they also purchase the source code to facilitate secondary development. JIRA is excellent in terms of comprehensive features, friendly interface, simple installation, flexible configuration, rights management and scalability.

By reading this article, you can learn how to use the MySQL instance of the SequoiaDB sequoia database to seamlessly replace the standard MySQL database. SequoiaDB Giant Sequoia database allows users to migrate background MySQL databases to existing applications directly without changing a single line of code.

By using the SequoiaDB Giant Sequoia database, users can get:

L horizontal elastic expansion

L MySQL is 100% fully compatible

L excellent trading performance

Install SequoiaDB

In this paper, Linux Ubuntu Server 18.10 is used as the server, and the version of SequoiaDB sequoia database is 3.2.1.

By default, this tutorial uses the sudo username and password as "sequoiadb:sequoiadb" and the default home path as / home/sequoiadb.

For users using other versions of Linux, such as CentOS, the process described in this article may be slightly different and needs to be adjusted according to the actual situation.

Users who download the SequoiaDB standard virtual machine template can skip this installation and deployment step directly.

1) download and install SequoiaDB Giant Sequoia Database

$wget http://cdn.sequoiadb.com/images/sequoiadb/x86_64/sequoiadb-3.2.1-linux_x86_64.tar.gz

$tar-zxvf sequoiadb-3.2.1-linux_x86_64.tar.gz

$cd sequoiadb-3.2.1/

$sudo. / setup.sh

After that, enter all the time to confirm the default parameters.

2) use database instance users to create default instances

$sudo su sdbadmin

$/ opt/sequoiadb/tools/deploy/quickDeploy.sh

$exit

Install JIRA

This tutorial uses JIRA 8.2.1.

1) users can log in to JIRA's official website https://www.atlassian.com/software/jira/download to download the installation package, or download it directly through wget.

$wget https://www.atlassian.com/software/jira/downloads/binary/atlassian-jira-software-8.2.1-x64.bin

Note: the official installation documentation for JIRA is located at

Https://confluence.atlassian.com/adminjiraserver/installing-jira-applications-on-linux-938846841.html

2) execute the installation package

$chmod 755 atlassian-jira-software-8.2.1-x64.bin

$sudo. / atlassian-jira-software-8.2.1-x64.bin

3) by default, the MySQL JDBC driver is not available in the beta version of JIRA, so you need to download the driver package manually. Since the current version of JIRA does not support drivers for MySQL 8, you need to download the JDBC installation package for MySQL 5.1.x.

Or download directly through wget

$wget https://downloads.mysql.com/archives/get/file/mysql-connector-java-5.1.46.tar.gz

$tar-zxvf mysql-connector-java-5.1.46.tar.gz

4) copy the JDBC driver to the lib directory of JIRA and restart JIRA

$sudo cp mysql-connector-java-5.1.46/mysql-connector-java-5.1.46.jar / opt/atlassian/jira/lib/

$sudo / opt/atlassian/jira/bin/shutdown.sh

$sudo / opt/atlassian/jira/bin/startup.sh

5) enable SequoiaDB Giant Sequoia database transaction function and set the default isolation level RC

$sudo su sdbadmin

$/ opt/sequoiadb/bin/sdb

> db = new Sdb ()

> db.updateConf ({transactionon: true, transisolation: 1})

> quit

$/ opt/sequoiadb/bin/sdbstop

$/ opt/sequoiadb/bin/sdbstart

6) create a database

$/ opt/sequoiasql/mysql/bin/mysql-S / opt/sequoiasql/mysql/database/3306/mysqld.sock-u root

Mysql > create user 'sequoiadb'@'localhost' identified by' sequoiadb'

Mysql > create database jira

Mysql > grant all on jira.* to 'sequoiadb'@'localhost'

Mysql > grant all privileges on *. * to 'sequoiadb'@'%' identified by' sequoiadb' with grant option

Mysql > exit

$exit

Configure JIRA

1) Log in to port 8080 of the server's IP address using a browser, and select "I'll set it up myself"

2) Select "My Own Database" on the database settings page, and enter the server IP address, jira database name, and sequoiadb:sequoiadb as the user name and password.

3) Click Test Connection to confirm that the database connection is correct

4) Click Next to create the database, and follow the navigation to enter the registration page

5) as a test account, users can click "generate a Jira trial license" and register for a test authorization account on the official website.

6) paste the authorization code under the installation interface and click Next, and the user name password is set to the default sequoiadb:sequoiadb

7) complete the installation settings and create a project for the default sequoiadb

Switch database to SequoiaDB

In the installation and deployment program for JIRA, InnoDB is specified by default as the storage engine for all tables. So then the user can switch the table of InnoDB to SequoiaDB through mydumper and myloader.

1) stop JIRA

$sudo / opt/atlassian/jira/bin/shutdown.sh

2) download mydumper

$wget https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper_0.9.5-2.xenial_amd64.deb

$sudo dpkg-I mydumper_0.9.5-2.xenial_amd64.deb

3) Export all tables in jira database

$sudo su-sdbadmin

$mkdir temp

$mydumper-h 10.211.55.14-P 3306-u sequoiadb-p sequoiadb-t 16-F 64-B jira-o. / temp

4) replace all InnoDB tables with SequoiaDB engines

$sed-I "s/InnoDB/SequoiaDB/g" `grep-R "InnoDB"-rl. / temp`

5) recreate the jira library and import data using myloader

$/ opt/sequoiasql/mysql/bin/mysql-S / opt/sequoiasql/mysql/database/3306/mysqld.sock-u root

Mysql > drop database jira

Mysql > create database jira

Mysql > grant all on jira.* to 'sequoiadb'@'localhost'

Mysql > exit

$myloader-h 10.211.55.14-u sequoiadb-p sequoiadb-P 3306-t 32-d. / temp

$exit

6) restart the JIRA service

$sudo / opt/atlassian/jira/bin/startup.sh

7) log in to the browser again, and now all the data in the JIRA backend has been migrated from MySQL to SequoiaDB

Conclusion

As a distributed database, SequoiaDB Giant Sequoia Database provides mechanisms including structured SQL, unstructured file system and object storage.

The MySQL instance created by SequoiaDB can provide SQL and DDL capabilities that are fully compatible with standard MySQL, and users can access the distributed table structure seamlessly and transparently without adjusting DDL or SQL.

This article shows readers how to migrate seamlessly with standard MySQL through the MySQL instance of SequoiaDB. By using SequoiaDB Giant Sequoia database, users can achieve nearly unlimited elastic scalability on the basis of meeting the standard ACID and MySQL protocols.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.