Combination View Flat View Tree View
Threads [ Previous | Next ]
David George
Advice about database size
March 28, 2012 2:19 AM
Answer

David George

Rank: New Member

Posts: 5

Join Date: April 8, 2011

Recent Posts

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
RE: Advice about database size
March 28, 2012 6:09 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7952

Join Date: March 23, 2010

Recent Posts

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
RE: Advice about database size
March 29, 2012 12:06 PM
Answer

David George

Rank: New Member

Posts: 5

Join Date: April 8, 2011

Recent Posts

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
RE: Advice about database size
March 29, 2012 3:18 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7952

Join Date: March 23, 2010

Recent Posts

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
RE: Advice about database size
March 28, 2012 7:00 AM
Answer

Raja Seth

Rank: Regular Member

Posts: 164

Join Date: August 18, 2011

Recent Posts

Hi David,

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

Regards,
Raja