--- title: "Benchmark Public Cloud Databases pour MongoDB (EN)" description: "Benchmark MongoDB Instances" url: https://docs.ovhcloud.com/fr/guides/public-cloud/databases/mongodb-benchmark lang: fr lastUpdated: 2025-01-06 --- # Benchmark Public Cloud Databases pour MongoDB (EN) ## Objective This guide aims at providing a detailed, step-by-step approach to benchmarking and sizing your OVHcloud MongoDB cluster based on specific loads. It covers estimating resource requirements, configuring the cluster, and using tools like YCSB and SimRunner for performance testing. By following this guide, you will be able to measure throughput, latency, and make informed decisions about the appropriate OVHcloud plan to meet your application's needs, ensuring optimal performance and scalability. ## Setting Up Benchmarking Tools ### YCSB (Yahoo! Cloud Serving Benchmark) [YCSB](https://github.com/brianfrankcooper/YCSB) is a framework for benchmarking and comparing the performance of various databases. It supports a wide range of workloads and provides a standardized way to measure throughput and latency. - Go through the [README](https://github.com/brianfrankcooper/YCSB/?tab=readme-ov-file#links) to install YCSB. - Refer to the [MongoDB README](https://github.com/brianfrankcooper/YCSB/tree/master/mongodb) to run YCSB on MongoDB. ### SimRunner [SimRunner](https://github.com/schambon/SimRunner) is a tool that binds: - a powerful data generator for MongoDB. - a declarative and highly scalable workload generator. Install SimRunner and configure it to simulate the load based on your current database metrics, and then create a configuration file for SimRunner that mimics your current workload. ## Benchmark Process with YCSB and SimRunner :::warning With YCSB version 0.17.0, make sure you have Python 2 installed, as YCSB will encounter errors if Python 3 is used. ::: ### Step 1: Set up an OVHcloud MongoDB Cluster - [Set up the OVHcloud MongoDB cluster](/fr/guides/public-cloud/databases/mongodb-getting-started.md). Make sure to select a plan with similar hardware specifications compared to the other databases with which you would like to benchmark. ### Step 2: Determine The Primary Node of MongoDB Cluster 1. Connect to the MongoDB cluster with the mongoshell, and then issue the command `rs.status()`. 2. Find the element with `members.stateStr: 'PRIMARY'`. 3. Take note of the value of the `members.name` field for that element. eg. `name: 'node2-0b70a1b78fff6c0e-admin.database.cloud.ovh.net:27017'`. You will use it in STEP 4 to load and run YCSB. ### Step 3: Configure The YCSB Workload YCSB provides pre-configured workloads under the `ycsb-0.17.0 > workloads` folder. You can set up your own workload based on the behavior of your application. :::info See [YCSB Core Properties](https://github.com/brianfrankcooper/YCSB/wiki/Core-Properties) for the list of available workload properties. ::: Here is an example of a workload: ```javascript # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or # implied. See the License for the specific language governing # permissions and limitations under the License. See accompanying # LICENSE file. # Yahoo! Cloud System Benchmark # Workload A: Update heavy workload # Application example: Session store recording recent actions # # Read/update ratio: 50/50 # Default data size: 1 KB records (10 fields, 100 bytes each, plus key) # Request distribution: zipfian recordcount=1000 operationcount=1000 workload=site.ycsb.workloads.CoreWorkload readallfields=true readproportion=0.5 updateproportion=0.5 scanproportion=0 insertproportion=0 requestdistribution=zipfian ``` ### Step 4: Load Data into MongoDB with YCSB - Example Loading the Provided `workloada` :::info For more details on how to run a workload, see [YCSB Run a Workload](https://github.com/brianfrankcooper/YCSB/wiki/Running-a-Workload). ::: While located in the `ycsb-0.17.0` directory, execute the following command with the provided `workloada` to load data into MongoDB. ```javascript ./bin/ycsb load mongodb -p mongodb.url="mongodb://myuser:mypassword@node2-0b70a1b78fff6c0e.database.cloud.ovh.net:27017/admin?replicaSet=replicaset&ssl=true" -s -P workloads/workloada ``` ![YCSB Load](/images/public-cloud/databases/mongodb-22-benchmark/YCSBLoad.png) Verify that the database `ycsb` and collection `usertable` got created and loaded with data. ### Step 5: Run The YCSB Workload - Example Running the Provided `workloada` While located in the `YCSB > ycsb-0.17.0` directory, execute the following command with the provided `workloada` to run the workload. ```javascript ./bin/ycsb run mongodb -p mongodb.url="mongodb://myuser:mypassword@node2-0b70a1b78fff6c0e.database.cloud.ovh.net:27017/admin?replicaSet=replicaset&ssl=true" -s -P workloads/workloada ``` ![YCSB run](/images/public-cloud/databases/mongodb-22-benchmark/YCSBrun.png) ### Step 6: Analyze and Benchmark the YCSB Output Metrics Take note of the run command output in Step 5, and benchmark it with other databases. ## Performance Testing With SimRunner ### Step 1: Select OVHcloud Plan Now that you have selected MongoDB as your database, it is time to setup the appropriate cluster. - Based on the metrics collected (CPU, RAM, Disk IOPS, Disk Space, etc.), choose an OVHcloud plan that meets the requirements of your application. - Consider future growth and scalability needs. You might want to consider how to [size a MongoDB cluster](/fr/guides/public-cloud/databases/mongodb-cluster-sizing.md). ### Step 2: Setup OVHcloud Cluster - [Set up the OVHcloud MongoDB cluster](/fr/guides/public-cloud/databases/getting-started.md). ### Step 3: Performance Testing With SimRunner - Go through the [README](https://github.com/schambon/SimRunner?tab=readme-ov-file#) to install and run SimRunner. - Run performance tests using SimRunner on your MongoDB cluster: `java -jar SimRunner.jar `. Here is an example of a configuration file: ```json { "connectionString": "mongodb+srv://myuser:mypassword@mongodb-8fff6c0e-o01ba0bef.database.cloud.ovh.net/admin?replicaSet=replicaset&ssl=true", "reportInterval": 1000, "http": { "enabled": false, "port": 3000, "host": "localhost" }, "mongoReporter": { "enabled": true, "connectionString": "mongodb://localhost:27017", "database": "simrunner", "collection": "report", "drop": false, "runtimeSuffix": false }, "templates": [ { "name": "person", "database": "test", "collection": "people", "drop": false, "template": { "_id": "%objectid", "first": "%name.firstName", "last": "%name.lastName", "birthday": "%date.birthday" }, "remember": ["_id", { "field": "first", "preload": false}], "indexes": [] } ], "workloads": [ { "name": "Insert some people", "template": "person", "op": "insert", "threads": 1, "pace": 100, "batch": 1000 }, { "name": "Find people by key", "template": "person", "op": "find", "params": { "filter": { "_id": "#_id" } }, "threads": 4 } ] } ``` ![SimRunner run](/images/public-cloud/databases/mongodb-22-benchmark/simRunnerRun.png) - The report output, `mongoReporter`, of the execution was set to be stored on the locally running MongoDB: `"connectionString": "mongodb://localhost:27017"` ![SimRunner output](/images/public-cloud/databases/mongodb-22-benchmark/simRunnerOutput.png) ## Step 4: Validation - Monitor the performance and adjust the cluster size and configurations as required by the application. - Validate that your application performs as expected with MongoDB. ## We want your feedback! We would love to help answer questions and appreciate any feedback you may have. If you need training or technical assistance to implement our solutions, contact your sales representative or click on [this link](https://www.ovhcloud.com/fr/professional-services/) to get a quote and ask our Professional Services experts for a custom analysis of your project. Join our [community of users](https://community.ovhcloud.com/). Are you on Discord? Connect to our channel at [https://discord.gg/ovhcloud](https://discord.gg/ovhcloud) and interact directly with the team that builds our databases service!