Jose, First I would recommend fixing your site. Warning: main(db/db.php): failed to open stream: No such file or directory in /home/uc0208ea/public_html/mainfile.php on line 77
Fatal error: main(): Failed opening required 'db/db.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/uc0208ea/public_html/mainfile.php on line 77 But as far as your scenario goes, to me it's all about diskspace. In your examples you are saying that you need about 10 terabytes of diskspace. At least in the first example. First, I would determine what your budget would be, then worry about how you can fit your system inside of that budget. The next biggest thing is how many people will be hitting it at one time? I know of a company that has a $200,000 mysql server, with 2 identical backup servers that are running as slaves. Do you know they get about 100 queries/second? A 486 with 256mb of memory could handle 100 queries/second. That's my 2 cents. Donny > -----Original Message----- > From: tachu [mailto:[EMAIL PROTECTED] > Sent: Friday, May 28, 2004 6:52 PM > To: [EMAIL PROTECTED] > Subject: Server capabilities > > OK I have one more scenario I need some help with. Say im using master > and slaves replication and i have N ammount of servers would mysql be > able to have say 100000 databases with about 30 tables per db and a > total of say 100 megs of data per/db. would the server be able to manage > that. considering i would have about 5 mysql servers and in front of > that 50 web servers serving php pages? or my second scenario is i have > those main 50 servers each with one mysql server running in it and 2000 > dbs per server or in the last scenario i have those same 50 servers with > 1 db and 60000 tables. what issues/limitation do you see in this setup? > > Thanks any help is appreciated > > Jose E. Avila > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
