| 前のトピックへ :: 次のトピックへ |
| 作成者 |
メッセージ |
ludoo
 登録日: 2009年9月18日 投稿: 1397 所在地: Milan, Italy
Expire: 2011-12-05
|
 投稿日時: 木 11月 04, 2010 6:20 pm 件名: |
|
 投稿日時: 木 11月 04, 2010 6:20 pm 件名: |
|
|
ludoo wrote:
If the gallery is accessible via HTTP (as it shoud), I can write a trivial script to download all the images in their proper place. Or use wget and its mirror option if the folder hierarchy is sensible. _________________ My galleries
Digital: Samsung EX-1
Past Digital: Samsung NX10, Sigma SD9, Sigma SD10, SD14, DP2, Pentax *istD, Kx, Fuji S2 Pro, Canon 5D
Analog: packfilm Polaroids, 6x9 Kodak folders, Pentacon Taxona half-frame, Fujica ST605n, Walz Envoy, Olympus 35 S-II, Olympus Wide S
Past Analog: Polaroid 600se, Polaroid 110B, Canon IIF, various fixed-lens and Russian rangefinders, ...
Past Lenses: Nikkor 24/2.8, Nikkor SC 50/1.4, Nikkor 50/2, Nikkor H 85/1.8, Nikkor P 105/2.5, Nikkor Q 135/3.5, Fujinon 100/2.8, Fujinon EBC 100/2.8, Fujinon EBC 135/3.5, Fujinon EBC 200/4.5, Mamiya SX 135/2.8, CZJ Flektogon 35/2.4, CZJ Pancolar 50/1.8 zebra, CZJ Sonnar 135/3.5, ...
altroformato
|
|
| トップへ戻る |
|
 |
ylyad
 登録日: 2010年6月1日 投稿: 476 所在地: Zentralschweiz
Expire: 2013-12-05
|
 投稿日時: 木 11月 04, 2010 8:01 pm 件名: |
|
 投稿日時: 木 11月 04, 2010 8:01 pm 件名: |
