View Issue Details

IDProjectCategoryView StatusLast Update
0006982OXID eShop (all versions)4.01. Database handlingpublic2019-05-21 09:31
Reportermgmtp 
PrioritylowSeverityfeatureReproducibilityalways
Status acknowledgedResolutionopen 
Product Version6.1.3 
Target VersionFixed in Version 
Summary0006982: Primary key for galera cluster
DescriptionWe try for our customer project to scale the database of an OXID enterprise shop (version 6.1.3) via a mariadb galera cluster.

Galera requires a primary key in each table. But we have found some problems with different tables. These table have no primary key set:

* oxadminlog
* oxarticles2shop
* oxattribute2shop
* oxcategories2shop
* oxdelivery2shop
* oxdeliveryset2shop
* oxdiscount2shop
* oxinvitations
* oxlinks2shop
* oxmanufacturers2shop
* oxnews2shop
* oxselectlist2shop
* oxvendor2shop
* oxvoucherseries2shop
* oxwrapping2shop

Is a primary key planned foor these tables and will this be included in future releases?

Are the following steps an option:
* set the unique key of alle 2shop tables also as primary key
* create a auto increment primary key for oxadminlog and oxinvitations

Thanks for your help.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP Version7.1
MySQL VersionNot defined

Relationships

duplicate of 0006981 closed Primärschlüssel bei Galera Skalierung 

Activities

QA

2019-05-21 09:31

administrator   ~0012893

Last edited: 2019-05-21 09:31

View 2 revisions

Info from Dev: There is already a feature request for Maria Db and MySQL 8 support.
Active implementation is not yet available.

- es -