<\/span><\/h1>\n\n\n\nTo install Liquibase using the Red Hat\/CentOS package manager, follow the steps below:<\/p>\n\n\n\n
Import the Liquibase public key (as root):<\/p>\n\n\n\n
rpm --import https:\/\/repo.liquibase.com\/liquibase.asc<\/code><\/pre>\n\n\n\nInstall yum-config-manager:<\/p>\n\n\n\n
yum install -y yum-utils<\/code><\/pre>\n\n\n\nAdd the remote repo to yum (as root):<\/p>\n\n\n\n
yum-config-manager --add-repo https:\/\/repo.liquibase.com\/repo-liquibase-com.repo<\/code><\/pre>\n\n\n\nInstall Liquibase:<\/p>\n\n\n\n
yum install liquibase<\/code><\/pre>\n\n\n\n\u5b89\u88c5\u8fc7\u7a0b<\/p>\n\n\n\n
[root@gbase_rh7_003 ~]# rpm --import https:\/\/repo.liquibase.com\/liquibase.asc\r\n[root@gbase_rh7_003 ~]# yum install -y yum-utils\r\nLoaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager\r\nThis system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.\r\nbase | 3.6 kB 00:00:00\r\nextras | 2.9 kB 00:00:00\r\nupdates | 2.9 kB 00:00:00\r\nResolving Dependencies--> Running transaction check---> Package yum-utils.noarch 0:1.1.31-40.el7 will be updated---> Package yum-utils.noarch 0:1.1.31-54.el7_8 will be an update--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n=========================================================================================================================================\r\n Package Arch Version Repository Size=========================================================================================================================================\r\nUpdating:\r\n yum-utils noarch 1.1.31-54.el7_8 base 122 k\r\n\r\nTransaction Summary=========================================================================================================================================\r\nUpgrade 1 Package\r\n\r\nTotal download size: 122 k\r\nDownloading packages:No Presto metadata available for base\r\nyum-utils-1.1.31-54.el7_8.noarch.rpm | 122 kB 00:00:00Running transaction checkRunning transaction test\r\nTransaction test succeededRunning transaction\r\n Updating : yum-utils-1.1.31-54.el7_8.noarch 1\/2\r\n Cleanup : yum-utils-1.1.31-40.el7.noarch 2\/2\r\n Verifying : yum-utils-1.1.31-54.el7_8.noarch 1\/2\r\n Verifying : yum-utils-1.1.31-40.el7.noarch 2\/2\r\n\r\nUpdated:\r\n yum-utils.noarch 0:1.1.31-54.el7_8\r\n\r\nComplete!\r\n[root@gbase_rh7_003 ~]# yum-config-manager --add-repo https:\/\/repo.liquibase.com\/repo-liquibase-com.repo\r\nLoaded plugins: langpacks, product-id\r\nadding repo from: https:\/\/repo.liquibase.com\/repo-liquibase-com.repo\r\ngrabbing file https:\/\/repo.liquibase.com\/repo-liquibase-com.repo to \/etc\/yum.repos.d\/repo-liquibase-com.repo\r\nrepo saved to \/etc\/yum.repos.d\/repo-liquibase-com.repo\r\n[root@gbase_rh7_003 ~]# yum install liquibase\r\nLoaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager\r\nThis system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.\r\nrepo.liquibase.com | 3.0 kB 00:00:00\r\nrepo.liquibase.com\/primary_db | 37 kB 00:00:01\r\nResolving Dependencies--> Running transaction check---> Package liquibase.noarch 0:4.30.0-1 will be installed--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n=========================================================================================================================================\r\n Package Arch Version Repository Size=========================================================================================================================================\r\nInstalling:\r\n liquibase noarch 4.30.0-1 repo.liquibase.com 153 M\r\n\r\nTransaction Summary=========================================================================================================================================\r\nInstall 1 Package\r\n\r\nTotal download size: 153 M\r\nInstalled size: 169 MIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\nliquibase-4.30.0-1.noarch.rpm | 153 MB 00:10:13Running transaction checkRunning transaction test\r\nTransaction test succeededRunning transaction\r\n Installing : liquibase-4.30.0-1.noarch 1\/1\r\n Verifying : liquibase-4.30.0-1.noarch 1\/1\r\n\r\nInstalled:\r\n liquibase.noarch 0:4.30.0-1\r\n\r\nComplete!\r\n[root@gbase_rh7_003 ~]#\r\n[root@gbase_rh7_003 liquibasegbase]# liquibase --version\r\n####################################################\r\n## _ _ _ _ ##\r\n## | | (_) (_) | ##\r\n## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##\r\n## | | | |\/ _` | | | | | '_ \\ \/ _` \/ __|\/ _ \\ ##\r\n## | |___| | (_| | |_| | | |_) | (_| \\__ \\ __\/ ##\r\n## \\_____\/_|\\__, |\\__,_|_|_.__\/ \\__,_|___\/\\___| ##\r\n## | | ##\r\n## |_| ##\r\n## ##\r\n## Get documentation at docs.liquibase.com ##\r\n## Get certified courses at learn.liquibase.com ##\r\n## ##\r\n####################################################\r\nStarting Liquibase at 10:26:27 using Java 1.8.0_291 (version 4.30.0 #4943 built at 2024-10-31 17:00+0000)\r\nLiquibase Home: \/usr\/bin\r\nJava Home \/usr\/java\/jdk1.8.0_291-amd64\/jre (Version 1.8.0_291)\r\nLibraries:\r\n- internal\/extensions\/liquibase-commercial-bigquery.jar: Liquibase BigQuery Commercial Extension 4.30.0 By Liquibase\r\n- internal\/lib\/commons-collections4.jar: Apache Commons Collections 4.4.0 By The Apache Software Foundation\r\n- internal\/lib\/commons-io.jar: Apache Commons IO 2.17.0 By The Apache Software Foundation\r\n- internal\/lib\/commons-lang3.jar: Apache Commons Lang 3.17.0 By The Apache Software Foundation\r\n- internal\/lib\/commons-text.jar: Apache Commons Text 1.12.0 By The Apache Software Foundation\r\n- internal\/lib\/gbase-connector-java-8.3.81.53-build55.5.7-bin_min_mix.jar: General Data Technology' JDBC Driver for GBase 8.3.81.53 By General Data Technology Inc.\r\n- internal\/lib\/h2.jar: H2 Database Engine 2.2.224 By H2 Group\r\n- internal\/lib\/hsqldb.jar: HSQLDB 2.7.3 By The HSQL Development Group\r\n- internal\/lib\/jaxb-api.jar: jaxb-api 2.3.1 By Oracle Corporation\r\n- internal\/lib\/jaxb-core.jar: JAXB Core 4.0.5 By Eclipse Foundation\r\n- internal\/lib\/jaxb-runtime.jar: JAXB Runtime 4.0.5 By Eclipse Foundation\r\n- internal\/lib\/jaybird.jar: Jaybird 5.0.5.java8 (build: variant=jaybird tag=v5.0.5 date=202406141523) By Firebird project\r\n- internal\/lib\/jcc.jar: IBM JCC JDBC 4 Driver 1.4.0 By IBM\r\n- internal\/lib\/liquibase-commercial.jar: Commercial Liquibase Functionality 4.30.0 By Liquibase\r\n- internal\/lib\/mariadb-java-client.jar: mariadb-java-client 3.4.1 By mariadb.com\r\n- internal\/lib\/mssql-jdbc.jar: Microsoft JDBC Driver for SQL Server 12.8.1 By Microsoft Corporation\r\n- internal\/lib\/ojdbc8.jar: JDBC 19.24.0.0.0 By Oracle Corporation\r\n- internal\/lib\/opencsv.jar: opencsv 5.9.0\r\n- internal\/lib\/picocli.jar: picocli 4.7.6 By Remko Popma\r\n- internal\/lib\/postgresql.jar: PostgreSQL JDBC Driver 42.7.4 By PostgreSQL Global Development Group\r\n- internal\/lib\/slf4j-api.jar: SLF4J API Module 2.0.16 By SLF4J.ORG\r\n- internal\/lib\/slf4j-simple.jar: SLF4J Simple Provider 2.0.16 By SLF4J.ORG\r\n- internal\/lib\/snakeyaml.jar: SnakeYAML 2.3.0\r\n- internal\/lib\/snowflake-jdbc.jar: snowflake-jdbc 3.18.0\r\n- internal\/lib\/sqlite-jdbc.jar: SQLite JDBC 3.46.1.3\r\n\r\n\r\nLiquibase Version: 4.30.0\r\nLiquibase Open Source 4.30.0 by Liquibase\r\n[root@gbase_rh7_003 liquibasegbase]#<\/code><\/pre>\n\n\n\n<\/span>3. Ensure Java is installed<\/strong><\/strong><\/span><\/h1>\n\n\n\n[root@gbase_rh7_003 ~]# java -version<\/p>\n\n\n\n
java version \"1.8.0_291\"Java(TM) SE Runtime Environment (build 1.8.0_291-b10)<\/p>\n\n\n\n
Java HotSpot(TM) 64-Bit Server VM (build 25.291-b10, mixed mode)[root@gbase_rh7_003 ~]#<\/p>\n\n\n\n
Jdbc jar\u5305, \u7528mysql 5.0.7\u7b49\u8001\u7684\u7248\u672c,\u653e\u5230<\/p>\n\n\n\n
\/usr\/bin\/internal\/lib<\/p>\n\n\n\n
<\/span>4.\u00a0\u751f\u6210\u9879\u76ee<\/strong><\/span><\/h1>\n\n\n\n[root@gbase_rh7_003 gbase]# mkdir liquibasegbase\r\n[root@gbase_rh7_003 gbase]# cd liquibasegbase\/\r\n[root@gbase_rh7_003 liquibasegbase]# liquibase init project-new\r\n####################################################\r\n## _ _ _ _ ##\r\n## | | (_) (_) | ##\r\n## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##\r\n## | | | |\/ _` | | | | | '_ \\ \/ _` \/ __|\/ _ \\ ##\r\n## | |___| | (_| | |_| | | |_) | (_| \\__ \\ __\/ ##\r\n## \\_____\/_|\\__, |\\__,_|_|_.__\/ \\__,_|___\/\\___| ##\r\n## | | ##\r\n## |_| ##\r\n## ##\r\n## Get documentation at docs.liquibase.com ##\r\n## Get certified courses at learn.liquibase.com ##\r\n## ##\r\n####################################################\r\nStarting Liquibase at 10:55:55 using Java 1.8.0_291 (version 4.30.0 #4943 built at 2024-10-31 17:00+0000)\r\nLiquibase Version: 4.30.0\r\nLiquibase Open Source 4.30.0 by Liquibase\r\nSetup new liquibase.properties, flowfile, and sample changelog? Enter (Y)es with defaults, yes with (C)ustomization, or (N)o. [Y]:\r\nyes\r\nSetting up new Liquibase project in '\/home\/gbase\/liquibasegbase\/.'...\r\n\r\nCreated example changelog file '\/home\/gbase\/liquibasegbase\/example-changelog.sql'\r\nCreated example defaults file '\/home\/gbase\/liquibasegbase\/liquibase.properties'\r\nCreated example flow file '\/home\/gbase\/liquibasegbase\/liquibase.advanced.flowfile.yaml'\r\nCreated example flow file '\/home\/gbase\/liquibasegbase\/liquibase.flowvariables.yaml'\r\nCreated example flow file '\/home\/gbase\/liquibasegbase\/liquibase.endstage.flow'\r\nCreated example flow file '\/home\/gbase\/liquibasegbase\/liquibase.flowfile.yaml'\r\nCreated example checks package '\/home\/gbase\/liquibasegbase\/liquibase.checks-package.yaml'\r\n\r\nTo use the new project files make sure your database is active and accessible by opening a new terminal window to run \"liquibase init start-h2\", and then return to this terminal window to run \"liquibase update\" command.\r\nFor more details, visit the Getting Started Guide at https:\/\/docs.liquibase.com\/start\/home.html\r\nLiquibase command 'init project' was executed successfully.\r\n[root@gbase_rh7_003 liquibasegbase]# ll\r\ntotal 32\r\n-rw-r--r-- 1 root root 832 Dec 7 10:18 example-changelog.sql\r\n-rw-r--r-- 1 root root 4924 Dec 7 10:18 liquibase.advanced.flowfile.yaml\r\n-rw-r--r-- 1 root root 1916 Dec 7 10:18 liquibase.checks-package.yaml\r\n-rw-r--r-- 1 root root 985 Dec 7 10:18 liquibase.endstage.flow\r\n-rw-r--r-- 1 root root 1160 Dec 7 10:18 liquibase.flowfile.yaml\r\n-rw-r--r-- 1 root root 404 Dec 7 10:18 liquibase.flowvariables.yaml\r\n-rw-r--r-- 1 root root 2752 Dec 7 10:18 liquibase.properties\r\n[root@gbase_rh7_003 liquibasegbase]# <\/code><\/pre>\n\n\n\n<\/span>5. \u7f16\u8f91\u914d\u7f6e\u6587\u4ef6<\/strong><\/strong><\/span><\/h1>\n\n\n\n\u7f16\u8f91 liquibase.properties \u5c06\u76ee\u6807\u5e93\u7684JDBC\u53c2\u6570\u3002 \u5176\u4e2d\u9a71\u52a8\u7528mysql\uff0c\u7aef\u53e3\u6539\u62105258<\/p>\n\n\n\n
#### Enter the Target database 'url' information ####liquibase.command.url=jdbc:mysql:\/\/10.0.2.103:5258\/liquibase\r\n# Enter the username for your Target database.liquibase.command.username: root\r\n# Enter the password for your Target database.liquibase.command.password: XXXXXXX<\/code><\/pre>\n\n\n\n<\/span>6. \u64cd\u4f5c<\/strong><\/strong><\/span><\/h1>\n\n\n\n<\/span>6.1. <\/strong>Update<\/strong><\/strong><\/span><\/h2>\n\n\n\n<\/span>6.1.1.\u00a0\u589e\u52a0\u81ea\u5e26\u7684\u9ed8\u8ba4\u4f8b\u5b50\u4e2d\u7684\u8868<\/strong><\/span><\/h3>\n\n\n\n[root@gbase_rh7_003 liquibasegbase]# liquibase update\n####################################################\n## _ _ _ _ ##\n## | | (_) (_) | ##\n## | | _ __ _ _ _ _| |__ __ _ ___ ___ ##\n## | | | |\/ _` | | | | | '_ \\ \/ _` \/ __|\/ _ \\ ##\n## | |___| | (_| | |_| | | |_) | (_| \\__ \\ __\/ ##\n## \\_____\/_|\\__, |\\__,_|_|_.__\/ \\__,_|___\/\\___| ##\n## | | ##\n## |_| ##\n## ##\n## Get documentation at docs.liquibase.com ##\n## Get certified courses at learn.liquibase.com ##\n## ##\n####################################################\nStarting Liquibase at 10:55:55 using Java 1.8.0_291 (version 4.30.0 #4943 built at 2024-10-31 17:00+0000)\nLiquibase Version: 4.30.0\nLiquibase Open Source 4.30.0 by Liquibase\nRunning Changeset: example-changelog.sql::1::your.name\nRunning Changeset: example-changelog.sql::2::your.name\nRunning Changeset: example-changelog.sql::3::other.dev\r\nUPDATE SUMMARY\nRun: 3\nPreviously run: 0\nFiltered out: 0\r\n-------------------------------\nTotal change sets: 3\r\nLiquibase: Update has been successful. Rows affected: 3Liquibase command 'update' was executed successfully.\r\n[root@gbase_rh7_003 liquibasegbase]# \r\n\r\n\u767b\u5f55gbase\u67e5\u770b\u7ed3\u679c\r\nGBase client 9.5.3.28.18.r1_patch.3b726d68. Copyright (c) 2004-2024, GBase. All Rights Reserved.\r\n\r\ngbase> show databases;\n+--------------------+\n| Database |\n+--------------------+\n| information_schema |\n| performance_schema |\n| gbase |\n| gctmpdb |\n| gclusterdb |\n| liquibase |\n| test1db |\n| test_db |\n| testdb |\n+--------------------+\n9 rows in set (Elapsed: 00:00:00.00)\r\n\r\ngbase> use liquibase;\r\nQuery OK, 0 rows affected (Elapsed: 00:00:00.00)\r\n\r\ngbase> show tables;\n+-----------------------+\n| Tables_in_liquibase |\n+-----------------------+\n| company |\n| databasechangelog |\n| databasechangeloglock |\n| person |\n+-----------------------+\n4 rows in set (Elapsed: 00:00:00.00)<\/code><\/pre>\n\n\n\n<\/span>6.1.2. \u65b0\u589e\u4e00\u4e2aGBase\u5206\u5e03\u8868<\/strong><\/strong><\/span><\/h3>\n\n\n\n\u5c06\u914d\u7f6e\u6587\u4ef6\u91cc\u7684\u9ed8\u8ba4sql\u6539\u6210gbase.sql,\u7136\u540e\u65b0\u589e\u4e00\u4e2a\u5206\u5e03\u8868\u3002<\/p>\n\n\n\n
[root@gbase_rh7_003 liquibasegbase]# vi gbase.sql\n[root@gbase_rh7_003 liquibasegbase]# cat gbase.sql\n--liquibase formatted sql\n\n--changeset XXX:1 labels:\u5efa\u5206\u5e03\u8868 context:\u5efa\u6570\u5b57int\u7c7b\u578b\u7684\u5206\u5e03\u8868\n--comment: example comment\ncreate table gbase (\n id int,\n name varchar(50)\n)distributed by('id')\n--rollback DROP TABLE gbase;\n\n[root@gbase_rh7_003 liquibasegbase]# liquibase update\n\nRunning Changeset: gbase.sql::1::XXX\n\nUPDATE SUMMARY\nRun: 1\nPreviously run: 0\nFiltered out: 0\n-------------------------------\nTotal change sets: 1\n\nLiquibase: Update has been successful. Rows affected: 1\nLiquibase command 'update' was executed successfully.\n[root@gbase_rh7_003 liquibasegbase]#\n\n\u67e5\u770b\u5206\u5e03\u8868\u6548\u679c\ngbase> show tables;\n+-----------------------+\n| Tables_in_liquibase |\n+-----------------------+\n| company |\n| databasechangelog |\n| databasechangeloglock |\n| gbase |\n| person |\n+-----------------------+\n5 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>6.1.3. \u4e00\u6b21\u591a\u4e2a\u53d8\u52a8\u4f8b\u5b50<\/strong><\/strong><\/span><\/h3>\n\n\n\n\u6807\u7b7e\u76f8\u540c\u7684\uff0c\u4e0d\u4f1a\u66f4\u65b0\uff0c\u53ea\u6709\u65b0\u589e\u7684\u624d\u4f1a\u53d8\u52a8\u3002\u9002\u5408\u540c\u4e00\u4e2a\u53d8\u52a8\u6587\u4ef6\uff0c\u505a\u4e86\u591a\u6b21\u53d8\u52a8\u7684\u60c5\u51b5\u3002<\/p>\n\n\n\n
[root@gbase_rh7_003 liquibasegbase]# cat gbase.sql--liquibase formatted sql\r\n--changeset XXX:2 labels:\u5efa\u5206\u5e03\u88682 context:\u5efa\u6570\u5b57int\u7c7b\u578b\u7684\u5206\u5e03\u88682--comment: \u5206\u5e03\u88682create table gbase2 (\r\n id int,\r\n name varchar(50)\r\n)distributed by('id')--rollback DROP TABLE gbase2;\r\n--changeset XXX:3 labels:\u5efa\u590d\u5236\u88681 context:\u5efa\u590d\u5236\u88681--comment: \u590d\u5236\u88681create table gbaserep (\r\n id int,\r\n name varchar(50)\r\n)replicated--rollback DROP TABLE gbaserep;\r\n\r\n[root@gbase_rh7_003 liquibasegbase]#<\/code><\/pre>\n\n\n\n<\/span>6.2. <\/strong>Tag<\/strong>