[Labs-l] Removal of SQL servers on wikimedia labs bots project
Petr Bena
benapetr at gmail.com
Tue Sep 10 16:10:42 UTC 2013
ONLY 6 DAYS REMAINING
processes on bots-sql2:
mysql> show processlist;
+-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+
| Id | User | Host | db
| Command | Time | State | Info |
+-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+
| 23537 | coibot | tools-exec-06.pmtpa.wmflabs:52622 | coibot
| Sleep | 21134 | | NULL |
| 23545 | coibot | tools-exec-06.pmtpa.wmflabs:52644 | coibot
| Sleep | 19897 | | NULL |
| 23546 | coibot | tools-exec-06.pmtpa.wmflabs:52647 | coibot
| Sleep | 20051 | | NULL |
| 23547 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52650 |
linkwatcher | Sleep | 19897 | | NULL |
| 23548 | coibot | tools-exec-06.pmtpa.wmflabs:52652 | coibot
| Sleep | 19487 | | NULL |
| 23549 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52656 |
linkwatcher | Sleep | 20051 | | NULL |
| 23550 | coibot | tools-exec-06.pmtpa.wmflabs:52658 | coibot
| Sleep | 20102 | | NULL |
| 23551 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52661 |
linkwatcher | Sleep | 19487 | | NULL |
| 23552 | coibot | tools-exec-06.pmtpa.wmflabs:52663 | coibot
| Sleep | 19396 | | NULL |
| 23553 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52666 |
linkwatcher | Sleep | 20102 | | NULL |
| 23554 | coibot | tools-exec-06.pmtpa.wmflabs:52668 | coibot
| Sleep | 19580 | | NULL |
| 23555 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52671 |
linkwatcher | Sleep | 19396 | | NULL |
| 23556 | coibot | tools-exec-06.pmtpa.wmflabs:52673 | coibot
| Sleep | 18816 | | NULL |
| 23557 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52678 |
linkwatcher | Sleep | 19580 | | NULL |
| 23558 | coibot | tools-exec-06.pmtpa.wmflabs:52680 | coibot
| Sleep | 20048 | | NULL |
| 23559 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52684 |
linkwatcher | Sleep | 18816 | | NULL |
| 23561 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52690 |
linkwatcher | Sleep | 20048 | | NULL |
| 23562 | coibot | tools-exec-06.pmtpa.wmflabs:52693 | coibot
| Sleep | 19345 | | NULL |
| 23564 | linkwatcher | tools-exec-06.pmtpa.wmflabs:52698 |
linkwatcher | Sleep | 19345 | | NULL |
| 23667 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54773 | coibot
| Sleep | 21090 | | NULL |
| 23668 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54774 |
linkwatcher | Sleep | 20767 | | NULL |
| 23669 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54789 | coibot
| Sleep | 21397 | | NULL |
| 23670 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54790 |
linkwatcher | Sleep | 20761 | | NULL |
| 23671 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54796 | coibot
| Sleep | 22681 | | NULL |
| 23672 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54797 |
linkwatcher | Sleep | 22299 | | NULL |
| 23673 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54810 | coibot
| Sleep | 21420 | | NULL |
| 23674 | linkwatcher | tools-exec-05.pmtpa.wmflabs:54811 |
linkwatcher | Sleep | 20782 | | NULL |
| 23687 | linkwatcher | tools-exec-05.pmtpa.wmflabs:57274 |
linkwatcher | Sleep | 29364 | | NULL |
| 23690 | linkwatcher | tools-exec-05.pmtpa.wmflabs:44701 |
linkwatcher | Sleep | 28487 | | NULL |
| 23691 | linkwatcher | tools-exec-05.pmtpa.wmflabs:48871 |
linkwatcher | Sleep | 28257 | | NULL |
| 23692 | linkwatcher | tools-exec-05.pmtpa.wmflabs:51350 |
linkwatcher | Sleep | 28116 | | NULL |
| 23693 | linkwatcher | tools-exec-05.pmtpa.wmflabs:52552 |
linkwatcher | Sleep | 28050 | | NULL |
| 23694 | linkwatcher | tools-exec-05.pmtpa.wmflabs:58375 |
linkwatcher | Sleep | 27711 | | NULL |
| 23695 | linkwatcher | tools-exec-05.pmtpa.wmflabs:33968 |
linkwatcher | Sleep | 27478 | | NULL |
| 23697 | linkwatcher | tools-exec-05.pmtpa.wmflabs:42745 |
linkwatcher | Sleep | 26950 | | NULL |
| 23698 | linkwatcher | tools-exec-05.pmtpa.wmflabs:43143 |
linkwatcher | Sleep | 26927 | | NULL |
| 23699 | linkwatcher | tools-exec-05.pmtpa.wmflabs:45382 |
linkwatcher | Sleep | 26823 | | NULL |
| 23700 | linkwatcher | tools-exec-05.pmtpa.wmflabs:52604 |
linkwatcher | Sleep | 26453 | | NULL |
| 23703 | linkwatcher | tools-exec-05.pmtpa.wmflabs:33012 |
linkwatcher | Sleep | 25989 | | NULL |
| 23704 | linkwatcher | tools-exec-05.pmtpa.wmflabs:38863 |
linkwatcher | Sleep | 25693 | | NULL |
| 23705 | linkwatcher | tools-exec-05.pmtpa.wmflabs:60331 |
linkwatcher | Sleep | 24630 | | NULL |
| 23706 | linkwatcher | tools-exec-05.pmtpa.wmflabs:34778 |
linkwatcher | Sleep | 24498 | | NULL |
| 23707 | linkwatcher | tools-exec-01.pmtpa.wmflabs:55333 |
linkwatcher | Sleep | 21018 | | NULL |
| 23708 | linkwatcher | tools-exec-05.pmtpa.wmflabs:53609 |
linkwatcher | Sleep | 23514 | | NULL |
| 23709 | linkwatcher | tools-exec-01.pmtpa.wmflabs:55701 |
linkwatcher | Sleep | 17618 | | NULL |
| 23710 | linkwatcher | tools-exec-01.pmtpa.wmflabs:57685 |
linkwatcher | Sleep | 17996 | | NULL |
| 23711 | coibot | tools-exec-06.pmtpa.wmflabs:33449 | coibot
| Sleep | 21134 | | NULL |
| 23712 | linkwatcher | tools-exec-06.pmtpa.wmflabs:33457 |
linkwatcher | Sleep | 21052 | | NULL |
| 23713 | coibot | tools-exec-06.pmtpa.wmflabs:36269 |
linkwatcher | Sleep | 20866 | | NULL |
| 23714 | root | localhost | NULL
| Query | 0 | NULL | show processlist |
+-------+-------------+-----------------------------------+-------------+---------+-------+-------+------------------+
On Sat, Sep 7, 2013 at 11:45 AM, Petr Bena <benapetr at gmail.com> wrote:
> Hi,
>
> It has been several times announced that we deprecated the bots
> project and now it is finally time to get rid of most resource
> expensive instances, which are the database instaces.
>
> There are 2 sql servers with hostnames:
>
> bots-sql2
> bots-bsql01
>
> Both of these servers are active and currently being used by a number
> of services (bots, including ClueBot).
>
> Please migrate the databases to tools project ASAP. If you need any
> assistance with this, please let me or Coren know.
>
> I would like to schedule a removal of these servers soon, preferably
> in 2 weeks (Tuesday 24, Sep).
>
> If there is anyone who can't migrate the database until then, please
> let me know so that we can postpone this removal.
>
> So as of now, the both servers are going to be shut down at Monday 16,
> Sep and permanently deleted (the contents will be backed up) at
> Tuesday 24, Sep.
>
> If you need more time, no problem, but please let me know :-)
>
> Thank you
More information about the Labs-l
mailing list