»çÀÌÆ® ¿î¿µ Áß DB ÆÐ½º¿öµå¸¦ º¯°æÇÏ¿´´Ù¸é ¿ÀǼҽº ÇÁ·Î±×·¥Àº ¼Ò½º»ó¿¡¼ ¿¬µ¿µÇ¾î ÀÖ´Â DB ÆÐ½º¿öµå¸¦ º¯°æÇؾßÇÕ´Ï´Ù.
DB ÆÐ½º¿öµå¸¦ º¯°æÇÏ°í ¼Ò½º»ó¿¡¼ ¿¬µ¿µÈ ÆÐ½º¿öµå ¼³Á¤À» º¯°æÇÏÁö ¾ÊÀ¸¸é »çÀÌÆ®´Â Á¤»ó µ¿ÀÛÇÏÁö ¾ÊÀ¸´Ï ÁÖÀÇÇϽñ⠹ٶø´Ï´Ù.
1. ¿öµåÇÁ·¹½º º¯°æ ¹æ¹ý
ÆÄÀϸí : ¿öµåÇÁ·¹½º ¼³Ä¡ À§Ä¡/wp-config.php
DB ÆÐ½º¿öµå ¼³Á¤ º¯°æ : wp-config.php ÆÄÀÏ¿¡¼ ¾Æ·¡ ºÎºÐ ¼Ò½º¸¦ ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
/** MySQL database password */
define('DB_PASSWORD', 'º¯°æ µÈ ÆÐ½º¿öµå·Î ±âÀÔ');
2. XE º¯°æ ¹æ¹ý
ÆÄÀϸí : XE ¼³Ä¡ À§Ä¡/files/config/db.config.php
DB ÆÐ½º¿öµå ¼³Á¤ º¯°æ : db.config.php ÆÄÀÏ¿¡¼ ¾Æ·¡ ºÎºÐ ¼Ò½º¸¦ ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù. 'master_db' =>
array (
'db_type' => 'mysql',
'db_port' => '3306',
'db_hostname' => '127.0.0.1',
'db_userid' => '¾ÆÀ̵ð',
'db_password' => 'º¯°æ µÈ ÆÐ½º¿öµå·Î ±âÀÔ',
'db_database' => '¾ÆÀ̵ð',
'db_table_prefix' => 'xe_',
),
'slave_db' =>
array (
0 =>
array (
'db_type' => 'mysql',
'db_port' => '3306',
'db_hostname' => '127.0.0.1',
'db_userid' => '¾ÆÀ̵ð',
'db_password' => 'º¯°æ µÈ ÆÐ½º¿öµå·Î ±âÀÔ',
'db_database' => '¾ÆÀ̵ð',
'db_table_prefix' => 'xe_',
),
3. ±×´©º¸µå º¯°æ ¹æ¹ý
ÆÄÀϸí : ÅØ½ºÆ®Å¥ºê ¼³Ä¡ À§Ä¡/data/dbconfig.php
DB ÆÐ½º¿öµå ¼³Á¤ º¯°æ : dbconfig.php ÆÄÀÏ¿¡¼ ¾Æ·¡ ºÎºÐ ¼Ò½º¸¦ ¼öÁ¤ÇÏ½Ã¸é µË´Ï´Ù.
define('G5_MYSQL_HOST', 'localhost');
define('G5_MYSQL_USER', '¾ÆÀ̵ð');
define('G5_MYSQL_PASSWORD', 'º¯°æ µÈ ÆÐ½º¿öµå·Î ±âÀÔ');
define('G5_MYSQL_DB', '¾ÆÀ̵ð');
* ÆÄÀÏ À§Ä¡´Â ±âº»¼³Ä¡ ±âÁØÀ̸ç, °æ·Î¸¦ µû·Î ÁöÁ¤ÇϼÌÀ» °æ¿ì ´Þ¶óÁú ¼ö ÀÖ½À´Ï´Ù.
* ÆÄÀÏ º¯°æ¿¡ ¾î·Á¿òÀÌ ÀÖÀ¸½Ã´Ù¸é, 1:1»ó´ãÀ» ÅëÇØ ±ÛÀ» ³²°ÜÁֽñ⠹ٶø´Ï´Ù.