Support for NDB Cluster Engine

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
trefster
Posts: 1
Joined: Wed 08 May 2013 20:05

Support for NDB Cluster Engine

Post by trefster » Wed 08 May 2013 20:08

Does anyone know of a way to configure dotConnect to use the NDB Engine?

I'm using it in Entity CodeFirst, but it always creates INNODB tables. We really need support for clustering.

Thanks!

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Support for NDB Cluster Engine

Post by Shalex » Fri 10 May 2013 08:05

trefster wrote:Does anyone know of a way to configure dotConnect to use the NDB Engine?
Currently there is a possibility of setting the following engines in Code-First Migrations (via the CreateTableConfiguration anonymous argument in CreateTable):
* InnoDB,
* MyISAM,
* Memory,
* CSV,
* Archive

We are planning to add the NDB engine support. Also there will be a global option to use a particular engine for all tables in Code-First and Code-First Migrations. We will notify you when the feature is implemented.

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Support for NDB Cluster Engine

Post by Shalex » Wed 15 May 2013 11:26

  • The config.DatabaseScript.Table.StorageEngine option for possibility of setting MySQL storage engine for creating tables with CreateDatabase() and Code-First Migrations functionality is implemented
  • The NDB storage engine is added to the list of available MySQL storage engines for Code-First
We will post here when the corresponding build of dotConnect for MySQL is available for download.

jonathan82
Posts: 1
Joined: Fri 09 Oct 2015 06:28

Re: Support for NDB Cluster Engine

Post by jonathan82 » Fri 09 Oct 2015 06:44

Hi, has this issue been resolved? How can I use Entity Framework Code first migrations with ndbcluster engine when creating a table?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Support for NDB Cluster Engine

Post by Shalex » Fri 09 Oct 2015 16:37

jonathan82 wrote:has this issue been resolved?
The functionality is available starting from the 7.6.242 (16-May-13) build: https://www.devart.com/dotconnect/mysql ... story.html.
jonathan82 wrote:How can I use Entity Framework Code first migrations with ndbcluster engine when creating a table?
Please set the engine in Code-First Migrations via the CreateTableConfiguration anonymous argument in CreateTable:

Code: Select all

  CreateTable("Blogs",
    c => new {
      BlogId = c.Int(nullable: false, identity: true),
      Name = c.String(unicode: false),
    },
    anonymousArguments: new CreateTableConfiguration() {
      StorageEngine = Devart.Data.MySql.Entity.MySqlStorageEngine.NDB
    }
  )
  .PrimaryKey(t => t.BlogId);

Post Reply