[Deploying Sakai] my.cnf advised settings

[Wolfgang Rohregger]

Hi,

what about the buffer size? When dumping Sakai databases with database storage of uploaded files enabled, dumping the mysql tables will fail over TCP/IP connections when the buffer is set too small.

 max_allowed_packet      = 16M

+1 to the character set settings.

And for security reasons:

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1


Cheers,

Wolfgang


________________________________________
Von: production-bounces at collab.sakaiproject.org [production-bounces at collab.sakaiproject.org] im Auftrag von Jean-Francois Leveque [jean-francois.leveque at upmc.fr]
Gesendet: Dienstag, 26. Juli 2011 12:36
An: sakai-dev Developers; production at collab.sakaiproject.org
Betreff: [Deploying Sakai] my.cnf advised settings

Hi all,

In
https://confluence.sakaiproject.org/display/DOC/Sakai+CLE+2.8+database+support,
under 5.2 Create a my.cnf/my.ini configuration file, there is "a
minimalist MySQL 5.1 configuration file for a development laptop
/etc/my.cnf" that only has:
> [mysqld]
> default-storage-engine=InnoDB
> lower_case_table_names=1

Is there another mention of /etc/my.cnf elsewhere in the 2.8 documentation ?

I think it would be worth adding:
> character_set_client=utf8
> character_set_server=utf8

What do you think ?

Cheers,

J-F
_______________________________________________
production mailing list
production at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/production

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"