> 科技资讯 > StoneDB-5.7-v1.0.3 版本正式发布,优化主备能力/提高主从同步性能/快来体验~

StoneDB-5.7-v1.0.3 版本正式发布,优化主备能力/提高主从同步性能/快来体验~

科技资讯 投稿 6900℃ 0 评论

StoneDB-5.7-v1.0.3 版本正式发布,优化主备能力/提高主从同步性能/快来体验~

临近 2023 年春分的前一天，我们很高兴向广大社区用户宣布：StoneDB-5.7-v1.0.3 版本正式发布啦！这一个版本中，我们对 StoneDB 的主备能力进行了优化，进行了新一轮的生态适配，提高了主从同步性能，同时修复了一批已知 Bug，欢迎广大社区用户前往试用！以下是本次版本的 Release Notes：

  • 版本号：1.0.3

  • 发布日期： 2023 年 03 月 20 日

主备能力

  • Binlog 改造 — 指定 DDL 过滤。

  • SQL MODE 中增加参数 NO_KEY_ERROR，SQL 层对不支持 DDL 报错忽略。

    • 语法举例：

# 全局级别 mysql>set global sql_mode='NO_KEY_ERROR'; # 会话级别 mysql>set session sql_mode='NO_KEY_ERROR'; # my.cnf 配置文件 [mysqld]  sql_mode='NO_KEY_ERROR'

生态适配

  • StoneDB 版本号展示。

性能

  • 主从同步性能提升 #1213。

问题修复

修复了如下 Bug：

  • 执行 ALTER TABLE 语句添加 TIMESTAMP 字段返回结果不正确。#1327

  • 执行 ALTER TABLE 语句后 Update 表数据不正确。#1253

  • Bigint unsigned 返回结果不正确。 #1203

  • Load data 报错。#1209

  • AVG 函数返回结果不正确。#1125

  • ALTER TABLE 更改字段数据类型报错。#752

  • 其它 Bug。#103 #1230 #1255#1188 #1262

支持平台

  • CentOS 7.6 以上

  • Ubuntu 20

