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


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.


Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}