* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
OS |
LINUX 64 |
CUBRID Ver. |
CUBRID 10.1
|
CUBRID TOOL Ver. |
[도움말]-[버전정보] 확인 |
응용 환경(API) |
jdbc -> cubrid shard -> mysql |
* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
에러 내용 및 재현 방법 |
재현 가능한 Source와 SQL |
관련 테이블(인덱스, 키정보 포함) 정보 |
CUBRID 홈 디렉토리 아래 log 디렉토리 압축 |
-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
안녕하세요, CUBRID SHARD를 이용해서 샤딩 미들 티어 플랫폼을 구성하려고 합니다.
poc를 위한 구조는,
jdbc -> CUBRID_SHARD -> 외부 mysql db 입니다.
설정파일을 설정하고, broker를 start하는데
Time: 12/13/17 17:37:02.251 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/communication/network_cl.c, line 3900 ERROR CODE = -191 Tran = -1, EID = 1
Cannot connect to server "my_shard" on "192.168.151.3".
Time: 12/13/17 17:37:02.251 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/transaction/boot_cl.c, line 1791 ERROR CODE = -677 Tran = -1, EID = 2
Failed to connect to database server, 'my_shard', on the following host(s): 192.168.151.3
Time: 12/13/17 17:37:04.257 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/communication/network_cl.c, line 3900 ERROR CODE = -191 Tran = -1, EID = 3
Cannot connect to server "my_shard" on "192.168.151.3".
Time: 12/13/17 17:37:04.260 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/transaction/boot_cl.c, line 1763 ERROR CODE = -677 Tran = -1, EID = 4
Failed to connect to database server, 'my_shard', on the following host(s): 192.168.151.3
Time: 12/13/17 17:37:04.260 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/transaction/boot_cl.c, line 1791 ERROR CODE = -677 Tran = -1, EID = 5
Failed to connect to database server, 'my_shard', on the following host(s): 192.168.151.3:192.168.151.3
Time: 12/13/17 17:37:06.264 - ERROR *** file /home1/build/workspace/CUBRID_10.1/cubrid/src/communication/network_cl.c, line 3900 ERROR CODE = -191 Tran = -1, EID = 6
Cannot connect to server "my_shard" on "192.168.151.3".
위처럼 설정이 잘못되었는지 start가 안되네요
구성 방식은,
=============================================================
cat cubrid_broker.conf
[broker]
MASTER_SHM_ID =30001
ADMIN_LOG_FILE =log/broker/cubrid_broker.log
[%query_editor]
SERVICE =ON
BROKER_PORT =30000
MIN_NUM_APPL_SERVER =5
MAX_NUM_APPL_SERVER =40
APPL_SERVER_SHM_ID =30000
LOG_DIR =log/broker/sql_log
ERROR_LOG_DIR =log/broker/error_log
SQL_LOG =ON
TIME_TO_KILL =120
SESSION_TIMEOUT =300
KEEP_CONNECTION =AUTO
CCI_DEFAULT_AUTOCOMMIT =ON
[%BROKER1]
SERVICE =ON
BROKER_PORT =33000
MIN_NUM_APPL_SERVER =5
MAX_NUM_APPL_SERVER =40
APPL_SERVER_SHM_ID =33000
LOG_DIR =log/broker/sql_log
ERROR_LOG_DIR =log/broker/error_log
SQL_LOG =ON
TIME_TO_KILL =120
SESSION_TIMEOUT =300
KEEP_CONNECTION =AUTO
CCI_DEFAULT_AUTOCOMMIT =ON
[%my_shard]
SERVICE =ON
BROKER_PORT =36000
MIN_NUM_APPL_SERVER =20
MAX_NUM_APPL_SERVER =40
APPL_SERVER_SHM_ID =36000
LOG_DIR =log/broker/sql_log
ERROR_LOG_DIR =log/broker/error_log
SQL_LOG =ON
TIME_TO_KILL =120
SESSION_TIMEOUT =300
KEEP_CONNECTION =ON
MAX_PREPARED_STMT_COUNT =1024
SHARD =ON
SHARD_DB_NAME =my_shard
SHARD_DB_USER =root
SHARD_DB_PASSWORD =password
SHARD_NUM_PROXY =1
SHARD_PROXY_LOG_DIR =log/broker/proxy_log
SHARD_PROXY_LOG =ERROR
SHARD_MAX_CLIENTS =256
SHARD_PROXY_SHM_ID =36090
SHARD_CONNECTION_FILE =shard_connection.txt
SHARD_KEY_FILE =shard_key.txt
=============================================================
cat cubrid_broker.conf.shard
[broker]
MASTER_SHM_ID =30001
ADMIN_LOG_FILE =log/broker/cubrid_broker.log
[%my_shard]
SERVICE =ON
BROKER_PORT =36000
MIN_NUM_APPL_SERVER =20
MAX_NUM_APPL_SERVER =40
APPL_SERVER_SHM_ID =36000
LOG_DIR =log/broker/sql_log
ERROR_LOG_DIR =log/broker/error_log
SQL_LOG =ON
TIME_TO_KILL =120
SESSION_TIMEOUT =300
KEEP_CONNECTION =ON
SHARD =ON
SHARD_DB_NAME =my_shard
SHARD_NUM_PROXY =1
SHARD_PROXY_LOG_DIR =log/broker/proxy_log
SHARD_PROXY_LOG =ERROR
SHARD_MAX_CLIENTS =256
SHARD_PROXY_SHM_ID =36090
SHARD_CONNECTION_FILE =shard_connection.txt
SHARD_KEY_FILE =shard_key.txt
=============================================================
그리고, cubrid.conf에서, cubrid_port_id=3306
로 수정하였습니다.
감사합니다.
@ cubrid broker start
cub_cas_mysql: No such file or directory
cub_cas_mysql: No such file or directory
cub_cas_mysql: No such file or directory