Home » Forum Home » Development

Topic: database relocation
Replies: 23   Views: 53,864   Pages: 2   Last Post: Jan 2, 2022, 4:25 PM by: rainwolf

Search Forum

Back to Topic List
Replies: 23   Views: 53,864   Pages: 2   [ Previous | 1 2 ]
rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 27, 2020, 9:22 AM

It should be a ton better now, give it a try.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 30, 2020, 6:51 AM

I'm going to move the database server back one of these weekends, the old server was a lot closer to pente.org while the newer/stronger server is halfway across the world.
The search does not appear super slow anymore, but not fast either, I'm hoping moving the server back will alleviate that. I now believe the queries suffered mostly from network traffic, rather than the lack of computing power, and I've reduced the network traffic to a minimum now.

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Oct 1, 2020, 2:18 AM

Done, it looks okay to me now, what about for you?

madmike

Posts: 133
Registered: May 27, 2014
From: Saltillo, Mexico
Age: 67
Re: database relocation
Posted: Oct 13, 2020, 4:00 PM

I've taken a few days, and used different machines from different locations. Even different parts of the state.

I does seem better most of the time. there is still an occasional delay with results but they are rare and the delay is not very long.

Thanks for you efforts!!!!!

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Oct 15, 2020, 2:11 AM

Thank you for the kind words, and all the testing. I decided to keep the database on the more remote machine because that one has an extra core which offsets the network delay most of the time.

There's one more speedup I want to try out once I find some time to implement it.

mmammel

Posts: 260
Registered: Dec 16, 2001
From: Maryland
Age: 53
Home page
Re: database relocation
Posted: Sep 22, 2021, 1:50 AM

Hi Rainwolf,
I forget if I asked about this before, but is it possible for me to download a copy of the database for a machine learning project?
Thanks,
Mark

rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Sep 22, 2021, 4:55 AM

can you email me at rainwolf@submanifold.be ?

watsu

Posts: 1,442
Registered: Dec 16, 2001
Home page
Re: database relocation
Posted: Jan 2, 2022, 2:41 PM

The database and players' profiles don't seem to have any completed games after December 8th. Is this related to database relocation, or is it a different issue?

Retired from TB Pente, but still playing live games & exploring variants like D, poof and boat
rainwolf

Posts: 753
Registered: Apr 12, 2008
From: Singapore
Age: 44
Home page
Re: database relocation
Posted: Jan 2, 2022, 4:25 PM

There was a corruption regarding replication (the DB database is hosted elsewhere), that's fixed now, thank you for reporting this.

Replies: 23   Views: 53,864   Pages: 2   [ Previous | 1 2 ]
Back to Topic List


Powered by Jive Software