topic Re: MySql Community in production in Alfresco Archive

MySql Community in production

dranakan — Tue, 15 Sep 2009 09:24:33 GMT

Hello,I would like to know if it's realistic to use MySql Community with Alfresco in production in a little-middle enterprise with 15-30 people ?It's difficult to me to estimate the number of documents… but for an enterprise having people working in office.MySql is able to do HotBackup and it is use

Re: MySql Community in production

norgan — Tue, 15 Sep 2009 12:53:28 GMT

Hi,
mysql is stable enough that it will not brake down on you, I dare to say. With your setting, the problem will probably be more of a server breakdown, deleting accidentally or having a virus/trojan savage your systems. I'd say,invest in backup/restore, desaster recovery and security awareness first.

Norgan

Re: MySql Community in production

dranakan — Wed, 02 Dec 2009 15:42:40 GMT

Hello,

Thank you Norgan.

Has someone a good tutorials for the maintenance of this Mysql community (tasks to do to keep performance (like a command to lauch each week), backup …)

There is documentation here : http://dev.mysql.com/doc/refman/5.0/en/index.html but I would like advices from Alfresco administrators.

Thanks

Re: MySql Community in production

dranakan — Tue, 15 Dec 2009 08:28:58 GMT

Hello,

I will do an installation with MySql and Linux (Centos 5.4). I would like to set a backup (restore) procedure but I have some questions.

(I saw there is mysqlhotcopy (but just for engine tables MyIsam or Archive and Alfresco tables use InnoDB : http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html

Thanks 🙂

Re: MySql Community in production

dranakan — Thu, 07 Jan 2010 12:42:01 GMT

Hello,

Hotbackup seems working fine like this :

Alfresco running
mysqldump -u alfresco -palfresco alfresco –opt –single-transaction –create-options > backupFile.sql
Copy alf_data‍‍‍

And to restore

Alfresco stop
mysql -ualfresco -palfresco alfresco < backupFile.sql
copy alf_dataBackup, remove lucene-indexes, mv backup-lucene-indexes in lucene-indexes‍‍‍

Re: MySql Community in production

hagitok1 — Wed, 04 Aug 2010 08:47:11 GMT

Hello

I saw your post and tried to do the same, But had a problem to restore according to your instructions
As when stopping alfresco also the mysql server is stopped the command "mysql -ualfresco -palfresco alfresco < backupFile.sql " fails and prompts the following error: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Do you know what I should do in order to make it work ?

Thenks

Hagit

Re: MySql Community in production

dranakan — Wed, 04 Aug 2010 09:00:03 GMT

Hello,

I am not sure to have all understand…

As when stopping alfresco also the mysql server is stopped….

Before doing the mysql restore, mysql must running. After that you can execute the command.

Can you do this ?


(start mysql)
mysql -ualfresco -palfresco alfresco
show tables;‍‍‍‍

Re: MySql Community in production

hagitok1 — Wed, 04 Aug 2010 09:57:56 GMT

Thank you for your fast response.
I never start or stop mysql independently from alfresco. When I start alfresco MySQL is started automaticaly and when I stop alfresco MYSQL is stopped automatically, So I do not know what I should do to start MySQL ? Which command should I use to run it ?

Hagit

Re: MySql Community in production

dranakan — Wed, 04 Aug 2010 10:09:43 GMT

It's depend of your installation… but on Linux try :


su
service mysqld start
‍‍‍‍

If you are on Windows, you can look at the alfresco bat file (that you use to start Alfresco)

Re: MySql Community in production

hagitok1 — Wed, 04 Aug 2010 10:43:37 GMT

THANK YOU !!!

I am on windows so I copyied the command from alfresco.bat and then I have restored the database.

Thanks again

Hagit