Createing zabbix database on MySQL 8.0.16 cluster database

[mellis]

I am trying to get a MySQL 8.0.16 Cluster database created. I go thought the steps till I get to the step where I run the zcat /usr/share/doc/zabbix-server-mysql-4.2.1/create.sql.gz | mysql -uzabbix -p zabbix -h127.0.,0.1 -P6446.

I see that it is creating the tables but on line 1789 I get an error "ERROR 3098 the table does not comply with the requirements by external plugin"

I tried adding a primary key to the dbversion thinking that was a requirement for the mysql cluster.

Anyone have an idea what the issue is?

[mellis]

Oh forgot I am using innodb cluster

[mellis]

I found this on the google internet thing https://lefred.be/content/mysql-grou...-table-design/
mysql> SELECT tables.table_schema , tables.table_name , tables.engine
-> FROM information_schema.tables
-> LEFT JOIN (
-> SELECT table_schema , table_name
-> FROM information_schema.statistics
-> GROUP BY table_schema, table_name, index_name HAVING
-> SUM( case when non_unique = 0 and nullable != 'YES' then 1 else 0 end ) = count(*) ) puks
-> ON tables.table_schema = puks.table_schema and tables.table_name = puks.table_name
-> WHERE puks.table_name is null
-> AND tables.table_type = 'BASE TABLE' AND Engine="InnoDB";
+--------------+--------------+--------+
| TABLE_SCHEMA | TABLE_NAME | ENGINE |
+--------------+--------------+--------+
| zabbix | dbversion | InnoDB |
| zabbix | history | InnoDB |
| zabbix | history_log | InnoDB |
| zabbix | history_str | InnoDB |
| zabbix | history_text | InnoDB |
| zabbix | history_uint | InnoDB |
+--------------+--------------+--------+
6 rows in set (0.03 sec)

[mellis]

database connect error.docx

So I added a primary key to the dbversion table got the schema script to run. Now I am looking to point a web interface to this database and get this message running the setup.php page.

[pggx999]

Same issue here,
Im finding a workaround adding auto_increment primary key
Also I will check the beta version (compiling) if the new schema.sql has the proper table definitions por InnoDB Cluster.

Is weird that they made this presentation mentioning that zabbix has non of those problems https://www.youtube.com/watch?v=Bvjl...utu.be&t=16216

I will post here if i make it

[mellis]

I was able to get this setup, but the performance was so bad that we took it down

[pggx999]

Finally I added BIGINT primary keys to those tables, problem solved, it will last for around 1000 years (accordin to my calcs).
I think with multi-primary (multi-write) this could be an enhance in NVPS troughput