수면제가 필요해요...

테스트 환경

OS - windows7

노트북-A(211.xxx.xxx.101) 

노트북-B(211.xxx.xxx.102) 

노트북-A

 - 노드 시작

  : werl -name a@211.xxx.xxx.101 -setcookie abc

(a@11.xxx.xxx.101)1> kvs:start().

노트북-B

 - 노드 시작

  : werl -name b@211.xxx.xxx.102 -setcookie abc

 (b@11.xxx.xxx.102)2> net_kernel:connect('a@211.232.21.50').

 - 추신 : 노드 이름은 Name@Host 형태이고, Name과 Host는 모두 Atom이다. 만약 Atom이 아닌 문자가 들어 있는 경우에는 인용 부호('')로 감싸야 할 것이다.  (출처 - 프로그래밍얼랭/인사이트) 

<join>

    <multicast enabled="true">

        <multicast-group>224.2.2.3</multicast-group>

        <multicast-port>54327</multicast-port>

    </multicast>

    <tcp-ip enabled="false">

        <interface>xxx.xxx.xxx.xxx</interface> 

    </tcp-ip>

    ....

<join>

<interfaces enabled="true">

    <interface>xxx.xxx.xxx.xxx</interface>

    <interface>xxx.xxx.xxx.xxx</interface>

</interfaces>

Main class : io.vertx.core.Starter

Arguments : run platform.vertx.EchoServer -cluster -cluster-host xxx.xxx.xxx.xxx

-cluster-host는 해당 서버 아이피 (중요)

Erlang

 - Functional Programming Language이며, 동시성/높은 신뢰성을 갖춘 서버 개발 환경으로 이해하면 무난할 듯 싶다.

OTP 란?

- Open Telecom Platform (OTP)으로, 표준라이브러리및 각종 도구의 모음으로 생각하며 됨. 

..........

<build>

<plugins>

<plugin>

<groupId>org.jboss.as.plugins</groupId>

<artifactId>jboss-as-maven-plugin</artifactId>

<version>7.4.Final</version>

<executions>

<execution>

<id>test_id</id>

<phase>install</phase>

<goals>

<goal>deploy</goal>

</goals>

<configuration>

<force>true</force>

<hostname>127.0.0.1</hostname>

<port>9999</port>

<username>username</username>

<password>pwssword</password>

</configuration>

</execution>

</executions>

</plugin>

..........

clean install

.....

                 <plugin>

    <groupId>org.codehaus.mojo</groupId>

       <artifactId>cobertura-maven-plugin</artifactId>

       <version>2.6</version>

   </plugin>

</plugins>

    </reporting>

...

             <plugin>

          <groupId>org.codehaus.mojo</groupId>

          <artifactId>cobertura-maven-plugin</artifactId>

          <version>2.6</version>

          <configuration>

                          <formats>

          <foramt>html</foramt>

          <foramt>xml</foramt>

          </formats>

          <instrumentation>

        <ignores>

                  <ignore>platform.web.common.*</ignore>

             </ignores>

             <excludes>

              <exclude>platform/web/common/**</exclude>

             </excludes>

        </instrumentation>

       </configuration>

        </plugin>

    </plugins>

</build>

clean site:site cobertura:cobertura

..........

<reporting>

<plugins>

<plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-pmd-plugin</artifactId>

<version>3.3</version>

<configuration>

<format>xml</format>

<minimumTokens>100</minimumTokens>

<targetJdk>1.6</targetJdk>

<linkXref>true</linkXref>

<sourceEncoding>UTF-8</sourceEncoding>

<rulesets>

<ruleset>file:///${project.basedir}/bms-pmd-ruleset.xml</ruleset>

</rulesets>

<excludes>

<exclude>platform/web/common/**</exclude>

</excludes>

<excludeRoots>

<excludeRoot>target/generated-sources/*</excludeRoot>

</excludeRoots>

</configuration>

<reportSets>

<reportSet>

<reports>

<report>pmd</report>

</reports>

</reportSet>

</reportSets>

</plugin>

<plugin>

<groupId>org.apache.maven.plugins</groupId>

<artifactId>maven-jxr-plugin</artifactId>

<version>2.5</version>

</plugin>

</plugins>

</reporting>

..........

clean site:site

-- $1 : lat (기준점:위도)

-- $2 : lng  (기준점:경도)

-- $3: lat (target : 위도)

-- $4 : lng (target : 경도)

create function fn_geo_distance(double precision, double precision, double precision, double precision) returns double precision as $$

select 

( 

   ( 

(

   acos(

   sin( $1 * PI() /180.0 ) * 

   sin( $3 * PI() /180.0 ) + 

   cos( $1 * PI() /180.0 )  * 

   cos( $3 * PI() /180.0 ) * 

   cos( ($2 - $4) * PI() /180.0  ) 

   ) 

) *  180.0 / PI() 

   ) * 60*1.1515*1.609344*1000 

)

$$ LANGUAGE SQL;

select fn_geo_distance(37.51084072964695, 127.01951086521149, cast(lat as double precision), cast(lng as double precision)) as distance

우분투

 : http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21UbuntuPGSQL93Apt

CentOS

 :  http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS21CentOS6pgdg

CREATE TABLE tb_poi

(

    idx INTEGER not null,

    gps geometry, 

    CONSTRAINT pk_poi PRIMARY KEY (idx)

)

WITH (

    OIDS=FALSE

);

WGS84:4326 좌표계로 거리 계산이 안되기 때문에 EPSG:2097 좌표계로 변환하여 데이터 입력함

- geometry : WGS84 좌표계 (경도/위도)

    : ST_GeomFromText('POINT(127.01763868331909 37.508993923524145)', 4326)

- geometry : WGS84 좌표계 -> EPSG 좌표계 변환

    : ST_Transform(ST_GeomFromText('POINT(127.01763868331909 37.508993923524145)', 4326), 2097)

INSERT INTO tb_poi(idx, gps) VALUES (1, ST_Transform(ST_GeomFromText('POINT(127.01763868331909 37.508993923524145)', 4326), 2097));

WGS84:4326 좌표계를 EPSG:2097 좌표계로 변환하여 반경검색 

 - 미터기준

SELECT *  -- 100미터 반경 검색에 포함된 POI 조회

FROM tb_poi

WHERE 

    ST_DWithin(gps, ST_Transform(ST_GeomFromText('POINT(127.01937675476074 37.50916413798163)', 4326), 2097), 100);