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
Related Forum Messages:
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?
View Replies !
Schema Privileges - LAMP
I have a Virtual Server from which I administer a few databases. I need to create complex queries including UNIONS. And to simplify my work, and to make objects available to my application I need the CREATE_VIEW privileges My "Root" tells me that MySQL 4.XX does not support the CREATE_VIEW privilege. My Global privileges do not have this value. How do I, or can I, add a CREATE_VIEW privilege to my list of available privileges?
View Replies !
ERROR 1045 :: LAMP On Ubuntu
I have installed LAMP on an ubuntu machine. Now when I use the command: mysql -u memyid -p it gives me this error: ERROR 1045 (28000): Access denied for user 'memyid'@'localhost' (using password: YES) I did input the password that I set when installing the lamp package. But I do not know why it is acting this way... could some one tell me where I'm going wrong?
View Replies !
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!
View Replies !
Suddenly Mysql Won't Start (LAMP Server)
I use a LAMP-server running on Debian Etch as a virtual host on VMWare. I use mysql for a web gallery, but a couple a days ago it seems to stop working, so I tried to restart mysql and webserver, but mysql then fail to start. The syslog have the following info about it: Jul 22 13:11:12 webserver mysqld_safe[3587]: started Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: Can't read dir of '/tmp/' (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: ^G/usr/sbin/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13) Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [ERROR] Aborting Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld[3590]: 080722 13:11:12 [Note] /usr/sbin/mysqld: Shutdown complete Jul 22 13:11:12 webserver mysqld[3590]: Jul 22 13:11:12 webserver mysqld_safe[3592]: ended Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed Jul 22 13:11:29 webserver /etc/init.d/mysql[3727]: error: 'Can't connect to local MySQL..
View Replies !
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.
View Replies !
Lost Connection To MySQL Server During Query (LAMP Server)
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error: Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4 I've searched the forums and I've gotten no answers. Anyone know the answer?
View Replies !
For Low End Machine
I am developing a Java Swing application for a low end machine (256ram). I need a database which will store some tables. Most of the tables will contain only a few hundred records. There will be a postcode table containing around 1 million records which consists of three columns, postcode, house number and street name. Could I install mysql server on this type of machine and would that table be too large?
View Replies !
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.
View Replies !
New Install On W2K Machine
I installed mySQL4 on a W2K machine and I'm able to connect from the c:mysqlin command line, I type mysqlshow and see test as the only database. I was reading the documentation online here and it showed a table mysql. Is that a system table that is required? Did something go wrong in my installation or is this ok?
View Replies !
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.
View Replies !
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.
View Replies !
MySQL Install On XP Machine
I just installed MySQL on a Windows XP machine, and upon using the SHOW DATABASES command, I was suprised to see that the only table that exists is the 'test' table. Isn't there supposed to be a 'mysql' table there also? Did I miss something?
View Replies !
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.
View Replies !
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.
View Replies !
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?
View Replies !
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.
View Replies !
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
View Replies !
Several Mysql Servers On 1 Machine
Is it possible to setup 2 mysql servers on a Linux platform? For example, both are listening on different sockets. They have different processes, working directory, setup directory. I've seen the my.cnf on my machine but I can't see any socket number.
View Replies !
Accessing A Backup From Another Machine
Have downloaded a mysql backup from another machine and used phpMyAdmin to restore the DB. It works fine and I can see / manipulate the data fine using phpMyAdmin, BUT when I try to access via the application it generates the following --> SQL ERROR [ mysql4 ] Access denied for user 'mossfarm_mossy'@'localhost' (using password: YES) [1045] An sql error occurred while fetching this page. --- mossfarm is the name of the mySQL login on the original machine... Since this is my db I know all the passwords etc, but do not understand the issue this is telling me about... Do I need to set up a new user in MySQL or what. If so, using the above who would it be?
View Replies !
Time Travel Machine
I'd like to have a time travel machine. I mean the following: 1. --list available restore points (performed every $PERIOD_IN_MINUTES) 2. --restore to new database (enter database name, then a new database is created with the selected restore point). 3. --backup all available restores to .tar.gz 4. --delete from available restores For simplicity, let's assume this is only one database running on one Linux server. What would the best way to achieve this be?
View Replies !
Unable To Connect On Same Machine
I can connect using either command line or GUI tool when i have an active internet connection. However as soon as I unplug my machine i can no longer connect to mysql. The Admin GUI tool throws up the error MYSQL error Number 2003 cant connect to MYSQL Server on 'localhost' (10022) whenever i try to connect without an active internet connection.The mysql server is on the same machine so no remote connection should be required.
View Replies !
Login From Remote Machine
I am trying to configure mysql for remote access. I added bind-address= <my-ip> to my.cnf. I also added the needed ssl options. I added a user: GRANT ALL on database.* TO 'username'@'%' IDENTIFIED BY '*********' REQUIRE SSL; I tried to log in localy: mysql -u username -p --ssl-cipher=DHE-RSA-AES256-SHA database Enter password: and it works! Now I try to login from my home pc: mysql -u username -p --ssl-cipher=DHE-RSA-AES256-SHA --host=<my-ip> database Enter password: ERROR 1045 (28000): Access denied for user 'username'@'port-92-205-33-184.dynamic.qsc.de' (using password: YES) What could be wrong?
View Replies !
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?
View Replies !
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.
View Replies !
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
View Replies !
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 | |----|
View Replies !
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?
View Replies !
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.
View Replies !
Replication Master & Slave On The Same Machine
I have set up a master and a slave according to the manual. The master runs 4.0.12 and the slave runs 4.0.14, they are both actually on the same machine (it's a long story, but it's what I need). I did LOAD DATA FROM MASTER on the slave which completed successfully, and then I tried SLAVE START: ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO but.. it is! on the slave: Code:
View Replies !
Creating Mysql Database On My Machine
I got complete application files and database files which is in the format of as .sql and i need to recreate this application on my matchine i have already setup application on my iis server but when it comes to setup the mysql database from those .sql files....
View Replies !
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.
View Replies !
Replication :: Different Slaves And Parameters On Same Machine
Am Working on a distributed database system. My idea is using replication by having several slaves running on one machine and they all connected to different masters each on different machines at the branches. First question is this best approach? Second question is can different slaves with different parameters run on the same machine and if possible what key things must i look for?
View Replies !
Building A Db On Another Server From A Linux Machine
I'm running wamp on a XP machine, which is where my DB will be located. I want to be able build a file containing a crapload of inserts on my linux machine. Is there an easy way to execute those inserts on the DB on the windows side? I guess I could write a small PERL routine to open a connection, and send each insert line by line, then exit. But is there any command line routine that can run on linux (fedora 5) that can initiate the connection, then pass it the file of inserts? I'd like it to be command line, so it can be run from another application which would then run this from a shell.
View Replies !
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?
View Replies !
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?
View Replies !
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.
View Replies !
Reinstalling Mysql On Local Machine
I had mysql install from the XAMPP bundle, but was having issues with that setup, so I uninstalled and deleted all related directories. Now, when I atmysqlt to install mysql from their distributions from mysql.com, it will not let me assign a password to the root account. The install errors out when trying to apply the security settings. The error number is 1045, saying access is denied for the root@localhost user.
View Replies !
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:
View Replies !
|
TRACKER
