ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events
The newsletter announces the SQLE 3.0 release with new UI and demo environments, highlights the SQLE 2.2310.0‑pre3 update, reviews technical articles on MySQL cloning, OceanBase indexing, data replication, charset issues, and connection‑pool design, recaps recent conferences, and previews upcoming OB Cloud open class events.
1 Community Updates
SQLE 3.0 was released on Oct 24 with a brand‑new UI. Demo environments for the community and enterprise editions are available (Community: http://demo.sqle.actionsky.com/, Enterprise: http://demo.sqle.actionsky.com:8889/; login admin/admin). Documentation and issue submission links are provided.
SQLE 2.2310.0‑pre3 Release
The pre‑release adds default rule knowledge bases for MySQL and TDSQL, and includes recent work such as slow‑log keyword filtering, tag‑based audit sync, and rule bug fixes. Planned activities for the coming week are the official 2.2310.0 release, regression testing, and defect fixing.
2 Community Article Review
Technical Translation – MySQL Clone Failure Avoidance
The article explains how using the DATA DIRECTORY option with the CLONE INSTANCE command can prevent re‑initialisation when a clone fails due to insufficient disk space.
Technical Sharing – OceanBase Global and Local Indexes
Discusses the difference between global and local indexes in OceanBase, a distributed database, and demonstrates optimisation techniques through practical examples.
Industry Picks
“Data Replication Strategy Overview” – explains why data replication is essential for data safety.
“MySQL Character Set, Collation and Garbled Text Issues” – analyses common charset problems.
“Why Database Connection Pools Do Not Use I/O Multiplexing?” – explores the reasons behind the continued use of pools like c3p0.
3 Event Recap
The GOPS 2023 Global Operations Conference in Shanghai featured a talk on “New Database Operations Management Model in DevOps”. The community also participated in the OSC Suzhou meetup and other local activities.
4 Upcoming Activities
An OB Cloud open class in Guangzhou will cover distributed MySQL upgrades, ActionDB & OceanBase solutions, and include hands‑on labs and giveaways.
About SQLE
SQLE is a full‑stack SQL quality management platform supporting open‑source, commercial, and domestic databases, offering automated workflow for development and operations.
GitHub: https://github.com/actiontech/sqle Documentation: https://actiontech.github.io/sqle-docs/ Website: https://opensource.actionsky.com/sqle/
Aikesheng Open Source Community
The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.
How this landed with the community
Was this worth your time?
0 Comments
Thoughtful readers leave field notes, pushback, and hard-won operational detail here.