Page MenuHomePhabricator

install and puppetize memcached on dbmonitor hosts (tendril frontends)
Closed, ResolvedPublic

Description

There's a memcached installed on db1011, but it's currently not puppetised:

[14:49] <jynus> moritzm, I remember sean mentioning some kind of cache for tendril, but I am not sure if he referred to just varnish or some application-level one
[14:50] <jynus> if it is used, it may be used by neon, tendril itself (via a federated table) or maintenance on terbium

It's also currently unused:

[14:49] <volans> moritzm: interesting, STAT curr_connections 10, but no items, all counters are zero, for example: STAT curr_items 0
[14:52] <volans> yeah looks barely used at all: STAT bytes_written 1033 with STAT uptime 23708849 :)

Event Timeline

jcrespo moved this task from Triage to Backlog on the DBA board.
jcrespo subscribed.

"Low" because there is not something borken, only lack of documentation (it probably is unused).

I would say we can close this as declined or invalid as we have migrated to db1115 and we don't even have memcached installed there and as far as I know we are not even considering doing it so.

root@db1115:~# dpkg -l | grep -i mem
ii  numactl                       2.0.11-2.1                     amd64        NUMA scheduling and memory placement tool

Let's check if the frontend code depends on memcached at dbmonitor, maybe there is code failing and we don't even notice; or it maybe it was never implemented..

Memcached is expected, but on frontend, not on backend:

dbmonitor1001
$_ENV['mc_host'] = '127.0.0.1';
$_ENV['mc_port'] = 11211;
jcrespo renamed this task from memcached on db1011/tendril not puppetised to install and puppetize memcached on dbmonitor hosts (tendril frontends).Feb 25 2018, 12:37 PM

Change 414502 had a related patch set uploaded (by Jcrespo; owner: Jcrespo):
[operations/puppet@production] tendril: Add memcache to tendril web frontend

https://gerrit.wikimedia.org/r/414502

Change 414502 merged by Jcrespo:
[operations/puppet@production] tendril: Add memcache to tendril web frontend

https://gerrit.wikimedia.org/r/414502

Change 414502 merged by Jcrespo:
[operations/puppet@production] tendril: Add memcache to tendril web frontend

https://gerrit.wikimedia.org/r/414502

After merging this, this task is completed?

dbmonitor1001:~$ echo stats | nc 127.0.0.1 11211
STAT pid 459
STAT uptime 1228445
STAT time 1525870917
STAT version 1.4.21
STAT libevent 2.0.21-stable
STAT pointer_size 64
STAT rusage_user 69.316000
STAT rusage_system 107.968000
STAT curr_connections 15
STAT total_connections 284
STAT connection_structures 17
STAT reserved_fds 20
STAT cmd_get 3574958
STAT cmd_set 976289
STAT cmd_flush 0
STAT cmd_touch 0
STAT get_hits 3238303
STAT get_misses 336655
STAT delete_misses 0
STAT delete_hits 0
STAT incr_misses 0
STAT incr_hits 0
STAT decr_misses 0
STAT decr_hits 0
STAT cas_misses 0
STAT cas_hits 0
STAT cas_badval 0
STAT touch_hits 0
STAT touch_misses 0
STAT auth_cmds 0
STAT auth_errors 0
STAT bytes_read 400097398
STAT bytes_written 1832408323
STAT limit_maxbytes 67108864
STAT accepting_conns 1
STAT listen_disabled_num 0
STAT threads 4
STAT conn_yields 0
STAT hash_power_level 16
STAT hash_bytes 524288
STAT hash_is_expanding 0
STAT malloc_fails 0
STAT bytes 809234
STAT curr_items 290
STAT total_items 976289
STAT expired_unfetched 15380
STAT evicted_unfetched 0
STAT evictions 0
STAT reclaimed 219804
STAT crawler_reclaimed 0
STAT lrutail_reflocked 0
END
jcrespo claimed this task.

db1011 doesn't exist anymore.