[05:59:54] <snitch>	 [[Tech]]; Liambrunt; /* Is it really possible to create a MAC address for the system? */ new section; https://meta.wikimedia.org/w/index.php?diff=23027140&oldid=23018601&rcid=22991481
[12:07:03] <snitch>	 [[Tech]]; Reedy; Undo revision 23027140 by [[Special:Contributions/Liambrunt|Liambrunt]] ([[User talk:Liambrunt|talk]]); https://meta.wikimedia.org/w/index.php?diff=23028270&oldid=23027270&rcid=22993327
[12:54:25] <cdx>	 I'd like to access Wikipedia's read only replica via my MySQL client. I'm not sure how I could do so, hosts, user/passphrases to use and stuff. I wanted to query `enwiki_p` read only replica without using Quarry.
[12:54:41] <cdx>	 Could someone tell me how I can do that?
[13:04:43] <cdx>	 (seems like https://www.mediawiki.org/wiki/Manual:Database_access wasn't helpful) 
[13:38:52] <urbanecm>	 hello cdx, the replica DBs aren't accessible worldwide. You need "something" to get to them. There are basically three options: a) Quarry b) PAWS c) Toolforge
[13:39:09] <urbanecm>	 you said you don't want quarry, so there's not much to be said about it
[13:42:22] <urbanecm>	 PAWS is a https://jupyter.org/ deployment accessible via https://paws.wmcloud.org. You can run a terminal there and access the hosts from there (credentials are in ~/.my.cnf; host is `wiki.analytics.db.svc.wikimedia.cloud`, where wiki is the queried wiki, ie. enwiki). You'd need to still run your code remotely though, but with more freedom than Quarry offers (you can, for instance, write a script running the queries for you).
[13:43:34] <urbanecm>	 Toolforge is described https://wikitech.wikimedia.org/wiki/Portal:Toolforge. Once you get access there (it needs to be approved by the admins), you can set up a SSH tunnel between the replica host and your computer, and use whatever tooling you have available locally
[13:44:23] <urbanecm>	 an example how that can work is at https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#Connecting_with...
[14:11:17] <snitch>	 [[Tech]]; Mohammad.iqbal.mughal; /* my.name.is.mohammad.iqbal.mughal. */ new section; https://meta.wikimedia.org/w/index.php?diff=23029052&oldid=23028270&rcid=22994624
[14:19:03] <snitch>	 [[Tech]]; AntiCompositeNumber; Reverted changes by [[Special:Contributions/Mohammad.iqbal.mughal|Mohammad.iqbal.mughal]] ([[User talk:Mohammad.iqbal.mughal|talk]]) to last version by Reedy; https://meta.wikimedia.org/w/index.php?diff=23029119&oldid=23029052&rcid=22994741