What's Changed

  • docs: update the Release Notes and Downloads by @Nliver in https://github.com/stoneatom/stonedb/pull/1237

  • fix(tianmu: tianmu.primary_secondary_bit crashed or failed(#1212 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1233

  • fix(website: fix the compile error(#1238 by @Nliver in https://github.com/stoneatom/stonedb/pull/1239

  • fix(website: delete the error tags and update docs(#1238 by @Nliver in https://github.com/stoneatom/stonedb/pull/1240

  • docs: update the docs of Roadmap and Quick Deployment by @Nliver in https://github.com/stoneatom/stonedb/pull/1242

  • build(deps: bump ua-parser-js from 0.7.31 to 0.7.33 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1243

  • fix: mirros pull failed in debian10_1.0.3 #1249 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1250

  • fix(website: Fixed the Roadmap module(#1255 by @Nliver in https://github.com/stoneatom/stonedb/pull/1256

  • test(mtr: add testcases for bit and unsigned(#1196 by @davidshiz in https://github.com/stoneatom/stonedb/pull/1257

  • feat(stonedb: show stonedb tag version. (#1251 by @lujiashun in https://github.com/stoneatom/stonedb/pull/1252

  • fix: docs some minors in README by @Amber1990Zhang in https://github.com/stoneatom/stonedb/pull/1259

  • feat(scripts: change default binlog format from statement to row in my.cnf.sample #1015 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1261

  • feat(stonedb:unsupport DDL should report error in SQL layer and ignore error in BINLOG layer.(#1227 by @DandreChen in https://github.com/stoneatom/stonedb/pull/1270

  • fix(stonedb: fix 'STONEDB_TAG_NAME' complier error. (#1262 by @lujiashun in https://github.com/stoneatom/stonedb/pull/1269

  • build(deps: bump http-cache-semantics from 4.1.0 to 4.1.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1271

  • feat(tianmu:Master-slave synchronization, bit type supported by conditional push (#1230 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1244

  • docs(quick-deployment: update the link of quick-deployment(#1282 by @Nliver in https://github.com/stoneatom/stonedb/pull/1283

  • build(deps: bump @sideway/formula from 3.0.0 to 3.0.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1284

  • fix action ssl build error by @lxd5866 in https://github.com/stoneatom/stonedb/pull/1287

  • fix(load: fix mysqld crash when loaded data column contains double enclosed char. (#1263 by @lujiashun in https://github.com/stoneatom/stonedb/pull/1268

  • feat(tianmu: add multi-thread aggregation of group by (#422 by @adofsauron in https://github.com/stoneatom/stonedb/pull/1279

  • test(mtr: optimize func_sec_to_time.test(#1196 by @davidshiz in https://github.com/stoneatom/stonedb/pull/1298

  • fix(tianmu: fix alter table add column not null.(#1188 by @DandreChen in https://github.com/stoneatom/stonedb/pull/1235

  • feat(scripts: check version of the compilation tools before build(#1295 by @davidshiz in https://github.com/stoneatom/stonedb/pull/1307

  • bug(tianmu:improve the code quality and refactoring derived table optimize for tianmu(#1277, #1276, #1258 by @isredstar in https://github.com/stoneatom/stonedb/pull/1281

  • fix(tianmu:the data is wrong when altering table after deleting.(#1199 by @DandreChen in https://github.com/stoneatom/stonedb/pull/1272

  • fix(tianmu:issue1090.test occasionally fails to run(#1234 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1314

  • workflow(git: Use the non strict ssh mode in PR by @RingsC in https://github.com/stoneatom/stonedb/pull/1299

  • fix(tianmu:the data is wrong when updating data after atlering table.(#1253 by @DandreChen in https://github.com/stoneatom/stonedb/pull/1297

  • feat(tianmu: support in-completed column data during load data. (#1209 by @lujiashun in https://github.com/stoneatom/stonedb/pull/1273

  • feat(tianmu:add some feature of init auto_increment_value for tianmu(#1201, #1072, #1059 by @isredstar in https://github.com/stoneatom/stonedb/pull/1315

  • feat(sql: add NO_KEY_ERROR to sql_mode for ignoring unsupported error.(#1318 by @DandreChen in https://github.com/stoneatom/stonedb/pull/1320

  • bug(tianmu:Server crashed, when execute select val, val >= '2010-02-22 18:35:23' from (select * from timetest as A; (#981 by @isredstar in https://github.com/stoneatom/stonedb/pull/1321

  • feat(tianmu:DDL function filtering optimization is not supported(#1325 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1330

  • fix(website: fix typo in compiling guidance by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1340

  • docs(Docs/website: update description on data type content #1366 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1338

  • fix(scripts: update man pages from MySQL Server 5.7.36 by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1354

  • fix(tianmu: fix endless loop occurs during data_cache (#1352 by @adofsauron in https://github.com/stoneatom/stonedb/pull/1353

  • feat(tianmu: support unsigned load export issue1329 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1334

  • feat(tianmu: add_timestamp_column Query result is incorrect #1327 by @wisehead in https://github.com/stoneatom/stonedb/pull/1341

  • fix(common: limit min signed int64 value to -9223372036854775806 #1206 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1349

  • fix(tianmu:Solve the problem that index renaming is not supported(#1345 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1351

  • fix(core: rm incorrect boundary check on rough check with between #1344 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1357

  • feat(tianmu: The error message displayed is inaccurate when you drop unique … by @wisehead in https://github.com/stoneatom/stonedb/pull/1356

  • feat(tianmu: storage support delta store by @duanfuxiang0 in https://github.com/stoneatom/stonedb/pull/1358

  • docs(website: Modify documentation(#1364 by @Nliver in https://github.com/stoneatom/stonedb/pull/1366

  • website: update the docs of Limits and add contact module (#1367 #1365 by @Nliver in https://github.com/stoneatom/stonedb/pull/1368

  • fix(tianmu: integer column with primary key problem(#1363 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1370

  • fix(tianm:oltp_read_write.lua sysbench returned error 1366(#1371 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1372

  • fix(tianmu: modify the minimum value of bigint by @El-even-11 in https://github.com/stoneatom/stonedb/pull/1375

  • feat(index: Failed to insert a null value to the composite primary key. #1374 by @wisehead in https://github.com/stoneatom/stonedb/pull/1377

  • fix(workflow: rm no longer use testcase issue410 and make issue1111 … by @hustjieke in https://github.com/stoneatom/stonedb/pull/1378

  • support exists/in subquery convert to semi-join by @duanfuxiang0 in https://github.com/stoneatom/stonedb/pull/1379

  • feat(tianmu:The delta layer supports master-slave synchronization(#1381 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1382

  • fix(tianmu: Avoid OOM when data too large and aggregated (#949 by @adofsauron in https://github.com/stoneatom/stonedb/pull/1355

  • feat(optimizer: If the SQL syntax contains 1 = 2,the StoneDB's InnoDB storage e… by @wisehead in https://github.com/stoneatom/stonedb/pull/1386

  • fix(core: fix the text field in subquery does no… by @wisehead in https://github.com/stoneatom/stonedb/pull/1390

  • build(deps: bump webpack from 5.74.0 to 5.76.1 in /website by @dependabot in https://github.com/stoneatom/stonedb/pull/1391

  • fix(tianmu:set sql_mode=NO_KEY_ERROR,Cannot create stored routine xxx. Check warnings(#1388 by @konghaiya in https://github.com/stoneatom/stonedb/pull/1392

  • fix(tianmu: fix mysqld crash when exec query limit 0 (#1394 by @adofsauron in https://github.com/stoneatom/stonedb/pull/1395

  • fix(core: incorrect result when execute sql with between | > or < in or not in #1332 by @hustjieke in https://github.com/stoneatom/stonedb/pull/1393

  • docs(stonedb: Update the latest docs(#1450 by @Nliver in https://github.com/stoneatom/stonedb/pull/1451

New Contributors

  • @Amber1990Zhang made their first contribution in https://github.com/stoneatom/stonedb/pull/1259

  • @lxd5866 made their first contribution in https://github.com/stoneatom/stonedb/pull/1287

  • @El-even-11 made their first contribution in https://github.com/stoneatom/stonedb/pull/1340

  • @wisehead made their first contribution in https://github.com/stoneatom/stonedb/pull/1341

Full Changelog: https://github.com/stoneatom/stonedb/compare/5.7-v1.0.2-GA...5.7-v1.0.3-GA

欢迎广大用户前往试用~

Github：

https://github.com/stoneatom/stonedb/releases/tag/5.7-v1.0.3-GA

Gitee：

https://gitee.com/StoneDB/stonedb/releases/tag/5.7-v1.0.3-GA

编程笔记 » StoneDB-5.7-v1.0.3 版本正式发布,优化主备能力/提高主从同步性能/快来体验~

赞同 (36) or 分享 (0)
游客 发表我的评论   换个身份
取消评论

表情
(0)个小伙伴在吐槽