Over a million developers have joined DZone.

CUBRID PHP and PDO Drivers Now Support Database Sharding

DZone's Guide to

CUBRID PHP and PDO Drivers Now Support Database Sharding

· Big Data Zone ·
Free Resource

The open source HPCC Systems platform is a proven, easy to use solution for managing data at scale. Visit our Easy Guide to learn more about this completely free platform, test drive some code in the online Playground, and get started today.


Today I am thrilled to announce that we have released a new version of our PHP and PDO drivers which now support CUBRID SHARD Broker, a middleware in CUBRID Database that provides sharding feature.

How it all began...

For those of you who have not heard much about CUBRID open source database, it provides numerous great features for stability and horizontal scalability. This includes native support for High-Availability, Database Sharding, Load Balancing, and many more.

Since we have announced Database Sharding in CUBRID 8.4.3, we have been working hard on adding sharding support in all our APIs. Along with the announcement we have released new versions of our JDBC and C APIs which provided support for both Database Sharding and API-level Load Balancing. Then we have added sharding support in our node-cubrid Node.js API.

Now, sharding comes to PHP and PDO drivers thanks to Kirill Shvakov [Twitter link] from Russia who has spent his time to test and report issues to us. Last month he told us that he could not use our PHP and PDO drivers to correctly insert records to multiple shards when connecting to CUBRID SHARD Broker. This was due to the fast that we have not added SHARD Broker support in these drivers.

Now PHP API version and PDO API version includes patches to support CUBRID SHARD Broker. Next month we will release a new version for these drivers which will provide a few more sharding related fixes and a dozen of new features.

Notice: If you are going to use the latest version of PHP and PDO drivers available today, instead of using cubrid_execute() function, use cubrid_query(). Refer to this comment for more details. In the next release we will provide a fix for this.

If you have questions or feature requests, feel free to post on CUBRID ForumFacebookTwitterGoogle+, orFreenode #cubrid IRC channel.

Managing data at scale doesn’t have to be hard. Find out how the completely free, open source HPCC Systems platform makes it easier to update, easier to program, easier to integrate data, and easier to manage clusters. Download and get started today.


Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}