[SERVER-18697] Would like to convert a collection running WiredTiger back to MMAPV1 Created: 27/May/15 Updated: 04/Aug/15 Resolved: 28/May/15 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Storage |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Question | Priority: | Major - P3 |
| Reporter: | Dwayne Mcnab | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: |
| Description |
|
I am trying to connect the software Tableau to mongodb using a third party ODBC driver from a company called Simba. However, it appears that wiredTiger is not supported. How can i convert a single collection within a database to a particular storage engine? |
| Comments |
| Comment by Asya Kamsky [ 04/Aug/15 ] |
|
Adding a note in case someone finds this ticket after the fact - the latest version of Simba ODBC driver now supports 3.0 with all storage engines. |
| Comment by Dwayne Mcnab [ 29/May/15 ] |
|
Kaloian, That was very helpful thank you. Regards, Dwayne Mcnab |
| Comment by Kaloian Manassiev [ 29/May/15 ] |
|
Hi Dwayne, The problem is not that the driver does not support SCRAM-SHA-1, but the lack of system.namespaces collection on WiredTiger (see I don't know how the ODBC driver works and I recommend you turn to Simba for support. However, you might want to see if you can use the collection directly if you know its name and if the driver allows the collection to be specified explicitly. Hope this helps. -Kal. |
| Comment by Dwayne Mcnab [ 28/May/15 ] |
|
Hi Kaloian, I should clarify that. The ODBC driver doesn't support SCRAM-SHA-1. When I try to connect tableau to mongodb running 3.0 it allows be to connect but cant seems to find any of the collections. However, when running 2.6, I can connect to the database and see the collections just fine. |
| Comment by Kaloian Manassiev [ 28/May/15 ] |
|
Also you are mentioning that "... it appears that wiredTiger is not supported by the ODBC driver". The type of the storage engine should be largely transparent to the ODBC driver - i.e. it shouldn't care what engine is in use by MongoDB. May I ask what is the error that you are getting from the ODBC driver? Feel free to attach the relevant logs to this ticket or just open a new discussion on the mongodb-user group. Thanks in advance. -Kal. |
| Comment by Ramon Fernandez Marina [ 28/May/15 ] |
|
dwayne@q1media.com, we've moved this ticket to the SERVER project as it's really a question for the MongoDB server. The storage engine is a per-instance characteristic, so it's not possible to have different collections in the same database/instance using different storage engines. If all you need to do is read data from this collection a possible approach is to add a secondary node using the MMAPv1 storage engine and direct reads to this secondary node. Please note that the SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag, where your question will reach a larger audience. A question like this involving more discussion would be best posted on the mongodb-user group. Regards, |