Issue #5993 has been updated by Nigel Kersten. Status changed from Needs Decision to Needs More Information
We definitely have people with much longer fields than this. If you can provide a more complete solution showing that this really is the only problem stopping us using ndb clusters, then I think we'd be much more willing to expend effort sorting this out. ---------------------------------------- Feature #5993: Puppet on mysql NDB cluster https://projects.puppetlabs.com/issues/5993 Author: Karl Pietri Status: Needs More Information Priority: Low Assignee: Nigel Kersten Category: stored configuration Target version: Affected Puppet version: 0.25.5 Keywords: Branch: The only minor issue for running puppet with its backend database on mysql ndb cluster is that the resources.title column is a text column and also part of an index which ndb forbids. I believe this would be not a very hard problem to fix as after analyzing my database i noticed the max character length was only 100, but i can see why the field was picked as a text column for longer resource (ie long path) names. Perhaps there is a easy way to fix this one issue (perhaps at the expense of duplicating the column to a full one and a partial one) and be able to easily and safely use puppet on ndb. Unfortunately i am not familiar with the actual puppet code (or very familiar with ruby at all), but i will be looking in to a way to patch this, so I thought I would open a feature request for it in case someone might be able to do it quickly or have ideas. Specific error: mysql> alter table resources engine=ndb; ERROR 1073 (42000): BLOB column 'title' can't be used in key specification with the used table type -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://projects.puppetlabs.com/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
