MySql Community in production

[dranakan]

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 by a lot of corporations.

Could someone help me to know from how much volume (people or number of documents) it's better to start with another DB like MsSql or Oracle, … ? (approximately of course…)

Thanks

[norgan]

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

[dranakan]

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

[dranakan]

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.

Does exist a way to do hot backup without a expensive tool ? (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 . Has someone a script to run with cron to do Alfresco Backup) ?
Do you have some information like tutorial for the maintenance of this Mysql with Linux ?

Thanks 🙂

[dranakan]

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‍‍‍

[hagitok1]

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

[dranakan]

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;‍‍‍‍

[hagitok1]

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

[dranakan]

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)

[hagitok1]

THANK YOU !!!

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

Thanks again

Hagit