- 🇳🇿New Zealand quietone
The ideas project is deprecated. Since this is being pursued in core in ✨ [meta] Add database driver for MongoDB to Core as experimental Active , I am closing this issue.
The database driver is a full support database driver without the of a relational database.
The database driver can be downloaded at https://gitlab.com/daffie/mongodb.
The database driver has the following characteristics:
- The driver stores all content entity data per entity instance in a single document. All entity data includes all revisional data, all translatable data and all field data. The single document in a collection in MongoDB is in a single row in a table for relational databases.
- It is a full support driver. So no other relational database is needed. All Drupal data is stored in MongoDB.
- The Drupal Database API is supported and the PDO statement interface is implemented.
- The Drupal Entity API is supported.
- The Drupal Entity Search API is supported, with the exception of the relationship part.
- The Drupal Views module is supported. Some things work a little bit different, because the underlying table structure is different. Also some date conversion options are not supported by MongoDB.
The business case for adding support for the database driver
Drupal currently only supports relational databases (MySQL, PostgreSQL and SQLite). These are all single server databases. They only scale vertical (a bigger computer). MongoDB also scales horizontal (multiple computers). As such MongoDB can support far bigger databases, far greater number of concurrent users and can be globally distributed. This results in a low latency response wherever the user is located on our planet. This all combined will result in bigger projects being possible with higher profit margins. No project will be too big for Drupal on a MongoDB database.
With the growing importance of decoupled Drupal, which is the result of single page applications popularity, the importance of the javascript language for the Drupal project is increasing. Therefore the Drupal project would like to attract more javascript developers. The problem is these developers dislike relational databases. To these developers relational databases are "legacy" software and by extension Drupal.
Running Drupal on MongoDB makes the Drupal software a lot less "legacy" for these javascript developers, and they will hopefully look more favorably at the Drupal.
An other advantage is that MongoDB can store all user uploaded files in the database (See https://docs.mongodb.com/manual/core/gridfs/). That makes it much easier to run Drupal on kubernetes or other containers.
Which changes does the database driver needs
To make the database driver for MongoDB work with Drupal Core, some changes are needed. The patch file with the changes can be found at https://gitlab.com/daffie/drumongous/blob/8.x/patches/drupal-on-mongodb-.... There is only one big backwards compatibility breaking change needed. In the class Drupal\Core\Database\Connection there is one method (__construct) where the parameter typehint (\PDO) needs to be removed. The driver mimics the PDO database connection, not actually create a real PDO connnection. I hope this change can be done in Drupal 9.0. Also MongoDB does not support SQL string queries. All class methods and functions that take SQL strings as input are not supported by the database driver for MongoDB.
Current status of the driver
The current status of the driver is “in development”. That is about 80% - 90% of all the kerneltests and functionaltests pass at the moment.
For more information see the added tests results file. Please do not use it for production!
Tryout running Drupal Core on MongoDB
You can tryout running Drupal Core on MongoDB with composer by creating a new project with https://gitlab.com/daffie/drumongous. You will need MongoDB version 3.6 or higher. Personally I have only used MongoDB version 3.6. I work on the driver with PHP version 7.1. Also the PHP extension “php-mongodb” version 1.5 or higher is needed. I have not tested the driver with any contrib modules or themes.
Any bugs, patches or suggestions can be reported at https://gitlab.com/daffie/mongodb. Watch out: The standard installation profile does not work. The minimal installation profile works minimally. The Umami installation profile works with some issues.
composer create-project daffie/drumongous:8.x-dev some-dir --no-interaction
Closed: duplicate
Idea
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
The ideas project is deprecated. Since this is being pursued in core in ✨ [meta] Add database driver for MongoDB to Core as experimental Active , I am closing this issue.