Advice about database size

[David George, modificado 12 Anos atrás.]

We have a live Liferay 6.0.5 install. The MySQL database is around 40GB, this includes documents (pdfs, images). We stuck these in MySQL to simplify clustering. We have two Liferay frontends targetting a single database.

My feeling is that we should migrate the documents out of MySQL onto the AdvancedFileSystemHook although we would need to install a SAN which supports locking to do this.

Does anyone have any advice.

[Hitoshi Ozawa, modificado 12 Anos atrás.]

Storing large binary files really degrades performance. I think you're making the right decision moving your files out to SAN.

Have you tried Control Panel -> Server Administration -> Data Migration

[David George, modificado 12 Anos atrás.]

I did try the data migration tool. It nearly worked - just some errors. I saw someone already had problems with version numbers so I'm going to check out the code and write a patch if necessary. I'm on 6.0.5.

I can't believe how big the DB is. It was 4 GB about 3 months ago. SAN looks the way to go.

[Hitoshi Ozawa, modificado 12 Anos atrás.]

I can't believe how big the DB is. It was 4 GB about 3 months ago.

I don't think it just text in there. Do you have many binary files?

[Raja Seth, modificado 12 Anos atrás.]

Hi David,

You can refer to this document. It would help you in configuring.

Regards,
Raja