A new version of the /usr/bin/sql helper script has been deployed
today. This version of the script adds an optional "--cluster
{analytics,web,labsdb}" cli argument that you can use to choose
between the various Wiki Replica servers. The default is the
equivalent of "--cluster labsdb" which connects you to the old servers
with no changes.If you are not using /usr/bin/sql to query user created tables on c1.labsdb or c3.labsdb, try "sql --cluster analytics DATABASE". This will become the default when the old database cluster is retired in a few months. Not sure what this is all about? Read the blog post on the new Wiki Replica servers: <https://phabricator.wikimedia.org/phame/post/view/70/new_wiki_replica_servers_ready_for_use/> Magnus gave the new servers this glowing review [0]: > Hooray! I have switched most of my tools over, taking care to put > long-running queries (including PetScan queries) on the analytics > server. Initial tests see a ~5x improvement in query time! [0]: https://lists.wikimedia.org/pipermail/labs-l/2017-September/005077.html Bryan -- Bryan Davis Wikimedia Foundation <[email protected]> [[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA irc: bd808 v:415.839.6885 x6855 _______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
