Hello all,
as most of you know, sql.toolserver.org (short: sql) is the place where you should store your user-database if you need no joining with wmf-databases. sql points to adenia at the moment. Adenia is quite busy from time to time and sooner or later it will become overloaded. My plan is to not just buy a bigger box than, but to buy another box and split sql (so some databases will be on the old box and some will be on the new box). The problem is that this is not possible with our current setup, where we have only sql.toolserver.org – we can not configure it as round-robin because in 50% of time you would miss your database. The solution is simple, but it needs a little help from your side. I created new DNS-names in the form of "sql-user-X" where X is a letter ("sql-user-a" for example). The idea is now that you use not longer "sql", but "sql-user-X" where "X" is the first letter of your user-name (so the user "erik" use "sql- user-e" and the user "snowolf" use "sql-user-s"). If you all do this, it will be simple for the roots to move user-databases away from adenia to another server (for example we could move databases from "u_m*" till "u_z*" to the new box and nothing would break). I know that many of you need some time to update your tools. That's the reason I announce that now where you have plenty of time to update your stuff. At the moment sql-user-X points to adenia so nothing will break if you update now.
Please send questions to the mailing-list. I will update the wiki-pages soon.
Sincerely, DaB.
What about adding user entries to the "switchserver table"? Currently, if you want to access an arbitrary wiki table, you need to look it up first in toolserver.wiki. Seems appropiate to extend that to user databases. Frameworks setting db connections would need little changes to also handle user dbs like they do with wmf views. (I'd actually put it into a new table eg. toolserver.databases, but changing the db name used in the framework at the same time -keeping wiki for other uses, of course- should be trivial)
Regards
On 7 September 2012 14:39, DaB. WP@daniel.baur4.info wrote:
I created new DNS-names in the form of "sql-user-X" where X is a letter ("sql-user-a" for example). The idea is now that you use not longer "sql", but "sql-user-X" where "X" is the first letter of your user-name (so the user "erik" use "sql- user-e" and the user "snowolf" use "sql-user-s"). [..] (for example we could move databases from "u_m*" till "u_z*" to the new box and nothing would break).
Does this apply for multi-maintainer projects too? Would the database p_acc_something fit under sql-user-a, even though it's p_a* and not u_a* ?
Thanks,
Simon
Hello, At Monday 10 September 2012 22:27:45 DaB. wrote:
Does this apply for multi-maintainer projects too? Would the database p_acc_something fit under sql-user-a, even though it's p_a* and not u_a* ?
yes, sql-user-a.
Sincerely, DaB.
toolserver-l@lists.wikimedia.org