{"id":28818,"date":"2025-10-15T02:52:12","date_gmt":"2025-10-15T02:52:12","guid":{"rendered":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/?page_id=28818"},"modified":"2026-03-13T16:05:09","modified_gmt":"2026-03-13T07:05:09","slug":"cassandra-migration-to-mysql-for-linux","status":"publish","type":"page","link":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/server-guide\/cassandra-deprecation\/cassandra-migration-to-mysql-for-linux\/","title":{"rendered":"TestRail Server Cassandra \u304b\u3089MySQL Server\u3078\u306e\u30c7\u30fc\u30bf\u79fb\u884c\uff08Linux \u7248)"},"content":{"rendered":"<p>TestRail Server 9.4 \u304b\u3089\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308b\u5834\u6240\u306f Cassandra \u304b\u3089 Microsoft SQL Server \u307e\u305f\u306f MySQL \u306b\u79fb\u884c\u3057\u307e\u3059\u30029.4 \u306b\u306f\u3001\u65e2\u5b58\u306e\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092 Cassandra \u304b\u3089 MySQL \u306b\u30b3\u30d4\u30fc\u3067\u304d\u308b\u79fb\u884c\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u5143\u306e Cassandra \u30c7\u30fc\u30bf\u306f\u305d\u306e\u307e\u307e\u6b8b\u308a\u307e\u3059\u3002<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>\u203b\u672c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u306e\u64cd\u4f5c\u306f TestRail 7.5 \u4ee5\u964d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089 TestRail 9.4 \u306b\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3057\u305f\u5834\u5408\u3060\u3051\u884c\u3044\u307e\u3059\u3002<\/strong><\/span><\/p>\n<p>\u79fb\u884c\u306f\u3044\u3064\u3067\u3082\u90fd\u5408\u306e\u3088\u3044\u3068\u304d\u306b\u5b9f\u884c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u6b21\u306e\u30ea\u30ea\u30fc\u30b9 (TestRail 9.5) \u304b\u3089\u306f\u3001\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u306e\u6761\u4ef6\u306b\u306a\u308a\u307e\u3059\u3002\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u3001\u79fb\u884c\u304c\u5b8c\u4e86\u3059\u308b\u307e\u3067\u3001TestRail 9.5 \u304a\u3088\u3073\u4ee5\u964d\u306e\u3059\u3079\u3066\u306e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n<h2>\u6e96\u5099<\/h2>\n<h3>Composer \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p><a href=\"https:\/\/getcomposer.org\/\" target=\"_blank\" rel=\"noopener\">Composer<\/a> \u3092\u5229\u7528\u3057\u3066\u30c7\u30fc\u30bf\u79fb\u884c\u7528\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u306b\u5fc5\u8981\u306a\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<\/p>\n<p>TestRail \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u74b0\u5883\u306b\u5408\u308f\u305b\u3066 <a href=\"https:\/\/getcomposer.org\/download\/\" target=\"_blank\" rel=\"noopener\">Composer \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/a>\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h3 class=\"\">Apache Web \u30b5\u30fc\u30d0\u30fc\u3068\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u30bf\u30b9\u30af\u306e\u505c\u6b62<\/h3>\n<p>Apache Web \u30b5\u30fc\u30d0\u30fc\u304a\u3088\u3073<a href=\"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/server-guide\/installation\/activating-the-background-task\/\" target=\"_blank\" rel=\"noopener\">\u30d0\u30c3\u30af\u30b0\u30e9\u30a6\u30f3\u30c9\u30bf\u30b9\u30af<\/a>\u3092\u505c\u6b62\u3057\u307e\u3059\u3002<\/p>\n<h3 class=\"ip-location-block-dropup ip-location-block-dropdown\">\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u306e\u53d6\u5f97<\/h3>\n<p><a href=\"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/server-guide\/server-administration\/creating-backup\/\" target=\"_blank\" rel=\"noopener\">TestRail \u306e\u30d5\u30a1\u30a4\u30eb\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u4f5c\u6210<\/a>\u3057\u307e\u3059\u3002<\/p>\n<p>\u203bv9.4.1 \u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u4f5c\u696d\u524d\u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u5f97\u3057\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001v9.4.1\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u5f8c\u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u518d\u53d6\u5f97\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<h2><span id=\"i\">\u30c7\u30fc\u30bf\u79fb\u884c<\/span><\/h2>\n<p>\u79fb\u884c\u306b\u9032\u3080\u5834\u5408\u3001\u624b\u9806\u306f\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<p><!-- START ordered list with colored numbers --><\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol class=\"list-colored\">\n<li>\u30b7\u30a7\u30eb (\u30bf\u30fc\u30df\u30ca\u30eb) \u3092\u958b\u304d\u3001&lt;TestRail\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea&gt;\\deprecation_script \u30d5\u30a9\u30eb\u30c0\u30fc\u306b\u79fb\u52d5\u3057\u307e\u3059\u3002<\/li>\n<li>\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001Composer \u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3001\u6b63\u3057\u304f\u52d5\u4f5c\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">composer -V<\/pre>\n<p>Composer \u304c\u8d77\u52d5\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001 <a href=\"https:\/\/getcomposer.org\/download\/\" target=\"_blank\" rel=\"noopener\">\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8<\/a> \u3092\u53c2\u7167\u3057\u3066\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u65b9\u6cd5\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<li>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u5fc5\u8981\u306a\u4f9d\u5b58\u30d1\u30c3\u30b1\u30fc\u30b8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">composer update<\/pre>\n<\/li>\n<li>MySQL \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">mysql -h &lt;host&gt; -u testrail -p<\/pre>\n<\/li>\n<li>Cassandra \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">cqlsh &lt;host&gt; 9042 -u &lt;user&gt; -p &lt;password&gt;<\/pre>\n<\/li>\n<li>Apache \u8d77\u52d5\u30e6\u30fc\u30b6\u30fc\u3067\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u30c9\u30e9\u30a4\u30e9\u30f3\u3092\u5b9f\u884c\u3057\u3066\u3001\u79fb\u884c\u30b9\u30af\u30ea\u30d7\u30c8\u304c\u52d5\u4f5c\u3059\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002(\u30c9\u30e9\u30a4\u30e9\u30f3\u3067\u306f\u5b9f\u969b\u306b\u79fb\u884c\u51e6\u7406\u306f\u884c\u308f\u308c\u307e\u305b\u3093\u3002)\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">sudo -u www-data php TestRailSqlToCassandraMigration.php -d2 -r -m\"driver=mysql;host=&lt;host&gt;;port=&lt;port&gt;;database=&lt;database&gt;;user=&lt;user&gt;;password=&lt;password&gt;\" -s\"host=&lt;host&gt;;port=9042;keyspace=&lt;keyspace&gt;;user=&lt;user&gt;;password=&lt;password&gt;\" -v2 -b --attachments=\"&lt;attachments location&gt;\"<\/pre>\n<\/li>\n<li>config.ini \u30d5\u30a1\u30a4\u30eb\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3059\u308b\u305f\u3081\u306e\u8a8d\u8a3c\u60c5\u5831\u3092\u5165\u529b\u3057\u307e\u3059 (\u30d1\u30b9\u30ef\u30fc\u30c9\u306b\u7279\u6b8a\u6587\u5b57\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u4e8c\u91cd\u5f15\u7528\u7b26\u3067\u56f2\u307f\u307e\u3059)\u3002\n<ul class=\"list-colored\">\n<li>config.ini \u30d5\u30a1\u30a4\u30eb\u306b `<strong>driver = mysql<\/strong>` \u306e\u8a2d\u5b9a\u304c\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/li>\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(mysql \u304a\u3088\u3073 cassandra) \u306e\u8a8d\u8a3c\u60c5\u5831\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u74b0\u5883\u306b\u5408\u308f\u305b\u3066\u5909\u66f4\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n<\/li>\n<li>\u524d\u306e\u30b9\u30c6\u30c3\u30d7\u304c\u3059\u3079\u3066\u6b63\u5e38\u306b\u5b8c\u4e86\u3057\u305f\u3089\u3001Apache \u8d77\u52d5\u30e6\u30fc\u30b6\u30fc\u3067\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">sudo -u www-data php TestRailCassandraDeprecation.php<\/pre>\n<p>\u30b3\u30de\u30f3\u30c9\u5b9f\u884c\u5f8c\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u51fa\u529b\u3055\u308c\u308b\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3066\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">Welcome! We are about to start the Cassandra deprecation process.\n\nPlease note that after deprecating Cassandra, our Team won't support downgrades to versions of TestRail with Cassandra.\nDo you still want to continue?\n\nPlease type YES or NO.\nyes\nPlease confirm the source and target databases:\nSOURCE:\n[Cassandra Information]\nHost: cassandra\nKeyspace: testrail\nUser: cassandra\nPort: 9042\n\nTARGET:\n[SQL Information]\nHost: db\nDatabase Name: testrail\nUser: testrail\nPort: 3306\nDriver: mysql\n\nDo you confirm? Please type YES or NO.\nyes\n\nThe migration process may take a long time. So that we can notify you once it is completed,\nWould you like to configure an SMTP server before proceeding?\nno\n\nAll ready to start Cassandra deprecation.\nThe first step will be to migrate to the target database.\nThis will be done in the background and may take a long time.\n\nDo you want to start? Please type YES or NO.\nyes<\/pre>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><!-- END ordered list with colored numbers --><\/p>\n<h2>Apache\u00a0Cassandra\u00a0\u306e\u505c\u6b62<\/h2>\n<p>Cassandra\u00a0\u304b\u3089\u00a0MySQL\u00a0\u3078\u306e\u79fb\u884c\u304c\u5b8c\u4e86\u3057\u305f\u3089\u00a0Cassandra\u00a0\u3092\u505c\u6b62\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u53e4\u3044\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/h2>\n<p>TestRailCassandraDeprecation.php\u00a0\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u5b9f\u884c\u5f8c\u3001\u53e4\u3044\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092\u524a\u9664\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u8a73\u7d30\u306f <a href=\"\/server-guide\/cassandra-deprecation\/cleaning-up-old-attachment-files\/\" target=\"_blank\" rel=\"noopener\">\u53e4\u3044\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664<\/a> \u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TestRail Server 9.4 \u304b\u3089\u3001\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u304c\u683c\u7d0d\u3055\u308c\u308b\u5834\u6240\u306f Cassandra \u304b\u3089 Microsoft SQL Server \u307e\u305f\u306f MySQL \u306b\u79fb\u884c\u3057\u307e\u3059\u30029.4 \u306b\u306f\u3001\u65e2\u5b58\u306e\u6dfb\u4ed8\u30d5\u30a1\u30a4\u30eb\u3092 Ca [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":30914,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-28818","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/comments?post=28818"}],"version-history":[{"count":42,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28818\/revisions"}],"predecessor-version":[{"id":32118,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/28818\/revisions\/32118"}],"up":[{"embeddable":true,"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/pages\/30914"}],"wp:attachment":[{"href":"https:\/\/docs.testrail.techmatrix.jp\/testrail\/docs\/9\/wp-json\/wp\/v2\/media?parent=28818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}