본문 바로가기

전체 글

MySQL ndbcluster & Replicator 설정 - help text [Mysql NDB Cluster 설정] - 5.1.44-ndb-7.1.4b 1. 소스 다운로드 http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.1/mysql-cluster-gpl-7.1.4b.tar.gz/from/http://mirror.khlug.org/mysql/ 2. 압축 해제, 설치 (필수 패키지: curses*, termcap, gcc-c++) # ./configure --prefix=/user/service/mysql --with-mysqld-user=mysql --sysconfdir=/user/service/mysql/conf --with-unix-socket-path=/tmp/mysqld/mysql.sock --with-charset=utf8 -.. 더보기
MySQL 5.5.4m3 Source build & Installation on OpenSUSE 11.2 1. Source 다운로드, 압축해제 다운로드 http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.4-m3.tar.gz/from/http://mirror.khlug.org/mysql/ # tar xvzf mysql-5.5.4-m3.tar.gz 2. mysql 사용자 추가 # groupadd mysql # useradd -M -g mysql -s /bin/false mysql 3. Configure Makefile * ForMysqlBaseDir : /usr/local/ or /dev/local/service/, etc... # rm -rf /ForMysqlBaseDir # ./configure --prefix=/ForMysqlBaseDir/mysql --wi.. 더보기
MySQL, Hex와 Conv로 Mac address 계산하기 SET @mac := '00afafafafaf'; -- ==> '00afafafafb0' 로 주소 값을 1증가 시키려고 한다 CONV(@mac, 16, 10) + 1; -- 12자리 mac address string을 BigInt 정수로 변환하여 +1 HEX(정수); -- 정수값을 hexadecimal string으로 변환 LPAD(string, digits, '0'); digits자리수 만큼 왼쪽에 '0'을 채운다 -- 결과 SELECT LPAD(HEX(CONV(@mac, 16, 10)+1), 12, '0'); SELECT INET_ATON( '168.126.63.1') = 2826845953 -- BigInt SELECT INET_NTOA( 2826845953 ) = '168.126.63.1' 더보기
Setting up Xen Dom0 kernel 2.6.31.12 on OpenSuse 11.2 Setting up Xen Dom0 kernel 2.6.31.13 on OpenSuse 11.2 * Installation methods are as follows (1) Binary tarball from xensource.com(xen-3.x.x-install.tgz) (2) RPM download and install (3) Online Package installation by zypper or yast or yast2(software installation) (4) From source - Xen source(make dist-xen,...) / Kernel source+patch(Patch & make modules_install & modifying grub) - Xen source / Cu.. 더보기

티스토리툴바