Not the answer you need?
Register and ask your own question!

XtraDB Cluster with .Net Entity Framework 6.2

karl123karl123 EntrantCurrent User Role Novice
Hi, I have an existing system running .Net with EntityFramework 6 connecting to a MySQL database using the Oracle .Net Connector. I would like to migrate my database to XtraDB Cluster with 3 nodes for performance reasons.

So firstly I would like to check that this is compatible and a recommended thing to do.

Secondly I am having a problem.

I have created an XtraDB Cluster Node (boot strapped) that I am testing to see if it works with my EF6 application. I've imported my existing database via mysqldump.. At an initial basic level it seems to work. I can connect, authenticate etc. However I've wanted to run a migration (update the database schema) and have had the following error message.

"Percona-XtraDB-Cluster doesn't recommend using SERIALIZABLE isolation with pxc_strict_mode = ENFORCING"

I don't really want to turn off strict mode. Does anyone have experience with EF6 and PXC that can recommend how I should deal with this?

Thanks,
Karl

Comments

  • karl123karl123 Entrant Current User Role Novice
    PS. I solved my problem. I had to deal with capitalisation differences in the previous database and the new one.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.