When Should I Scale Out From One LAMP Machine?
I just have one server that runs Apache, MySQL, PHP. It handles
requests fine and never had problems. When should I think about a small
step into scaling? By maybe having an independent MySQL server? How
many QPS (Querys Per second) (approx) on the MySQL DB will it be
optimal for me to have MySQL on a seperate maybe more powerful machine?
The current server has 1GB Ram and intel duo core processors..
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Some Advice For A Newbie On Big Scale Websites Like Ebay, Facebook, Youtube
I am literally newbie in database design. Just finished kevin yank's build your own database driven website using php and mysql. The book helped me to understand the imporatance of deisgn in a database driven site but I still finding it difficult to figure out the large scale websites like ebay, facebook or youtube. Does anyone know how the database might be designed for these sites. Facebook and youtube are tagbased sites where everything is connected by tags. but how are these tags organized in tables?
Free LAMP-Image - Is It Legal?
I plan to make a vmware image, which contains a LAMP system, that means: Linux (in my case debian or a smaller one), apache, mysql and php5. My question: Is it legal? I want to provide this image for FREE!
Carry Database From Wamp To Lamp
i created a database in WAMP ON WINDOWS ans now want to put it on my lamp server.but dont now how to do it.MySQL version is 5.0.x.
Linux Server V/s Windows Server ( WebServer - LAMP V/s WAMP)
My client wants to use WAMP ( Windows + apache + MySQL + PHP ). But the site performance is very slow on windows. I dont know the exact reasons. I have seen some benchmark details on internet. But still they are not having concrete facts to support LAMP as a better alternative to WAMP. Allmost all the search done on google melts down to IIS vs Apache, My main concern is "Apache on LINUX" v/s "Apache on Windows" and similarly for PHP/MySQL.
Two Versions On Same Machine
I had MySQL 4.2 - working fine. I saw version 5 is now stable so I downloaded and installed but did not run it (I think!). Carried on with 4.2. Then one day MySQLAdmin and Query would not log me on. I checked via the cmd line utility and when I typed in the password the window dissappeared! I opened MySQLAdmin again and reconfigured the log-on o 3307 (I remember this was default when I installed 5.0). OK, the server must be running. So keep with 5.0 as I managed to restore one of my schemas. I wanted a later version which is only in the 4.1 directories and copied it across BUT 5.0 does not see it. But when I go to stop and restart the 5.0 server in Admin as soon as I go to the server tab to do this it stops automatically! AND will not restart.
Speed From Second Machine Bad
I am new to MySQL (mysql-4.1.7-win) with MySql ODBC (MyODBC-3.51.10-x86-win-32bit) and (vb 6 with service pack 5 or Access 2003) to connect via adbc to MySQL. My seccond machine are terribly slow and would like to know if there are any suggestions.
Load On My DS Machine
I've got dedicated server , 30mbp/s line, and solving very strange issue, my hosting told me i burn about 2.8mb per sec., so i get a lot of traffic, i don't use mysql very often, i use mysql only for special cases, no more than 5 requests at same time. i'm checking top function via telnet console, and i can see sometimes huge loads on server, from 0,8-1 it skips to 20, then 30, 50, 100, somewhere between 20-30 it crashes mysql, and i can't connect , sometimes it went to 150 load, and then it slowly going back to normal.
Migrating My Mysql DB From One Machine To Another
We are moving our mysql db from one machine to another -- both linux. Origin machine is running mysql 3.23, destination machine is running mysql 4.1. Can we simply copy all *.MYD / *.MYI / *.frm files from one machine to the other and have things work? Or do we *NEED* to do a text dump of the tables, and reload each one individually on the new machine?
How To Go About Re-installing MySQL On A New Machine?
I have MySQL installed and a database already built and loaded with data that is collected nightly from the mainframe database. I am currently running on NT and will be loading a new image onto the machines to change the operating system to Windows2000. From what I understand, I will need to copy all files I want to keep, including my database. My question is, once the new image is on, I will need to re-install MySQL, is it as easy as just copying back the MySQL directory back onto the machine and the database still work? If not, can someone tell me what the general process is to do this without losing the database and any issues that I am going to run into?
Can't Connect From Remote Machine
I am writing some code in ASP3 on an XP windows machine. I am trying to connect to a linux machine which is Redhat 7.3 that is hosting my MySQL database. I am use this code to connect. objConn.Open "Driver={mySQL};Server=http://4.7.165.99;Port=3306;Option=131072; Stmt=;Database=DB name;Uid=User Id;Pwd=MyPassword;" This is the Error message I keep getting: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have been looking all over the web, and can't find how to fix this issue, can anyone help me?
Anyway To Run 2 Instances Of MySQL On The Same Machine?
I was wondering if there is anyway I can run 2 instances of MySQL Server on the same machine, the reason is I have one machine and I want to be able to simulate my program which really talks between 2 systems accessing their own MySQL server datas but I dont have 2 machines with me all the time to do this, it would be great If I could somehow manage this.
Connecting On A Local Machine
I have recently installed Mysql on my local machine. I can access Mysql through the Mysql Command line client. But I can't connect through mysql_connect.php script. I have always used mysql through our hosting company with no problem. This is the first time I have installed it on my machine. When running the script I recieve the following error Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061
Connect To MySql From Another Machine
I have RHEL 4.0 installed on a x86 box, and am using the standard MySql server that comes with RHEL 4 (MySql version 4.1.12). I tried downloading the Administrator tool, but had problems installing it. (This issue has already been reported at http://forums.mysql.com/read.php?34,65093,65093#msg-65093). I have an Administrator install on a Windows machine, and I want to use it to connect to the MySql server on the RHEL box, but get the error that says: Host '<my_machine>' is not allowed to connect to this MySql Server. Can I use the Windows Administrator tool to connect to a MySql server on Linux? (same network and sub-net) During the RHEL install, the firewall option has been disabled, so that's not an issue. I think I need to add an entrry somewhere in the MySql db that allows other machines to connect, but am unsure of how to add it, and what the syntax looks like.
Connect To Another Machine With SQL-Server
just installed a mysql server, database and user on one machine [1] (debian-linux) Now I want to connect to the database from another machine [2]. Actually I am sure that I have to configure connectors or named pipes. But I can't find these topics in the manual. When starting mySQL as user on the server everything is ok. When starting mySQL as user on the client computer [2] I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) actually '/var/run/mysqld/mysqld.sock' is not existing. What do I have to put into that one? Or rather into /etc/mysql/my.cnf
Access MySQL From Another Machine
how do I make MySQL server accessible from the network to other web servers. Right now I have the MySQL server and the web Server all on the same server. But I want to have a server that is solely responsible for MySQL and 3 others servers that are responsible for web page serving via Apache. The web servers need to be able to access the MySQL database. |-----| |----| |----| |Web | |Web | |Web | |-----| |----| |----| ! ! ! !!!!!!!!!!!!!!!!!!!! | |----| |My- | |SQL | |----|
Usinq MySQL And MS-SQL On The Same Machine?
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Usinq MySQL And MS-SQL On The Same Machine
I want to try MySQL but I already have Microsoft SQL Server on my machine. Can they reside on the same PC or will they mess eachother up? And why does the name of this newsgroup start with 'mailing.'?
Move SQL Files On Same Machine
How do you move the directory where MySQL files reside and inform the local MySQL server of this? I'd like to be able to move my data files to different locations on my hard drive AND move them to another machine when I have to use them on the road.
Moving Database To New Machine
I'm trying to relocate my site to a new host and I'm having a lot of trouble moving the database. I did the export for the old host/database with phpmyadmin. It saved to a txt/sql file with no problems. When I try to import it into the new host/database I get all kinds of syntax errors. Then I realized, after purchasing the new host that: Old host/db = MySQL version 5.0.24a New host/db = 4.0.27 Is there any way to convert a 5.0 db to 4.0?
Connecting To MySql On An XP Machine
I have worked with mySql on my localhost and it does fine. Now I am going to try and login to it from another XP machine. Both machiens are Windows XP Pro SP2. What do I need to type at the command prompt to login to mysql on the other XP machine?
Create Dsn On Linux Machine
i am raghvendra. i am working on linux. i am using a php4 with apache 2 on linux machine. i want to create a dsn on linux machine. but i donot know how can i do this. my database is on remote windows machine.
Md5 Problem After Moving Database To Another Machine
I moved my MySQL database to my own web server (Windows NT4 server, Apache 2.0.55, PHP v4.4.0, and MySQL v4.0.26). I used "mysqldump" and "mysql -u root -p ccs < sqldumpfile" to backup and reload the tables. Some PHP scripts that work fine on my ISP (MySQL v3.23.58) do not work on my local PC (MySQL v4.0.26). The part of the select statement where the problem lies is: and password='".md5($MD5_PREFIX.$_POST["password"])."' I did some testing via the mysql command line interface and it appears that the md5 function is generating a different value. If I set the password to '123' with no encryption and remove the md5 stuff from the PHP script it works (the $MD5_PREFIX has not been changed and I even did some testing in mysql by hardcoding the value) -- so I'm pretty sure the problem lies with the md5 function. Is there a difference in md5 between different versions of MySQL? If not, can someone point me in the direction of a solution?
Mysql Runs On A Machine With Multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of user@localhost instead it will be equal to the rights of the user@PrimaryIPAddress. Is this behaviour correct or a bug.
Moving Database To Alternative Machine.
Have installed version 4.1 on 2 machines. I am trying to copy a database that i created on one machine by simple going to the data folder and copying the database folder pasting it to a removable device. I then copied the folder into the data folder on my second machine. However, when i attempt to do a select * on any of the tables on the second machine, I am told that the table is corrupted or does not exist.
MySQL Administrator On A Remote Machine
On my internal network i have mysql running on a test/development webserver (windows), and im trying to use the GUI tool MySQL Administrator on another networked pc but it wont work. It keeps saying 'Error 1045 Access Denied....' I can ping it fine, and MySQL Administrator GUI works on the server itself.
BACKUP DATA TO LOCAL MACHINE
Is there an easy way I can backup / copy MySql tables to my desktop PC. It would be neet if I could query these backups once of my desktop PC with MS Access.
Blank Password When Restarting The Machine
I mainly use MySQL Administrator to create/update table/users/etc. And I noticed that whenever I restart my machine (Windows 2003 Server with MySQL database running) and login to the MySQL Administrator, it takes blank or wrong password for any user account including root. So I end up resetting my root password. Does anyone know why it keeps happening?
Installing MySQL On WIN98 Machine
I'm trying to install mySQL on my WIN98 machine (I ran the setup.exe file), and am never prompted for a password when I run the configuration wizard. When I try to then run the command window, I'm asked for the password. Can I change some config file or ini file? I'm selecting either Detailed or Standard Configuration, and don't ever get the prompt for password. The checkbox for "Install as windows service" is disabled, so I can't check it.
Nightly Backups To My Local Machine
I have a MySQL database on one of my sites with shared hosting company which has nightly DB backups. However I would like to have a nightly copy for myself on my local machine. Is there a way to automatically expoxt the entire MySQL database and FTP it to my local machine nightly? Do i just need an FTP program that provides scheduling or are there other ways?
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
MySQL VmWare Virtual Machine - Password?
I just downloaded and installed the MySQL-provided VMware linux virtual machine. To logon to it there is a linux user 'lxuser' provided. Anyone know the password for lxuser? root?
How To Insert Machine (local) Time In Mysql
This is a problem I encountered in mysql: how do I insert local (machine) time? To do this in MS Access, just put now(). I tried this in mysql, it does not work. see graph(the red chinese characters means the same thing as above.)
Importing MySQL Database To Local Machine
I have exported a MySQL Database from a remote server using PHPMYADMIN, saved on my local XP machine as an sql file to insert (with name _DB_.sql) but am not sure how to get this to run on my local XP machine which is running MySQL locally; When I view the file on Notepad it appears to be executable in some way as it includes CREATE command etc. I tried the following from MySQL command line SOURCE C:/Program files/MySQL/_DB_sql but can't see any evidence of the database having been created on my local machine.
Multiple MySQL Server Installations On One Machine
First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.) If so, what naming convention (and infrastructure) distinquishes between the two MySQL servers? What network connectivity file entries would exist to differentiate between the two servers such that I could connect to one or the other servers from a remote client?
Machine Name & IP Address Fails For Remote Admin Login
I've just set up 5.0 on both a desktop server and a laptop with an essentially default install using WinXP (brand new, naive user here!). I find that when I use the Administrator Tool that I can only log into ServerHost: "localhost" using Username: "root" and the password I made. This is made worse as I can only hit the desktop from the laptop using Remote Desktop connection. What I can't do is either use the WinXP machine name, or the IP address for the Serverhost. This becomes an issue for the laptop especially as the IP address can change (although this is accessed through a VPN, so the WinXP machine name might be used). I am quite confused by the documentation regarding servernames, bindings, hostnames, etc.
How Do I Create A Database On Linux Machine Running Mysql?
I have an sql script file that is supposed to create a set of database tables for me. Supposedly I type the following on my linux box and its all supposed to work... mysql (ENTER) . mysql_dump.sql.txt When I type myslq <ENTER> I get a command prompt that looks like this... mysql> But I don't know how to change directories from that command prompt to the directory where mysql_dump.sql.txt is located. Can someone tell me how to change dirs at the mysql> prompt?
Dumping My Live Database And Then Putting It On My Local Machine Problem..
I have tried copying the dumped sql code in mysql query browser once dumped from live and it doesn't execute it, i have to extract it line by line and that would take forever to do this all, is there an easier way to do this or can someone run me through the basics on how to achieve this? i have on my live site: 4.0.25 (patched) and on my desktop computer : 5.0 Would this be part of the reason? i don't know..
|
TRACKER
