473,413 Members | 1,755 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,413 software developers and data experts.

php + mysql website design

Hi
I have a website , made by linux + mysql + php + apache. The user
can search for 100000+ articles. The server is in hong kong, when the
people browse the web from bejing , it is really slow. If i upgrade to
a faster boardband line , it is nearly the same. So i want to buy and
put one more server in bejing. But how can i sync the data in
realtime? That mean if a user post a message to the forum in hong kong
server, how can i sync it to bejing server in realtime?

thank
from Peter (cm****@hotmail.com)

Jun 11 '07 #1
3 1442
On Jun 11, 11:59 am, cmk...@hotmail.com wrote:
But how can i sync the data in realtime?
You could use mysql replication.
http://dev.mysql.com/doc/refman/4.1/en/replication.html

Jun 11 '07 #2
At Mon, 11 Jun 2007 02:59:10 -0700, cmk128 let h(is|er) monkeys type:
Hi
I have a website , made by linux + mysql + php + apache. The user
can search for 100000+ articles. The server is in hong kong, when the
people browse the web from bejing , it is really slow. If i upgrade to
a faster boardband line , it is nearly the same. So i want to buy and
put one more server in bejing. But how can i sync the data in
realtime? That mean if a user post a message to the forum in hong kong
server, how can i sync it to bejing server in realtime?

thank
from Peter (cm****@hotmail.com)
Is it 'really slow' when a single user from Bejing accesses the system, or
only when many concurrent users browse pages on it? And if a multitude of
users in HK access it? Same problem? Only in that case it would seem
buying new kit is the best answer. If not, maybe something's not 100% with
the broadband connection? (Or even the PHP scripting? But I doubt that's
the case here, from your post). In which case setting up replication might
have you facing the same problem again.

I have no idea what quality one can expect of available internet services
in today's China. I do remember we have suffered major network issues
(tcp/ip, routing related mostly) replicating SQL databases with the APAC
region (from the Netherlands and UK), but that was 10 years ago, hardly
relevant today I'd say.

I'd hate to see you invest a lot of time and money only to be left with
the same issue. Perhaps having (someone have) a look at the connection at
both ends first might be recommendable.

Good luck!
Sh.

--
Schraalhans Keukenmeester - sc*********@the.Spamtrapexample.nl
[Remove the lowercase part of Spamtrap to send me a message]

"strcmp('apples','oranges') < 0"

Jun 11 '07 #3
On 6 12 , 4 15 , Schraalhans Keukenmeester
<Schraalh...@the.spamtrapexample.nlwrote:
At Mon, 11 Jun 2007 02:59:10 -0700,cmk128let h(is|er) monkeys type:
Hi
I have a website , made by linux + mysql + php + apache. The user
can search for 100000+ articles. The server is in hong kong, when the
people browse the web from bejing , it is really slow. If i upgrade to
a faster boardband line , it is nearly the same. So i want to buy and
put one more server in bejing. But how can i sync the data in
realtime? That mean if a user post a message to the forum in hong kong
server, how can i sync it to bejing server in realtime?
thank
from Peter (cmk...@hotmail.com)

Is it 'really slow' when a single user from Bejing accesses the system, or
only when many concurrent users browse pages on it? And if a multitude of
users in HK access it? Same problem? Only in that case it would seem
buying new kit is the best answer. If not, maybe something's not 100% with
the broadband connection? (Or even the PHP scripting? But I doubt that's
the case here, from your post). In which case setting up replication might
have you facing the same problem again.

I have no idea what quality one can expect of available internet services
in today's China. I do remember we have suffered major network issues
(tcp/ip, routing related mostly) replicating SQL databases with the APAC
region (from the Netherlands and UK), but that was 10 years ago, hardly
relevant today I'd say.

I'd hate to see you invest a lot of time and money only to be left with
the same issue. Perhaps having (someone have) a look at the connection at
both ends first might be recommendable.

Good luck!
Sh.

--
Schraalhans Keukenmeester - schraalh...@the.Spamtrapexample.nl
[Remove the lowercase part of Spamtrap to send me a message]

"strcmp('apples','oranges') < 0"
Yes, really slow, most for the people(90%) said the web is slow. Hong
kong user can load the first page within 5 seconds, it may take >15 in
bejing.
thanks
from Peter (cm****@hotmail.com)

Jun 12 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bob | last post by:
Hi, I have a website in a Linux/Apache shared hosting environment and have been given access to the MySQL server running on the same machine. To access this database from PHP, I have to call...
7
by: Peter Bach | last post by:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different...
0
by: JakeC | last post by:
Hey all, I'm currently redesigning a website that a friend and I started about a year ago. It is a daily surf report so when choosing the best script/language to use for the new design, I found...
0
by: Henry Hank | last post by:
Environment: I'm setting up a database server on a Dell Poweredge 2650, dual 1.8GHZ pentium with 1GB of memory and RAID5 drives. I've installed RedHat 9, and updated the kernel to 2.4.20-19.9smp....
2
by: David | last post by:
I do some website design here and there occasionally for a few clients and I've got a new one that wants a database with their website that will display pricelists displayed for their products and...
4
by: Chefry | last post by:
I'm trying to set up an off the shelf script and keep getting an error. My host set up the mysql on my site and I changed the variables I had to in the settings.php file but I keep getting the...
175
by: Sai Hertz And Control Systems | last post by:
Dear all, Their was a huge rore about MySQL recently for something in java functions now theirs one more http://www.mysql.com/doc/en/News-5.0.x.html Does this concern anyone. What I...
3
by: Jeremy Dillinger | last post by:
I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.