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: 6

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: 7949

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: 6

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: 7949

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: 227

Join Date: August 18, 2011

Recent Posts

Hi David,

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

Regards,
Raja

Participate in the State of Liferay Community 2017. Help the community and even win some prizes!