|
|
ylyad wrote:
In my knowledge (I'm working in the IT, implementing and running applications, mainly web), hardware can be an issue - and I second ludoo when he says that a forum like this one requires a dedicated server.
But I've seen too much performance issues linked to software (i.e. the application, both the standard and the specific additions) and non-optimized databases to close that path. And in particular, phpBB is not famous for being the most performant forum framework, to say the least... _________________
Camera: Fuji X-E2, Fuji X100T
MF: Canon nFD 50/1.4, Canon nFD 100/2.8, Tokina RMC 135/2.8
Tamron SP 24-48/3.5-3.8
http://www.flickr.com/derdide/
|
|
| トップへ戻る |
|
 |
ludoo
 登録日: 2009年9月18日 投稿: 1397 所在地: Milan, Italy
Expire: 2011-12-05
|
 投稿日時: 木 11月 04, 2010 8:27 pm 件名: |
|
 投稿日時: 木 11月 04, 2010 8:27 pm 件名: |
|
|
ludoo wrote:
| ylyad 氏の書き込み: |
| But I've seen too much performance issues linked to software (i.e. the application, both the standard and the specific additions) and non-optimized databases to close that path. And in particular, phpBB is not famous for being the most performant forum framework, to say the least... |
Exactly. And serious load on the database means two things: RAM up to a certain table size, if your queries are well executed and don't use filesort and large temporary tables; and IO in all other situations. Two things that you never get in decent amounts with virtual servers.
After a certain size, and I think mflenses has passed that threshold a while ago, you need one or more dedicated servers and some serious tuning. Or Amazon EC2, which is much more expensive. _________________ My galleries
Digital: Samsung EX-1
Past Digital: Samsung NX10, Sigma SD9, Sigma SD10, SD14, DP2, Pentax *istD, Kx, Fuji S2 Pro, Canon 5D
Analog: packfilm Polaroids, 6x9 Kodak folders, Pentacon Taxona half-frame, Fujica ST605n, Walz Envoy, Olympus 35 S-II, Olympus Wide S
Past Analog: Polaroid 600se, Polaroid 110B, Canon IIF, various fixed-lens and Russian rangefinders, ...
Past Lenses: Nikkor 24/2.8, Nikkor SC 50/1.4, Nikkor 50/2, Nikkor H 85/1.8, Nikkor P 105/2.5, Nikkor Q 135/3.5, Fujinon 100/2.8, Fujinon EBC 100/2.8, Fujinon EBC 135/3.5, Fujinon EBC 200/4.5, Mamiya SX 135/2.8, CZJ Flektogon 35/2.4, CZJ Pancolar 50/1.8 zebra, CZJ Sonnar 135/3.5, ...
altroformato
|
|
| トップへ戻る |
|
 |
Nikos
 登録日: 2010年5月17日 投稿: 1077 所在地: Greece
Expire: 2015-01-02
|
 投稿日時: 木 11月 04, 2010 8:33 pm 件名: |
|
 投稿日時: 木 11月 04, 2010 8:33 pm 件名: |
|
|
Nikos wrote:
| ludoo 氏の書き込み: |
| If the gallery is accessible via HTTP (as it shoud), I can write a trivial script to download all the images in their proper place. Or use wget and its mirror option if the folder hierarchy is sensible. |
wget is not a good option for dynamic sites. This solution would also be slow and costly. The forum has a lot of photos.
What we need is a full backup of the site, both the mysql database and the directory structure with the images etc.
If we can not have a backup of the directory structure, we could use FTP to transfer the images from the old to the new server.
We could at least start with the database, so that we re-create the forum in a new server and then gradually transfer the images too.
I propose we disable posting in the old forum, set-up the new one,
and run both of them until the migration is over (apparently the old forum will only be accessible via its IP address)
It seems there are a lot of us here who can help.
Having our own server with shell access means we can implement various interesting things...
I am crazy enough to even propose that after a successful migration we should start developing our own forum software,
just for the fun of it
In my website everything is coded by me (in Ruby). _________________ Νίκος • www.diafragma.gr
Cameras: Canon EOS 5D Mark II, Sony α7R, Sony NEX-5N
MF lenses:
SLR:
Canon TS-E 17mm f/4, Zeiss 2.8/21 ZE, Zeiss 2/28 Contax, Zeiss 2/35 ZE, Zeiss 1.4/50 Contax, Zeiss 1.4/85 Contax, Zeiss Makro 2/100 ZE,
Zeiss 2/135 Contax, Zeiss 2.8/135 Contax, Zeiss Vario-Sonnar 35-70 Contax, Zeiss Vario-Sonnar 100-300 Contax, Zeiss F-Distagon Rollei, Canon FD 24mm f2, Minolta MD Rokkor 35mm f2.8
Rangefinder:
Zeiss 4.5/21 C Biogon ZM, Zeiss 2/35 Biogon ZM, Voigtländer 15mm f/4.5 Heliar L39, Leica Tele-Elmarit 2.8/90mm, Zeiss 2/45 Contax G, Zeiss 2.8/90 Contax G, Canon 50mm 1.8 LTM
AF lenses: Canon 15mm f/2.8 Fisheye, Canon 24-70 f/2.8 L, Canon 70-200 f/2.8 L IS II, Canon 70-200 f/4 L, Canon 300 f/4 L IS, Canon 100 f/2.8 macro
|
|
| トップへ戻る |
|
 |
ludoo
 登録日: 2009年9月18日 投稿: 1397 所在地: Milan, Italy
Expire: 2011-12-05
|
 投稿日時: 木 11月 04, 2010 8:39 pm 件名: |
|
 投稿日時: 木 11月 04, 2010 8:39 pm 件名: |
|
|
ludoo wrote:
| nkanellopoulos 氏の書き込み: |
| wget is not a good option for dynamic sites. This solution would also be slow and costly. The forum has a lot of photos. |
Wget in mirror mode acts as a client, downloading static content (assuming photos are accessible as such). If there's no way to grab them off the current servers, there's no other solution apart from writing a custom script (which was my first choice above) that adds delays and error control.
| 引用: |
| What we need is a full backup of the site, both the mysql database and the directory structure with the images etc. |
The assumption was that this is not possible. If it is, of course it's better. As for FTP, I don't see any practical advantage using it over HTTP. And I doubt they have FTP on "the cloud".
| 引用: |
I propose we disable posting in the old forum, set-up the new one,
and run both of them until the migration is over (apparently the old forum will only be accessible via its IP address) |
Sure. And do a round of initial optimizations (checking that all tables except sessions etc. use InnoDB, tuning the buffers and caches, etc.). Then activate the mysql slow log to trap slow queries and optimize the db as we go along. And maybe try to minimize memory use and speed up static serving by using lighttpd instead of Apache. _________________ My galleries
Digital: Samsung EX-1
Past Digital: Samsung NX10, Sigma SD9, Sigma SD10, SD14, DP2, Pentax *istD, Kx, Fuji S2 Pro, Canon 5D
Analog: packfilm Polaroids, 6x9 Kodak folders, Pentacon Taxona half-frame, Fujica ST605n, Walz Envoy, Olympus 35 S-II, Olympus Wide S
Past Analog: Polaroid 600se, Polaroid 110B, Canon IIF, various fixed-lens and Russian rangefinders, ...
Past Lenses: Nikkor 24/2.8, Nikkor SC 50/1.4, Nikkor 50/2, Nikkor H 85/1.8, Nikkor P 105/2.5, Nikkor Q 135/3.5, Fujinon 100/2.8, Fujinon EBC 100/2.8, Fujinon EBC 135/3.5, Fujinon EBC 200/4.5, Mamiya SX 135/2.8, CZJ Flektogon 35/2.4, CZJ Pancolar 50/1.8 zebra, CZJ Sonnar 135/3.5, ...
altroformato
|
|
| トップへ戻る |
|
 |
|
|
|
このフォーラムでは新しいトピックを投稿できません このフォーラムではトピックに返信できません このフォーラムでは自分の投稿を編集できません このフォーラムでは自分の投稿を削除できません このフォーラムでは投票に参加できません
|