nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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.

http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html

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