Popular Post george Posted April 26, 2024 Popular Post Posted April 26, 2024 FORUM MONTHLY MAINTENANCE NOTICE: Update: We have moved maintenance to Sunday April 28, exact time will be updated on our Facebook Page: ➡️ https://www.facebook.com/ASEANNOWThailand/ --- Forum will be down Sunday April 27, 2024 in a 6 hour window in afternoon/evening until 2am (Bangkok time GMT+7). These times could change as we go, or be longer or shorter, without warning. ASEAN NOW's web traffic is increasing month by month, and we must add 4 times more resources to our cloud hosting and migrate it to Singapore for better user experience and latency. We will also perform our planned monthly forum database maintenance. The whole maintenance work will take about approx 6-8 hours. Forum will be down most of the time. We will update the progress on our Facebook page: ➡️ https://www.facebook.com/ASEANNOWThailand/ Please follow us there! The result will be faster page load, faster posting and less latency. Sorry for any inconvenience! 🙏🏼 And here a tip for free faster and safer internet access to ASEAN NOW and all other sites - try it now: Desktops/mobiles: https://one.one.one.one/ 3 1 1
Popular Post champers Posted April 28, 2024 Popular Post Posted April 28, 2024 It was down last night. Will it still be down tonight as well? 2 1
george Posted April 28, 2024 Author Posted April 28, 2024 55 minutes ago, champers said: It was down last night. Will it still be down tonight as well? Yes, forum will be down today/this evening as well, to do part 2 of the maintenance. It's a huge forum database that must be moved and it will take hours, and database must be offline when work is in progress. 1 1
OneMoreFarang Posted April 28, 2024 Posted April 28, 2024 51 minutes ago, george said: Yes, forum will be down today/this evening as well, to do part 2 of the maintenance. It's a huge forum database that must be moved and it will take hours, and database must be offline when work is in progress. I work with computers, and with databases, since decades. And when I read something like above, then I have my doubts. How big can a database for a forum be? Not huge! If it is so big, can't all old data, i.e. everything until last month or last year, be transferred first, and only a little new data later offline? If you do it right it isn't that complicated and it isn't that time consuming.
Popular Post george Posted April 28, 2024 Author Popular Post Posted April 28, 2024 17 minutes ago, OneMoreFarang said: I work with computers, and with databases, since decades. And when I read something like above, then I have my doubts. How big can a database for a forum be? Not huge! If it is so big, can't all old data, i.e. everything until last month or last year, be transferred first, and only a little new data later offline? If you do it right it isn't that complicated and it isn't that time consuming. 22 years of data = ~300GB MySQL database, ~350GB user pics etc. Moving from Canada to Singapore. Slow internet due to underwater cable issues. Professional people doing this migration, don't worry. No, unfortunately part of database can't be moved as forum software is very special, impossible to set to read-only, and we can't risk losing any data. A necessary database maintenance is also being done while migrating. This very time consuming indeed (mysql dump + transfer of db plus import of MySQL dump into new server database with 4x better prestanda. We are doing this process during low traffic (weekend). No other way to do this. After move it could be a bumpy ride for a day or so as we optimize database and fix any software issues. It's not only to "copy things over" I can assure you... 2 1 1
george Posted April 28, 2024 Author Posted April 28, 2024 9 hours ago, george said: 22 years of data = ~300GB MySQL database, ~350GB user pics etc. Moving from Canada to Singapore. Slow internet due to underwater cable issues. Professional people doing this migration, don't worry. No, unfortunately part of database can't be moved as forum software is very special, impossible to set to read-only, and we can't risk losing any data. A necessary database maintenance is also being done while migrating. This very time consuming indeed (mysql dump + transfer of db plus import of MySQL dump into new server database with 4x better prestanda. We are doing this process during low traffic (weekend). No other way to do this. After move it could be a bumpy ride for a day or so as we optimize database and fix any software issues. It's not only to "copy things over" I can assure you... We will continue maintenance at some point tomorrow, as it’s late and datacenter guys does not work overtime.
Recommended Posts