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 9.1.0.0003 and PDO API version 9.1.0.0002 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.