Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Current Events
Join our developers event to win one of the valuable prizes!
tagged
posted 5 months ago
viewed 3204 times
Share this article

CUBRID 9.3.0 has been released with new features, performance improvements, error fixes and more

cubrid_facebook_cover_201405_resize.png

Today I am excited to announce an updated 9.x branch - CUBRID 9.3.0 has been released. CUBRID 9.3 is the version which stabilized and improved CUBRID 9.2.

CUBRID 9.3's DB volume is compatible with 9.2's. CUBRID 9.1 and previous version should migrate database.

There are a number of new features and performance improvements in 9.3.0 that I will describe below.

You can download the latest version of CUBRID 9.3.0 for Windows and Linux from http://www.cubrid.org/?mid=downloads&item=cubrid&os=any&cubrid=9.3.0

New Features

The new features of CUBRID 9.3.0 are involved with several database aspects : SQL, HA, Administrative Convenience, Utility and Driver.

SQL New Features

Support SELECT FOR UPDATE Statement

The FOR UPDATE clause can be used in SELECT statements for locking rows returned by the statement for a later UPDATE/DELETE.

SELECT * FROM t1 INNER JOIN t2 ON t1.i=t2.i ORDER BY 1 FOR UPDATE OF t1, t2;

Support Schema Lock

The following two locks for schema are added.

  • SCH-S: Schema stability lock. This lock is obtained while query compile is being executed and guarantees that the schema included in the query is not modified by other transactions.
  • SCH-M: Schema modification lock. This lock is obtained while DDL (ALTER/CREATE/DROP) is being executed and prevents the modified schema from being accessed by other transactions.

As the schema lock is applied, the deadlock problem which has occurred when multiple DELETEs on the table without indexes were executed is solved.

Support various SHOW syntaxes for checking the internal database information

The SHOW ACCESS STATUS statement is added to display the login information of the database account. This statement can only be used by a "DBA" account

The "SHOW VOLUME HEADER" is added to display the specific volume header's information.

The "SHOW HEAP HEADER" statement displays the header page of the specified heap. The "SHOW HEAP CAPACITY" statement displays the capacity of the specified heap.

The "SHOW INDEX HEADER" statement displays the header page of the specified index. The "SHOW INDEX CAPACITY" statement displays the capacity of the specified index.

The "SHOW SLOTTED PAGE HEADER OF VOLUME=vol_num AND PAGE=page_num" statement displays the header information of the specified slot page. The "SHOW SLOTTED PAGE SLOTS OF VOLUME=vol_num AND PAGE=page_num" statement displays all slot information of the specified slot page.

Support SHA-1, SHA-2, TO_BASE64, and FROM_BASE64 functions.

  • Add SHA-1 and SHA-2 functions
  • Add the TO_BASE64 function and the FROM_BASE64 function.
  • Support the "IF EXISTS" clause for the DROP SERIAL statement.
  • Add a hint, SKIP_UPDATE_NULL to allow a constraint of a certain column from NULL to NOT NULL without data verification.

HA New Features

CUBRID 9.3.0 contains following improvements in HA environment. 

CUBRID allows a broker to connect only to replica

CSQL can do write operations to slave or replica if it has a special option

A utility for shrinking the replicating time is added

Other HA features 

Improvement of Administrative Convenience

Internal status information of SHARD proxy is strengthened

The SHARD proxy status information items are added and the number of shard proxy errors can be identified.

A number of options are added or changed in the "cubrid broker status" command.

A command to test whether the query specified in the DB is successfully executed or not, is added

A command to test query execution to the DB and to display whether the execution is successful or has failed has been added. After a query is executed, the transaction is rolled back. If the SHARD is set, query can be executed to all SHARD DBs. With this command, connection status to the DB, user's query permission, and hashing result of the SHARD DB can be checked.

Configuration

Utility

Drivers

Improvement of Performance

SQL Performance Improvement

Sharding Performance Improvment

Other Improvments

Behavior Changes

Some of the functionality in CUBRID 9.3.0 have been changed.

Besides these new features, performance improvements and behavioral changes, there are many bug fixes and minor improvements in resource management. For the full list refer to CUBRID 9.3.0 Release Notes.

If you would like to migrate from previous version to the latest CUBRID 9.3.0, please refer to Upgrading to CUBRID 9.3.0.

If you have any questions, feel free to leave your comment below.



comments powered by Disqus