Re: MySQL on Cluster
Can you give some more information about this disc cluster? The term to me is vague. I am assuming that it's NOT a RAID array, but I'm also guessing that it's not a reference to a group of machines either. Can you explain some more? Later on, TRC - Original Message - From: Frank [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 14:25:33 +0200 To: [EMAIL PROTECTED] Subject: MySQL on Cluster Dear MySQL I'm about to buy two software products that uses MySQL, but I need to know if MySQL works in cluster. I have two servers and a disc cluster. If the server running has any problems, the other server will take over the cluster and run all the applications. Can MySQL also work in this environment? Best regards Frank Bredal [EMAIL PROTECTED] +47 90 01 40 10 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Free OperaMail at http://www.operamail.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql..Python..
Python has the ability to produce ( with modules) graphics for my database interface, outside of the Browser enviorment. Seems, from what I have read PHP is restricted to the Browser, is this correct? Just to answer the question about PHP being restricted to the browser, the answer to that is no. There are more and more people working on the PHP-GTK project. In that sense, people are using it to create desktop (GUI) programs. In addition, it can be used for other purposes. Like bash scripting. I even extended the Phpserver project code to act as a control over MySQL by issuing commands from a client in the event of a failure of some sort in the system. I can't complain.. Later on, TRC -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not supporting php.
It sounds as if you didn't compile in mysql support with you php executable. You can check this using the phpinfo() function. If you are using the cgi only, try something like... 'php -q -i | grep configure' This will show you all the configuration options you selected when compiling/installing php. There will be some html junk you'll have to sift through, but you should be able to see it. As for showing the db's, try mysqlshow. If you want to see the tables in a db, mysqlshow db_name. If you want to see the info for one table in a db, mysqlshow db_name table_name. Later on, Big Din KR (Terrence :-|) - Original Message - From: David Grant [EMAIL PROTECTED] Date: 02 Jun 2002 23:50:53 -0700 To: My SQL Mailing List [EMAIL PROTECTED] Subject: mysql not supporting php. mysql support is not available to php on this server This is the error I receive. MySQL is working fine, but I need to know how get php working with sql. Also, does anyone know the command to list all the db's? thanks. Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Eliminating downtime
How would you guarantee the success of the transaction? If it fails as a result of a hardware failure, then ultimately, the system as a whole has suffered a hardware failure. If it fails for any other reason, then it's an issue with software or bad data. Once those things are figured out, you proceed forward. If you need HA (high availability) from the database, then consider using more than one machine and a product like TurboCluster 6 which can monitor the hardware and software availability of the system. Of course, when I say system, I'm speaking in a way that includes transaction servers, web servers, db servers, and whatever else it is you are doing. Now in the event that a transaction fails, does that mean that the process just gives up and dies? If a db machine fails, just have the process redirect it's transaction to a replicated machine. This is a simple explanation of what's possible, but with a little planning, you can get it done. As for this... Once the transaction failed it should take the failed database out of service. .. I believe you are better of to have a piece of cluster management software (as an example) manage this. The process that is respnosible for the transaction would know in advance what machine to fail over too should a failure occur. Besides, adding a 'layer' that is responsible for managing the success of queries or transactions and live db servers and machines is probably creating un-needed complexity. On the other hand, there is a hunk of code out there called db balancer that is aimed at providing replication and load balancing for postgress db's. Considering the code is available, it prolly would'nt be much work to extend it for duty with MySQL. I however feel that's lack of maturity excludes from serious consideration. But your timeframe and needs may be different from mine. Later on, TRC The thing is I'm looking for a solution with guaranteed transaction success. I have thought about building a layer that would guarantee transaction success. Say I had two duplicate databases and if a transaction failed on one it would still succeed on the other. Once the transaction failed it should take the failed database out of service. I believe this could be fairly straightforward but thought I would check the list to see if someone had already built a product or setup some system that would allow for this. Dave Turner -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: count...I think
In short, it would be LIMIT 20,0 If I'm not mistaken. However, the db isn't going to kick out the string The query returned 0-20 of 132 records for you. Are you trying to do database pagination? Mulitple rows spread across multiple page views? If that's the case, PHPBuilder has an article on the topic. Also, if you are OK with using objects, I wrote one for that specific purpose. Let me know, TRC - Original Message - From: [EMAIL PROTECTED] Date: Thu, 30 May 2002 14:24:58 -0400 To: [EMAIL PROTECTED] Subject: count...I think Hey guys, I have a very simple question, I though I knew the answer but the MySql manual has confused me I have a simple select from a database of say...1k records...I use select id from myTable where sal1000; Lets say this statement would normally return 132 records, but how do I know how many it will return? Basically I want it to return The query returned 0-20 of 132 records (I am using PHP) I know theres a count somewherebut where? Cheers, -Ryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to design mysql clusters with 30,000 clients?
On Wednesday 22 May 2002 18:44, Dave Watkins wrote: At 16:02 22/05/2002 +0800, Patrick Hsieh wrote: Hello list, I am expecting to have 30,000 http clients visting my website at the same time. To meet the HA requirement, we use dual firewall, dual Layer-4 switch and multiple web servers in the backend. My problem is, if we use the user-tracking system with apache, php and mysql, it will surely brings a huge amount of database traffic. How can I balance mysql load among multiple mysql server yet assure the data consistency among them? My idea is: I suggest that you do use clustering. However, you are better off running the Database in a fail over manner as opposed to load balancing multiple db machines. However, a bit of load balancing can be achieved if all reads are done from replicated machines and all writes are done to the master. Just as the manual suggests. For the rest of it (not including the firewalls and switch) you could use a product like TurboCluster 6. It will load balance and monitor the health of every machine in the cluster, including it's software, and in the event a node goes down, the action taken can be customized. The machine that manages the cluster can also run with a backup of it's own that in the event of failure would take over witout admin intervention. It can also track returning users and route them to a server they previously visited. You can understand why this is good. It doesn't care about what OS is running on any of the machines in the backend and the load balancing can even run Weighted round robin if you using a heterogenous topography. When designing our setup, I pushed hard to make sure that we used the same hardware and configuration in each machine as much as was possilbe. That certainly eases tuning issues. Anyway, I would check this out. The price is 2k$ for a ten node cluster and two traffic mangers. Nothing else is going to even close. Later on, TRC -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error while start mysql service
Have you considered using perror? Try perror 10 67. - Original Message - From: Priyesh Panchmatia [EMAIL PROTECTED] Date: Tue, 14 May 2002 20:20:45 +0800 To: [EMAIL PROTECTED] Subject: error while start mysql service Hi, I get the follwoing error while starting myssql service. If anybody can help that would be great. Thanks in Advance. Priyesh -- D:\mysql\binnet start mysql The MySql service is starting. The MySql service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Problem
Hi Raymond, That's an interesting message you're getting. Obviously there is an issue with IP address not getting to mysqld. The only thing that can make any sense to me in this one is double check the name and location of the my.cnf file. See ya, Terrence - Original Message - From: Raymond Brighenti [EMAIL PROTECTED] Date: Fri, 10 May 2002 10:23:30 +0100 To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: Replication Problem Hi, Trying to get replication going between to W2K machines and getting the following errors in the Slave log file. MySql: ready for connections 020509 18:58:52 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec 020509 18:59:54 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec 020509 19:00:57 Slave thread: error connecting to master:Can't connect to MySQL server on '' (10049)(0), retry in 60 sec Below are the two my.cnf files which as far as I can see should be ok. my.cnf Master [mysqld] log-bin server-id=1 my.cnf Slave [MYSQLD] master-host=20.0.0.54 master-user=echo master-password=password master-port=3306 server-id=2 Below are the output from some other checks, it's got the connecting to master in the colum. Looking at the log file it's getting the MySQL server on '' which seems to indicate that it doesn't have a host or IP address to connect to! Any ideas? Thanks Ray So from Master... mysql show master status; +---+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---+--+--+--+ | dnatest03-bin.002 | 73 | | | +---+--+--+--+ 1 row in set (0.00 sec) And from Slave... mysql show slave status - ; +-+-+-+---+--+-+ ---+-+-++--- -+--+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +-+-+-+---+--+-+ ---+-+-++--- -+--+ | | test| 3306| 60 | | 4 | Yes | | | 0 | | 0| +-+-+-+---+--+-+ ---+-+-++--- -+--+ 1 row in set (0.00 sec) mysql show processlist ++---+---+--+-+--+-- +--+ | Id | User | Host | db | Command | Time | State| Info | ++---+---+--+-+--+-- +--+ | 1 | system user | none | NULL | Connect | 985 | connecting to master| NULL | | 2 | administrator | localhost | NULL | Sleep | 5|| NULL | | 3 | ODBC | localhost | NULL | Query | 0| NULL| show processlist | ++---+---+--+-+--+-- +--+ 3 rows in set (0.02 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: replication
Let's see your my.cnf file. - Original Message - From: Azhar Khan [EMAIL PROTECTED] Date: Wed, 8 May 2002 17:49:55 -0400 To: [EMAIL PROTECTED] Subject: re: replication During the replication process http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication_HOWTO I followed all the steps from 1 - 9 Everything works fine (i.e. both master (marge) and slave (wiggam) run individually) and only when on step 9 my log on the slave (wiggam) says: 020508 17:19:47 mysqld started 020508 17:19:48 InnoDB: Started /space/local/mysql-max-4.0.1-alpha-sun-solaris2.8-sparc/bin/mysqld: ready for connections 020508 17:19:48 Slave thread: error connecting to master: Can't connect to MySQL server on 'marge' (146), last_errno=2003, retry in 60 sec That is it can't connect to the master...I need to know how I could fix this error. The log on my master (marge) says: 020508 16:44:02 mysqld started 020508 16:44:02 InnoDB: Started /opt/local/mysql-max-4.0.1-alpha-sun-solaris2.8-sparc/bin/mysqld: ready for connections Please help - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Parsing SQL statements
Just to make sure I understand you, you need to check the sql statements themselves for errors. Is this correct? Or, do you instead need to check that a query ran with success? Late on, BDKR - Original Message - From: mustafa karabulut [EMAIL PROTECTED] Date: Sat, 04 May 2002 12:42:26 +0300 To: [EMAIL PROTECTED] Subject: Parsing SQL statements Hello, I need sql statements parsed before they are sent to be queried. I know-though I am not sure- mysql does these steps: 1-Parse sql statement,check for errors 2-execute the statement Is there a way to intrude in between step1 and step2 so that we could get sql statement parsed without it is executed ? A few people recommended me to do it by transactions, to query first and rollback your work after the query is performed succesfully. But you know disadvantages of transaction safe tables and my tables are already non trans. safe and if there is a way to parse sql statements then I will get rid of lot of work. I need your help. And of your help and suggestions are very appreciated. Best regards M.K. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Parsing SQL statements
This is still a little unclear. You want to check the query to see if it can be run succesfully, or that it RAN succesfully. Perhaps I should as if you wish to check the query before or after it runs? Later on, Terrence (BDKR) - Original Message - From: mustafa karabulut [EMAIL PROTECTED] Date: Sat, 04 May 2002 16:36:33 +0300 To: [EMAIL PROTECTED] Subject: Re: Parsing SQL statements Thanks for your reply. I meant the second, to check the query whether it can be executed succesfully. Seems transactions are needed, is there any other way ? From: Terrence Cox [EMAIL PROTECTED] To: mustafa karabulut [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Parsing SQL statements Date: Sat, 04 May 2002 21:30:54 +0800 Just to make sure I understand you, you need to check the sql statements themselves for errors. Is this correct? Or, do you instead need to check that a query ran with success? Late on, BDKR - Original Message - From: mustafa karabulut [EMAIL PROTECTED] Date: Sat, 04 May 2002 12:42:26 +0300 To: [EMAIL PROTECTED] Subject: Parsing SQL statements Hello, I need sql statements parsed before they are sent to be queried. I know-though I am not sure- mysql does these steps: 1-Parse sql statement,check for errors 2-execute the statement Is there a way to intrude in between step1 and step2 so that we could get sql statement parsed without it is executed ? A few people recommended me to do it by transactions, to query first and rollback your work after the query is performed succesfully. But you know disadvantages of transaction safe tables and my tables are already non trans. safe and if there is a way to parse sql statements then I will get rid of lot of work. I need your help. And of your help and suggestions are very appreciated. Best regards M.K. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Powered by Outblaze _ Join the world?s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
