http://dev.mysql.com/doc/refman/5.5/en/federated-storage-engine.html
centos 5´Â "Ŭ¶ó¿ìµå APM ¼³Á¤.txt" Áß¿¡¼ mysql 5.5 ¼³Ä¡·Î ÀÛ¾÷ÇÒ °Í. ±âº» mysql yum 5.0 À¸·Î´Â ¾ÈµÊ
/etc/my.cnf [mysqld] federated Ãß°¡
mysql> show engines ¿¡¼ È®ÀÎÇÒ°Í.
Å×ÀÌºí ¿ø°ÝÁö¿Í µ¿ÀÏÇÏ°Ô »ý¼ºÇ쵂 ¾Æ·¡ »çÇ× º¯°æ
) ENGINE=FEDERATED DEFAULT CHARSET=euckr CONNECTION='mysql://id:password@ipaddress:port/dbname/tablename';
¿ø°ÝÁö¿¡ ºä¸¦ »ý¼ºÇßÀ¸¸é ºäÀÇ ±¸Á¶¿Í µ¿ÀÏÇÏ°Ô °¡°í ¿ø°ÝÁö tablename À» ºä ¸íÀ¸·Î ) ENGINE=FEDERATED DEFAULT CHARSET=euckr CONNECTION='mysql://id:password@ipaddress:port/dbname/tablename';
# # connection Á¤º¸¸¦ create server ·Î ¿¬°á #
CREATE SERVER my_en_link FOREIGN DATA WRAPPER mysql OPTIONS ( USER 'user', PASSWORD 'password!@#$', HOST '192.168.0.1', PORT 3306, DATABASE 'my_db');
CREATE TABLE `user_en` ( `user_id` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT 'óÀ½ µÎÀÚ¸® ±¹°¡º° ÄÚµå ³ª¸ÓÁö´Â ¼øÂ÷¹øÈ£', `nickname` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '´Ð³×ÀÓ', `username` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'À¯ÀúID', `password` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `activated` INT(1) NOT NULL DEFAULT '1', `banned` TINYINT(1) NOT NULL DEFAULT '0', `ban_reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_password_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_password_requested` INT(10) DEFAULT NULL, `new_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_email_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `last_ip` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `last_login` INT(10) DEFAULT NULL, `created` INT(10) DEFAULT NULL, `modified` INT(10) DEFAULT NULL, `auth_code` INT(1) NOT NULL DEFAULT '2' COMMENT 'ÁØȸ¿ø 1, ȸ¿ø 2, ±â¾÷ȸ¿ø 4, °´¿øÄ®·³¸®½ºÆ® 3, ¿¡µðÅÍ 9, °ü¸®ÀÚ 15', `sfile_path` VARCHAR(100) DEFAULT '/default_profile.png' COMMENT 'thumbnail file path', `noti_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ' ' COMMENT 'notification email address (ȸ¿ø°¡ÀԽà ³Ö¾îÁØ´Ù.)', `new_noti_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'notification email address º¯°æ½Ã »ç¿ë.', `new_noti_email_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'notification email address º¯°æ½Ã »ç¿ë.', `az_admin_keyword_id` INT(11) DEFAULT NULL COMMENT '±â¾÷ȸ¿øÁß¿¡ Å°¿öµå °ü¸®¿ë À¯Àú. ', `profile_check` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT 'ȸ¿ø°¡ÀÔÈÄ ÇÁ·ÎÇÊ ÀÔ·ÂÀ» À§ÇÑ Çʵå, ¼¼¼ÇÀ¸·Î »ç¿ë', PRIMARY KEY (`user_id`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 COMMENT='English À¯Àú' CONNECTION='my_en_link/user';
CREATE SERVER my_jp_link FOREIGN DATA WRAPPER mysql OPTIONS ( USER 'user', PASSWORD 'password!@#$', HOST '192.168.0.2', SOCKET '/usr/local/mysql3/mysql.sock', PORT 3308, DATABASE 'db_japan');
CREATE TABLE `user_jp` ( `user_id` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT 'óÀ½ µÎÀÚ¸® ±¹°¡º° ÄÚµå ³ª¸ÓÁö´Â ¼øÂ÷¹øÈ£', `nickname` VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '´Ð³×ÀÓ', `username` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'À¯ÀúID', `password` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `activated` INT(1) NOT NULL DEFAULT '1', `banned` TINYINT(1) NOT NULL DEFAULT '0', `ban_reason` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_password_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_password_requested` INT(10) DEFAULT NULL, `new_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `new_email_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL, `last_ip` VARCHAR(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `last_login` INT(10) DEFAULT NULL, `created` INT(10) DEFAULT NULL, `modified` INT(10) DEFAULT NULL, `auth_code` INT(1) NOT NULL DEFAULT '2' COMMENT 'ÁØȸ¿ø 1, ȸ¿ø 2, ±â¾÷ȸ¿ø 4, °´¿øÄ®·³¸®½ºÆ® 3, ¿¡µðÅÍ 9, °ü¸®ÀÚ 15', `sfile_path` VARCHAR(100) DEFAULT '/default_profile.png' COMMENT 'thumbnail FILE path', `noti_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ' ' COMMENT 'notification email address (ȸ¿ø°¡ÀԽà ³Ö¾îÁØ´Ù.)', `new_noti_email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'notification email address º¯°æ½Ã »ç¿ë.', `new_noti_email_key` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'notification email address º¯°æ½Ã »ç¿ë.', `az_admin_keyword_id` INT(11) DEFAULT NULL COMMENT '±â¾÷ȸ¿øÁß¿¡ Å°¿öµå °ü¸®¿ë À¯Àú. ', `profile_check` VARCHAR(1) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '0' COMMENT 'ȸ¿ø°¡ÀÔÈÄ ÇÁ·ÎÇÊ ÀÔ·ÂÀ» À§ÇÑ Çʵå, ¼¼¼ÇÀ¸·Î »ç¿ë', PRIMARY KEY (`user_id`) ) ENGINE=FEDERATED DEFAULT CHARSET=utf8 COMMENT='Japan À¯Àú' CONNECTION='db_jp_link/user';
(SELECT *, 'us' FROM user_en) UNION ALL (SELECT *, 'jp' FROM user_jp) ORDER BY created DESC
|