[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
Database Developer
Q1Media.com <http://www.q1media.com/>
M: 305-772-6435
LinkedIn <http://www.linkedin.com/in/dwaynemcnab>

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 SERVER-14378). The Simba ODBC driver is compatible with 2.6 and most probably uses system.namespaces to retrieve the list of collections.

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 ]

Hi dwayne@q1media.com,

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,
Ramón.

Generated at Thu Feb 08 03:48:29 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.