-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
hi,
we are now backing up user databases (u_%) on all three database servers. this means the data will be restored if the server fails, or we move to another server. additionally, the backups are now copied to an off-site server, making data loss less likely.
please take a moment to look at your user databases, and drop any that you no longer need; these databases use a lot of space both on the SQL servers, and on the backup server.
- river.
Il giorno 06/mar/09, alle ore 12:27, River Tarnell ha scritto:
hi,
we are now backing up user databases (u_%) on all three database servers. this means the data will be restored if the server fails, or we move to another server. additionally, the backups are now copied to an off-site server, making data loss less likely.
That's good.
please take a moment to look at your user databases, and drop any that you no longer need; these databases use a lot of space both on the SQL servers, and on the backup server.
Can you please drop my u_pietrodn and u_pietrodn_yarrow databases? I can't do it (I can't find the delete button). Additionally, where is the main server where user databases are stored? Are they replicated on all three DB servers? And what's the difference between sql-s1, s2, s3 and rosemary, zedler, yarrow?
Regards
Pietrodn powerpdn@gmail.com
Can you please drop my u_pietrodn and u_pietrodn_yarrow databases? I can't do it (I can't find the delete button).
Not sure how to do it in phpmyadmin. It should be easy enough to delete each table, though.
Additionally, where is the main server where user databases are stored? Are they replicated on all three DB servers?
Thy are not replicated. And there is no longer main server, I think. You have (or can create) a user db on each server, as need be.
And what's the difference between sql-s1, s2, s3 and rosemary, zedler, yarrow?
sql-s1, sql-s2 and sql-s3 are aliases for rosemary, zedler, and yarrow, respectively. It's better to use the aliases in your configuration and scripts, since the refer to the roles/functions: sql-s1 replicates the s1-cluser, which contains the english wikipedia. sql-s2 replicates the s2-cluster, which contains the german wikipedia and a dozen or so other biggish wikis. s3 is for the rest.
s1 and and s3 used to both point to yarrow. Now s1 is on rosemary. In time, some of the servers may get replaces, and we will see different names there, but the aliases sql-s1, sql-s2 and sql-s3 will remain stable. The same is true for login and www: login.toolserver.org is nightshade and www.toolserver.org is wolfsbane (but used to be hemlock). So, please stick with the generic names.
-- daniel
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Daniel Kinzler:
Thy are not replicated. And there is no longer main server, I think. You have (or can create) a user db on each server, as need be.
well, there is a main *alias* for user databases: "sql". but this will usually be the same as either sql-s1, sql-s2 or sql-s3.
- river.
On Sat, Mar 7, 2009 at 4:24 AM, Pietrodn powerpdn@gmail.com wrote:
Can you please drop my u_pietrodn and u_pietrodn_yarrow databases? I can't do it (I can't find the delete button).
Type: sql u_pietrodn drop database u_pietrodn; drop database u_pietrodn_yarrow;
If you can't figure this out please write to ts-admins.
Please write to ts-admins so that we can confirm
Additionally, where is the main server where user databases are stored? Are they replicated on all three DB servers?
They're on Zedler.
And what's the difference between sql-s1, s2, s3 and rosemary, zedler, yarrow?
sql-s1, 2, and 3 are aliases for whichever server hosts s1, s2 and s3 respectively. Currently, sql-s1 --> rosemary, sql-s2 --> rosemary, sql-s3 --> yarrow, according to dns.
Rosemary, Yarrow and Zedler are the actual server names.
Il giorno 07/mar/09, alle ore 13:53, Andrew Garrett ha scritto:
On Sat, Mar 7, 2009 at 4:24 AM, Pietrodn powerpdn@gmail.com wrote:
Can you please drop my u_pietrodn and u_pietrodn_yarrow databases? I can't do it (I can't find the delete button).
Type: sql u_pietrodn drop database u_pietrodn; drop database u_pietrodn_yarrow;
Thank you, done. (Why can't I do it via PMA?)
If you can't figure this out please write to ts-admins.
Please write to ts-admins so that we can confirm
Additionally, where is the main server where user databases are stored? Are they replicated on all three DB servers?
They're on Zedler.
And what's the difference between sql-s1, s2, s3 and rosemary, zedler, yarrow?
sql-s1, 2, and 3 are aliases for whichever server hosts s1, s2 and s3 respectively. Currently, sql-s1 --> rosemary, sql-s2 --> rosemary, sql-s3 --> yarrow, according to dns.
Rosemary, Yarrow and Zedler are the actual server names.
Thank you (and Daniel Kinzler) for the information.
Regards.
Pietrodn powerpdn@gmail.com
toolserver-l@lists.wikimedia.org