Difference between revisions of "Configuring the MySQL Server"
From AgileApps Support Wiki
imported>Aeric m (Text replace - 'Category:System Administration' to 'Category:Installation') |
imported>Aeric |
||
| Line 7: | Line 7: | ||
:;Configuration file:<tt>my.cnf</tt>, a MySQL configuration file that may be edited and used in the MySQL client or MySQL Server installation | :;Configuration file:<tt>my.cnf</tt>, a MySQL configuration file that may be edited and used in the MySQL client or MySQL Server installation | ||
Configure MySQL using these values: | '''Configure MySQL using these values:''' | ||
:{| border="0" cellpadding="5" cellspacing="0" | :{| border="0" cellpadding="5" cellspacing="0" | ||
| Line 32: | Line 32: | ||
;MySQL Configuration for <tt>UTF-8</tt> Unicode character set: | ;MySQL Configuration for <tt>UTF-8</tt> Unicode character set: | ||
:*Add the following code to the <tt>my.cnf</tt> file, located in the MySQL Client: | :*Add the following code to the <tt>my.cnf</tt> file, located in the MySQL Client: | ||
::<tt> | ::<tt>character-set-server=utf8</tt> | ||
:*Add the following code to the <tt>my.cnf</tt> file, located in MySQL Server: | :*Add the following code to the <tt>my.cnf</tt> file, located in MySQL Server: | ||
::<tt>character-set-server=utf8</tt> | ::<tt>character-set-server=utf8</tt> | ||
Revision as of 22:26, 29 May 2013
Configuring the MySQL Server
Terminology used in this section:
- MySQL Server
- The database server, which has MySQL Server software installed, configured and running
- MySQL Client
- Any other computer which connects to the database server and has the MySQL Client software installed, configured and running
- The client connects to the database server for purposes of accessing data
- For example, a webserver may be such a client
- Configuration file
- my.cnf, a MySQL configuration file that may be edited and used in the MySQL client or MySQL Server installation
Configure MySQL using these values:
- Storage Engine
- default-storage-engine = innodb
- Learn more: The InnoDB Storage Engine
- Server System Variables Configuration
- It has been observed that READ_UNCOMMITTED does not work well with Row-Based Replication. Use one of the following configurations:
- a) Either STATEMENT-BASED or MIXED replication, with the Transaction Isolation level dictated by business needs.
- b) ROW-BASED replication with transaction_isolation = READ-COMMITTED
- User Configuration
-
- Create a user account with password in MySQL to be used by the Application Server
- The user account should have all MySQL privileges enabled on all databases
- The default root account that is created during the installation of MySQL can be used
- sql-mode Configuration
-
- For a First-Time installation:
- Add the following code to the my.cnf file located in the MySQL Client:
- sql-mode="PIPES_AS_CONCAT,ANSI_QUOTES"
- Add the following code to the my.cnf file located in the MySQL Server:
- sql-mode="PIPES_AS_CONCAT,ANSI_QUOTES"
- MySQL Configuration for UTF-8 Unicode character set
-
- Add the following code to the my.cnf file, located in the MySQL Client:
- character-set-server=utf8
- Add the following code to the my.cnf file, located in MySQL Server:
- character-set-server=utf8
- collation-server=utf8_general_ci
- The character set defines how records can be alphanumerically ordered (or grouped, sorted, filtered, indexed). Because the list of supported languages is determined by the character set available at the server level, the UTF-8 Unicode character set configuration is required as part of MySQL configuration. See Specify character settings at MySQL configuration time for details.
- max_allowed_packet Configuration
-
- Add the following variable to my.cnf or my.ini
- max_allowed_packet = 8M. See additional information regarding this variable for details.
- Restart the MySQL server to implement these changes