Clustering and ezdbfile name

Thursday 05 June 2008 1:40:35 am

Hello.
We're working in a clustering environment for ez 3.9.2, so we've followed the steps shown at
http://ez.no/doc/ez_publish/technical_manual/3_9/features/clustering/setting_it_up

All works quite well, but we're having problems with the name file in ezdbfile table created.

Looking at definition of the tables suggested we can see

CREATE TABLE ezdbfile (
  id        MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
  datatype  VARCHAR(60)  NOT NULL DEFAULT 'application/octet-stream',
  name      VARCHAR(255) NOT NULL DEFAULT '',
  name_hash VARCHAR(34)  NOT NULL DEFAULT '',
  scope     VARCHAR(20)  NOT NULL DEFAULT '',
  size      BIGINT(20)   UNSIGNED NOT NULL,
  mtime     INT(11)      NOT NULL DEFAULT '0',
  PRIMARY KEY (id),
  UNIQUE INDEX ezdbfile_name (name),
  UNIQUE INDEX ezdbfile_name_hash (name_hash)
) ENGINE=InnoDB;

but this limits the length of the name files to only 255 characters. We have a contentstructure with several levels, and this levels have long names. The result is that we have file images name for about 280 and maybe 300 characters. So, this names are not entirely recorded and the db, and that's because we're thinking we're having problems with several images.

So, is there any workaround for this? We have reading we can define a bigger varchar field and mysql will convert it to another type, but anyone knows if this could cause any kind of problems?

Thank you.

Thursday 05 June 2008 2:27:17 am

Thanks so much for your reply.

I think we still haven't this issue with medium int but is good to know. We have clusterized this installation yesterday and we haven't any problems with the insertion of the files. All files seems to be in the ezdbfile table, but, as i said before, some of their names are truncated.

i'll let you know about. thanks.

Monday 09 June 2008 12:57:59 pm

Thanks. we're working with mysql 5.0.55.
we've altered this mysql script to create that name field as TEXT and not varchar. all works well now.

Btw, we we're talking with ez crew and they say to us that upgrading to 3.10 will be better for clustering.

thanks everybody.