hello,
it's now possible to connect to a database server using names of the form <database>-p.db.ts.wikimedia.org, for example:
enwiki-p.db.ts.wikimedia.org roa-rupwiki-p.db.ts.wikimedia.org
these resolve to the database server holding that database. the sql-s* aliases still work as well.
- river.
Hello,
I am becoming confused with these three sql hosts. I thought we only had zedler and the new one as sql hosts?
Clarification appreciated; thanks.
Sean
On 13/07/07, River Tarnell river@wikimedia.org wrote:
hello,
it's now possible to connect to a database server using names of the form <database>-p.db.ts.wikimedia.org, for example:
enwiki-p.db.ts.wikimedia.org roa-rupwiki-p.db.ts.wikimedia.org
these resolve to the database server holding that database. the sql-s* aliases still work as well.
- river.
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Hi,
If I understand correctly, the new names are simply aliases that point to either Zedler or Yarrow.
For example, the following all refer to the same physical server: * zedler * sql * sql-s2 * commonswiki-p.db.ts.wikimedia.org * enwiktionary-p.db.ts.wikimedia.org
As do these: * yarrow * sql-s1 * sql-s3 * enwiki-p.db.ts.wikimedia.org * jawiki-p.db.ts.wikimedia.org
It's just a case of how we refer to them in our code. (IMHO I like the new database-specific aliases)
Cheers,
Tangotango
On Jul 14, 2007, at 2:35 AM, Sean Whitton wrote:
Hello,
I am becoming confused with these three sql hosts. I thought we only had zedler and the new one as sql hosts?
Clarification appreciated; thanks.
Sean
On 13/07/07, River Tarnell river@wikimedia.org wrote:
hello,
it's now possible to connect to a database server using names of the form <database>-p.db.ts.wikimedia.org, for example:
enwiki-p.db.ts.wikimedia.org roa-rupwiki-p.db.ts.wikimedia.org
these resolve to the database server holding that database. the sql-s* aliases still work as well.
- river.-- Regards, —Sean Whitton (seanw) http://seanwhitton.com/
Yeah, the new thing looks cool. The thing I am missing is that with the sql-* aliases we have more aliases than servers, which seems kinda pointless.
On 13/07/07, Tangotango tangotango.wp@gmail.com wrote:
Hi,
If I understand correctly, the new names are simply aliases that point to either Zedler or Yarrow.
For example, the following all refer to the same physical server:
- zedler
- sql
- sql-s2
- commonswiki-p.db.ts.wikimedia.org
- enwiktionary-p.db.ts.wikimedia.org
As do these:
- yarrow
- sql-s1
- sql-s3
- enwiki-p.db.ts.wikimedia.org
- jawiki-p.db.ts.wikimedia.org
It's just a case of how we refer to them in our code. (IMHO I like the new database-specific aliases)
Cheers,
Tangotango
On Jul 14, 2007, at 2:35 AM, Sean Whitton wrote:
Hello,
I am becoming confused with these three sql hosts. I thought we only had zedler and the new one as sql hosts?
Clarification appreciated; thanks.
Sean
On 13/07/07, River Tarnell river@wikimedia.org wrote:
hello,
it's now possible to connect to a database server using names of the form <database>-p.db.ts.wikimedia.org, for example:
enwiki-p.db.ts.wikimedia.org roa-rupwiki-p.db.ts.wikimedia.org
these resolve to the database server holding that database. the sql-s* aliases still work as well.
- river.-- Regards, —Sean Whitton (seanw) http://seanwhitton.com/
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
Sean Whitton:
Yeah, the new thing looks cool. The thing I am missing is that with the sql-* aliases we have more aliases than servers, which seems kinda pointless.
this is because these sets are decided by the database layout at Wikimedia's cluster, not us. Wikimedia has three separate master/slave groups, s1, s2, and s3 (there's also s2a and s3a, but those don't matter to us).
we don't need that much capacity, so s1 and s3 are both on yarrow. but, if you use sql-s1 and sql-s3 properly, your code will still work if we add a third server in future.
- river.
Ah great, that makes a lot of sense. Thanks for the clarification.
On 14/07/07, River Tarnell river@wikimedia.org wrote:
Sean Whitton:
Yeah, the new thing looks cool. The thing I am missing is that with the sql-* aliases we have more aliases than servers, which seems kinda pointless.
this is because these sets are decided by the database layout at Wikimedia's cluster, not us. Wikimedia has three separate master/slave groups, s1, s2, and s3 (there's also s2a and s3a, but those don't matter to us).
we don't need that much capacity, so s1 and s3 are both on yarrow. but, if you use sql-s1 and sql-s3 properly, your code will still work if we add a third server in future.
- river.
Toolserver-l mailing list Toolserver-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/toolserver-l
toolserver-l@lists.wikimedia.org