mgalalm
asked on
Who has the responsibility to modify the my.cnf of mysql
We have a small team of web developers and infrastructure team members, we don't have an DB Admin, Who has the responsibility to edit the my.cnf of mysql for example to change mysql components like mysqld, mysl client, mysqldump to use utf8 instead of latin1 on the production?
The answer if very much dependent on your organization. If you have a clear defined infrastructure team that handles the server-side, database server configuration may fall in their lap OR given it is part of the web application architecture, some organizations put that all together. From a more practical or easy standpoint, who has the most expertise in MySQL? The important part is getting it right. Everyone will benefit. So pick the best individual(s) regardless of department because you are one "team." At least that is my take from a small organization.
If you have database in use on the production server, changing the existing databases to use UTF-8 instead of Latin1 can cause web pages to fail. Are you sure you want to do that?
You can always set up a new database to use UTF-8... but then you need to setup communications and web pages to use it also so nothing gets scrambled in the process. You can tell the MySQL driver to use UTF-8 in the code that accesses the database.
Here's more info: http://dev.mysql.com/doc/refman/5.5/en/charset-syntax.html
What programming languages are you using?
You can always set up a new database to use UTF-8... but then you need to setup communications and web pages to use it also so nothing gets scrambled in the process. You can tell the MySQL driver to use UTF-8 in the code that accesses the database.
Here's more info: http://dev.mysql.com/doc/refman/5.5/en/charset-syntax.html
What programming languages are you using?
ASKER
I am using drupal, the problem is NOT with the utf-8 , the problem is who is responsible to touch this area for this change and smiler?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.