Skip to content

インフラ作業スレ #7

Open

Description

@tatsuru
No description provided.

Activity

  1. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    3台起動した。とりあえず1番で全部やる

    54.178.59.145 isu1
    3.114.205.229 isu2
    54.248.85.94 isu3
    
    54.178.59.145 admin.t.isucon.dev
    54.178.59.145 isucon.t.isucon.dev
    54.178.59.145 kayac.t.isucon.dev
    
  2. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    docker-compose で起動してる

  3. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor
    • c5.large 2コア、4GB。SSD 20GB
    • nginx, mysql8.0
    • 301M /var/lib/mysql/isuports/
  4. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    サーバーには初期状態で、3 台のサーバーの IP アドレスが事前に /etc/hosts へ登録されています。これらのホスト名は自由に利用して構いません。ベンチマーカーは下記のホスト名に対して接続します。

    192.168.0.11 isuports-1.t.isucon.dev
    192.168.0.12 isuports-2.t.isucon.dev
    192.168.0.13 isuports-3.t.isucon.dev

  5. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    ベンチマーク走行後の状態

    mysql> show tables;
    +--------------------+
    | Tables_in_isuports |
    +--------------------+
    | id_generator       |
    | tenant             |
    | visit_history      |
    +--------------------+
    3 rows in set (0.00 sec)
    
    mysql> select count(*) from id_generator;
    +----------+
    | count(*) |
    +----------+
    |        1 |
    +----------+
    1 row in set (0.02 sec)
    
    mysql> select count(*) from tenant;
    +----------+
    | count(*) |
    +----------+
    |      107 |
    +----------+
    1 row in set (0.04 sec)
    
    mysql> select count(*) from visit_history
        -> ;
    +----------+
    | count(*) |
    +----------+
    |  3225605 |
    +----------+
    1 row in set (2.10 sec)
    
    
  6. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    デプロイ

    • ssh-keygen して deploy key に登録
    • git clone git@github.com:tatsuru/isucon12-yosen
    • docker-compose のままでやるので systemd の working directory 書き換えて restart するだけ
  7. tatsuru commented on Jul 23, 2022

    @tatsuru
    OwnerAuthor

    go run してるな...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions