技术标签： PG学习笔记 timescaledb timescale 源码安装
因为postgresql是源码安装的，所以timescaledb也得源码安装。
timescaledb 0.12.1版本，解压后如下
[root@server4 timescaledb-0.12.1]# ls
bootstrap build CMakeLists.txt docs NOTICE scripts src timescaledb.control.in
bootstrap.bat CHANGELOG.md CONTRIBUTING.md LICENSE README.md sql test version.config
[root@server4 timescaledb-0.12.1]# pwd
/root/timescaledb-0.12.1首先安装cmake(如果已有不需要安装), 然后执行./bootstrap.
[root@server4 timescaledb-0.12.1]# ./bootstrap
Build system already initialized in ./build
Do you want to remove it (this is IMMEDIATE and PERMANENT), y/n? y
-- The C compiler identification is GNU 4.8.3
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- TimescaleDB version 0.12.1. Can be updated from version 0.12.0
-- Build type is Release
-- Install method is 'source'
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success
-- Using compiler GNU
CMake Error at CMakeLists.txt:141 (message):
Unable to find 'pg_config'
提示找不到pg_config.
这个pg_config为postgresql安装好后的一个可执行文件，执行它可以得到postgresql的相关配置和路径
[root@server4 timescaledb-0.12.1]# cd /appdev/pgsql/bin/
[root@server4 bin]# ./pg_config
BINDIR = /appdev/pgsql/bin
DOCDIR = /appdev/pgsql/share/doc
HTMLDIR = /appdev/pgsql/share/doc
INCLUDEDIR = /appdev/pgsql/include
PKGINCLUDEDIR = /appdev/pgsql/include
INCLUDEDIR-SERVER = /appdev/pgsql/include/server
LIBDIR = /appdev/pgsql/lib
PKGLIBDIR = /appdev/pgsql/lib
LOCALEDIR = /appdev/pgsql/share/locale
MANDIR = /appdev/pgsql/share/man
SHAREDIR = /appdev/pgsql/share
SYSCONFDIR = /appdev/pgsql/etc
PGXS = /appdev/pgsql/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/appdev/pgsql' '--without-readline'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/appdev/pgsql/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lz -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 10.5将pg_config路径添加进~/.bash_profile
[root@server4 bin]# cat ~/.bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin:/appdev/pgsql/bin再次执行./bootstrap
[root@server4 bin]# source ~/.bash_profile
[root@server4 bin]# cd ~/timescaledb-0.12.1/
[root@server4 timescaledb-0.12.1]# ./
bootstrap build/ docs/ scripts/ sql/ src/ test/
[root@server4 timescaledb-0.12.1]# ./bootstrap
Build system already initialized in ./build
Do you want to remove it (this is IMMEDIATE and PERMANENT), y/n? y
-- The C compiler identification is GNU 4.8.3
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- TimescaleDB version 0.12.1. Can be updated from version 0.12.0
-- Build type is Release
-- Install method is 'source'
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success
-- Using compiler GNU
-- Found Git: /usr/bin/git (found version "1.8.3.1")
-- Using pg_config /appdev/pgsql/bin/pg_config
-- Compiling against PostgreSQL version 10.5
-- Install pgindent to be able to format C code: https://github.com/postgres/postgres/tree/master/src/tools/pgindent
CMake Error at CMakeLists.txt:274 (message):
PostgreSQL was built without OpenSSL support, which TimescaleDB needs for
full compatibility. Please rebuild PostgreSQL using `--with-openssl` or if
you want to continue without OpenSSL, re-run bootstrap with
`-DUSE_OPENSSL=0`
-- Configuring incomplete, errors occurred!
See also "/root/timescaledb-0.12.1/build/CMakeFiles/CMakeOutput.log".
[root@server4 timescaledb-0.12.1]# 提示postgresql没有带Openssl安装，那就索性，timescale也不带openssl安装。
[root@server4 timescaledb-0.12.1]# ./bootstrap -DUSE_OPENSSL=0
Build system already initialized in ./build
Do you want to remove it (this is IMMEDIATE and PERMANENT), y/n? y
-- The C compiler identification is GNU 4.8.3
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Detecting C compile features
-- Detecting C compile features - done
-- TimescaleDB version 0.12.1. Can be updated from version 0.12.0
-- Build type is Release
-- Install method is 'source'
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN
-- Performing Test CC_SUPPORTS_VISIBILITY_HIDDEN - Success
-- Using compiler GNU
-- Found Git: /usr/bin/git (found version "1.8.3.1")
-- Using pg_config /appdev/pgsql/bin/pg_config
-- Compiling against PostgreSQL version 10.5
-- Install pgindent to be able to format C code: https://github.com/postgres/postgres/tree/master/src/tools/pgindent
-- Using pg_regress /appdev/pgsql/lib/pgxs/src/test/regress/pg_regress
-- Using objdump /usr/bin/objdump
-- Configuring done
-- Generating done
-- Build files have been written to: /root/timescaledb-0.12.1/build
TimescaleDB build system initialized in ./build. To compile, do:
cd ./build && make
[root@server4 timescaledb-0.12.1]# cd ./build && make && make install
[root@server4 timescaledb-0.12.1]# cd ./build/
[root@server4 build]# ls
CMakeCache.txt cmake_install.cmake scripts src timescaledb.control
CMakeFiles Makefile sql test version.config
[root@server4 build]# make
Scanning dependencies of target sqlupdatescripts
[ 1%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.12.0--0.12.1.sql
[ 2%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.11.0--0.12.1.sql
[ 3%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.10.1--0.12.1.sql
[ 4%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.10.0--0.12.1.sql
[ 5%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.9.2--0.12.1.sql
[ 7%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.9.1--0.12.1.sql
[ 8%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.9.0--0.12.1.sql
[ 9%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.8.0--0.12.1.sql
[ 10%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.7.1--0.12.1.sql
[ 11%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.7.0--0.12.1.sql
[ 12%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.6.1--0.12.1.sql
[ 14%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.6.0--0.12.1.sql
[ 15%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.5.0--0.12.1.sql
[ 16%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.4.2--0.12.1.sql
[ 17%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.4.1--0.12.1.sql
[ 18%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.4.0--0.12.1.sql
[ 20%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.3.0--0.12.1.sql
[ 21%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.2.0--0.12.1.sql
[ 22%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.1.0--0.12.1.sql
[ 22%] Built target sqlupdatescripts
Scanning dependencies of target sqlfile
[ 23%] Generating /root/timescaledb-0.12.1/build/sql/timescaledb--0.12.1.sql
[ 23%] Built target sqlfile
[ 24%] Generating gitcommit.h
Scanning dependencies of target timescaledb
[ 25%] Building C object src/CMakeFiles/timescaledb.dir/agg_bookend.c.o
[ 27%] Building C object src/CMakeFiles/timescaledb.dir/cache.c.o
[ 28%] Building C object src/CMakeFiles/timescaledb.dir/cache_invalidate.c.o
[ 29%] Building C object src/CMakeFiles/timescaledb.dir/catalog.c.o
[ 30%] Building C object src/CMakeFiles/timescaledb.dir/chunk.c.o
[ 31%] Building C object src/CMakeFiles/timescaledb.dir/chunk_adaptive.c.o
[ 32%] Building C object src/CMakeFiles/timescaledb.dir/chunk_constraint.c.o
[ 34%] Building C object src/CMakeFiles/timescaledb.dir/chunk_dispatch.c.o
[ 35%] Building C object src/CMakeFiles/timescaledb.dir/chunk_dispatch_info.c.o
[ 36%] Building C object src/CMakeFiles/timescaledb.dir/chunk_dispatch_plan.c.o
[ 37%] Building C object src/CMakeFiles/timescaledb.dir/chunk_dispatch_state.c.o
[ 38%] Building C object src/CMakeFiles/timescaledb.dir/chunk_index.c.o
[ 40%] Building C object src/CMakeFiles/timescaledb.dir/chunk_insert_state.c.o
[ 41%] Building C object src/CMakeFiles/timescaledb.dir/constraint_aware_append.c.o
[ 42%] Building C object src/CMakeFiles/timescaledb.dir/copy.c.o
[ 43%] Building C object src/CMakeFiles/timescaledb.dir/dimension.c.o
[ 44%] Building C object src/CMakeFiles/timescaledb.dir/dimension_slice.c.o
[ 45%] Building C object src/CMakeFiles/timescaledb.dir/dimension_vector.c.o
[ 47%] Building C object src/CMakeFiles/timescaledb.dir/event_trigger.c.o
[ 48%] Building C object src/CMakeFiles/timescaledb.dir/extension.c.o
[ 49%] Building C object src/CMakeFiles/timescaledb.dir/guc.c.o
[ 50%] Building C object src/CMakeFiles/timescaledb.dir/histogram.c.o
[ 51%] Building C object src/CMakeFiles/timescaledb.dir/hypercube.c.o
[ 52%] Building C object src/CMakeFiles/timescaledb.dir/hypertable.c.o
[ 54%] Building C object src/CMakeFiles/timescaledb.dir/hypertable_cache.c.o
[ 55%] Building C object src/CMakeFiles/timescaledb.dir/hypertable_insert.c.o
[ 56%] Building C object src/CMakeFiles/timescaledb.dir/hypertable_restrict_info.c.o
[ 57%] Building C object src/CMakeFiles/timescaledb.dir/indexing.c.o
[ 58%] Building C object src/CMakeFiles/timescaledb.dir/init.c.o
[ 60%] Building C object src/CMakeFiles/timescaledb.dir/installation_metadata.c.o
[ 61%] Building C object src/CMakeFiles/timescaledb.dir/partitioning.c.o
[ 62%] Building C object src/CMakeFiles/timescaledb.dir/planner.c.o
[ 63%] Building C object src/CMakeFiles/timescaledb.dir/plan_expand_hypertable.c.o
[ 64%] Building C object src/CMakeFiles/timescaledb.dir/plan_add_hashagg.c.o
[ 65%] Building C object src/CMakeFiles/timescaledb.dir/planner_import.c.o
[ 67%] Building C object src/CMakeFiles/timescaledb.dir/planner_utils.c.o
[ 68%] Building C object src/CMakeFiles/timescaledb.dir/process_utility.c.o
[ 69%] Building C object src/CMakeFiles/timescaledb.dir/scanner.c.o
[ 70%] Building C object src/CMakeFiles/timescaledb.dir/sort_transform.c.o
[ 71%] Building C object src/CMakeFiles/timescaledb.dir/subspace_store.c.o
[ 72%] Building C object src/CMakeFiles/timescaledb.dir/tablespace.c.o
[ 74%] Building C object src/CMakeFiles/timescaledb.dir/trigger.c.o
[ 75%] Building C object src/CMakeFiles/timescaledb.dir/utils.c.o
[ 76%] Building C object src/CMakeFiles/timescaledb.dir/version.c.o
[ 77%] Building C object src/CMakeFiles/timescaledb.dir/bgw/job.c.o
[ 78%] Building C object src/CMakeFiles/timescaledb.dir/bgw/job_stat.c.o
[ 80%] Building C object src/CMakeFiles/timescaledb.dir/bgw/launcher_interface.c.o
[ 81%] Building C object src/CMakeFiles/timescaledb.dir/bgw/scheduler.c.o
[ 82%] Building C object src/CMakeFiles/timescaledb.dir/bgw/timer.c.o
[ 83%] Building C object src/CMakeFiles/timescaledb.dir/net/conn.c.o
[ 84%] Building C object src/CMakeFiles/timescaledb.dir/net/conn_plain.c.o
[ 85%] Building C object src/CMakeFiles/timescaledb.dir/net/http.c.o
[ 87%] Building C object src/CMakeFiles/timescaledb.dir/net/http_response.c.o
[ 88%] Building C object src/CMakeFiles/timescaledb.dir/net/http_request.c.o
[ 89%] Building C object src/CMakeFiles/timescaledb.dir/telemetry/uuid.c.o
[ 90%] Building C object src/CMakeFiles/timescaledb.dir/telemetry/metadata.c.o
[ 91%] Building C object src/CMakeFiles/timescaledb.dir/telemetry/telemetry.c.o
[ 92%] Linking C shared module timescaledb-0.12.1.so
[ 92%] Built target timescaledb
Scanning dependencies of target timescaledb-loader
[ 94%] Building C object src/loader/CMakeFiles/timescaledb-loader.dir/loader.c.o
[ 95%] Building C object src/loader/CMakeFiles/timescaledb-loader.dir/bgw_message_queue.c.o
[ 96%] Building C object src/loader/CMakeFiles/timescaledb-loader.dir/bgw_counter.c.o
[ 97%] Building C object src/loader/CMakeFiles/timescaledb-loader.dir/bgw_launcher.c.o
[ 98%] Building C object src/loader/CMakeFiles/timescaledb-loader.dir/bgw_interface.c.o
[100%] Linking C shared module timescaledb.so
[100%] Built target timescaledb-loader
[root@server4 build]#
[root@server4 build]# make install
[ 22%] Built target sqlupdatescripts
[ 23%] Built target sqlfile
[ 92%] Built target timescaledb
[100%] Built target timescaledb-loader
Install the project...
-- Install configuration: "Release"
-- Installing: /appdev/pgsql/share/extension/timescaledb.control
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.12.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.11.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.10.1--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.10.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.9.2--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.9.1--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.9.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.8.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.7.1--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.7.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.6.1--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.6.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.5.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.4.2--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.4.1--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.4.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.3.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.2.0--0.12.1.sql
-- Installing: /appdev/pgsql/share/extension/timescaledb--0.1.0--0.12.1.sql
-- Installing: /appdev/pgsql/lib/timescaledb-0.12.1.so
-- Installing: /appdev/pgsql/lib/timescaledb.so
[root@server4 build]# postgresql.conf添加共享库
# - Kernel Resource Usage -
shared_preload_libraries = 'timescaledb' # (change requires restart)
# - Cost-Based Vacuum Delay -
重启postgresql, psql连入
建立数据库
testdb=# create database ts1;
CREATE DATABASE
testdb=# \c ts1
You are now connected to database "ts1" as user "postgres".创建timescaledb extension
ts1=# create extension if not exists timescaledb CASCADE;
WARNING:
WELCOME TO
_____ _ _ ____________
|_ _(_) | | | _ \ ___ \
| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /
| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \
| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /
|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/
Running version 0.12.1
For more information on TimescaleDB, please visit the following links:
1. Getting started: https://docs.timescale.com/getting-started
2. API reference documentation: https://docs.timescale.com/api
3. How TimescaleDB is designed: https://docs.timescale.com/introduction/architecture
Note: TimescaleDB collects anonymous reports to better understand and assist our users.
For more information and how to disable, please see our docs https://docs.timescaledb.com/using-timescaledb/telemetry.
CREATE EXTENSION
ts1=# timescaledb已安装成功
编译debug版本
./bootstrap -DCMAKE_BUILD_TYPE="Debug"
create table "ckts2"(
time TIMESTAMPTZ NOT NULL,
"id" int,
"col2" int
);
SELECT create_hypertable('ckts2', 'time');
建表和超表
tsdb=# \d
List of relations
Schema | Name | Type | Owner
--------+-------+-------+----------
public | ckts2 | table | postgres
(1 row)
tsdb=# SELECT create_hypertable('ckts2', 'time');
create_hypertable
-------------------
(1 row)
tsdb=# \d+ ckts2
Table "public.ckts2"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------+--------------------------+-----------+----------+---------+---------+--------------+-------------
time | timestamp with time zone | | not null | | plain | |
id | integer | | | | plain | |
col2 | integer | | | | plain | |
Indexes:
"ckts2_time_idx" btree ("time" DESC)
Triggers:
ts_insert_blocker BEFORE INSERT ON ckts2 FOR EACH ROW EXECUTE PROCEDURE _timescaledb_internal.insert_blocker()
tsdb=#
文章浏览阅读521次。来自：http://blog.51cto.com/simeon/1981572作者介绍陈小兵，高级工程师，具有丰富的信息系统项目经验及18年以上网络安全经验，现主要从事网络安全及数据库技术研究工作。《黑客攻防及实战案例解析》《Web渗透及实战案例解析》《安全之路-Web渗透及实战案例解析第二版》《黑客攻防实战加密与解密》《网络攻防实战研究：漏洞利用与提权》作者，在国内多本学术期..._mysql 5.0.16入侵
文章浏览阅读135次。https://learn.microsoft.com/zh-cn/sql/ssms/release-notes-ssms?view=sql-server-ver16#previous-ssms-releases_sql server历史版本哪儿下
文章浏览阅读2.5k次。简介自学的【狂神JAVA】MyBatis分享自写源码和笔记，希望对大家有帮助本人配置jdk13.0.2 （jdk1.7以上均可）Maven 3.6.3MySQL 5.7.23 （mysql5.6以上均可）1. 配置官网文档： https://mybatis.org/mybatis-3/zh/getting-started.htmlpom.xml<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://_jdk1.7的mybatis
文章浏览阅读913次。调度中心的代码启动源码是从：XxlJobAdminConfig 入口；直接进入： xxlJobScheduler.init();第一个： initI18n() 处理国际化；第二个：JobRegistryMonitorHelper.getInstance().start(); 创建启动后台线程来维护在线的执行器组下的机器列表，从上篇学习笔记—分布式调度之xxlJob执行器的启动源码解析可以..._xxl 调度失败:执行器地址为空
文章浏览阅读1.3w次，点赞3次，收藏72次。之前贴出了代码，但是源码已经找不到了；鉴于很多同学私信想要参考，找时间重新写了一个工程一、参考代码1.不方便下载的同学可以参考贴出来的源代码链接：RS485二、基本知识1.RS485通信讲解：读30001、30002两个寄存器，假设从机地址为1上位机（主机）发送下行报文：01 03 00 03 00 02 34 0B从机地址功能码寄存器起始地址读取寄存器个数CRC校验010300 0300 0285 ca010300 0400 0285 ca上_485代码
文章浏览阅读1k次。http://www.sina.com.cn 2005年04月07日 11:19 新浪科技 文/李开复 人才：微软的立业之本 微软公司把重视人才的管理理念视为公司的核心财富。在信息时代里，人才的价值尤为重要。在工业时代里，一个优秀技工和一个普通技工的效率差异可能是30%，但在信息时代里，一个高级程序员和一个普通程序员的效率差异可能高达10倍以上。 ad1= "打造校_在微软许多人都像我一样主动从事发现人才、跟踪人才和吸引人才的工作....
文章浏览阅读2k次，点赞4次，收藏25次。（visual studio 2019可运行）输入及输出要求见《数据结构C语言(第二版)》严蔚敏版【本文仅用于啥都看不懂还想交作业选手】#include<iostream>#include<map>#include<string>#include<stdio.h>#include<memory.h>using namespace std;typedef struct{ char c; int weight; in_基于哈夫曼树的数据压缩算法c语言
文章浏览阅读1w次。Teams Bot App 代码解析_adaptivecards.declare(rawlearncard).render(this.likecountobj)
文章浏览阅读2.5k次。RawImage(Script)Texture 纹理 要显示的图片，注意：图片类型可以是任何类型 Color 颜色 图片的主颜色 Material 材质 渲染材质 Raycast Target 光线投射目标 是否可接收射线碰撞事件检测 UV Rect UV矩形 显示效果：X、Y属性用于控制纹理左右..._unity原始图像
文章浏览阅读2k次。随着互联网应用的复杂性增加，越来越多的公司选择使用微服务架构模式进行应用开发，将单体应用拆分成多个小型服务，每个服务部署在不同的服务器上。同时，为了提升系统的可用性、容错性和可扩展性，需要考虑分布式事务问题。本文将介绍 Spring Boot 在分布式事务中的一些实现方案，并给出相关原理。
文章浏览阅读2.8k次，点赞12次，收藏90次。权当学习笔记吧_黑马微信小程序笔记
采用Spring Boot框架进行后端开发，结合前端技术（如Vue.js、React等）进行页面设计，数据库采用MySQL进行数据存储，确保系统的稳定性和性能。本项目旨在设计并实现一个基于Spring Boot的旅游网站，为用户提供便捷的旅游信息查询、预订服务，以及旅游资讯分享功能，提升用户旅游体验。通过市场调研和用户需求分析，了解用户对旅游网站的需求和偏好，明确系统的功能和特点，确保系统能够满足用户的旅游需求。进行全面的系统测试，包括功能测试、性能测试、安全性测试和用户体验测试，确保系统的质量和可靠性。