multiple domain names mapped to a single IP
Hi, Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int-mysqldbserver2.example.com :- 192.168.0.11 Will there be a issue when i point full qualified domain name in the application which uses mysql client program since both domain names are pointing to the same IP? Any help will be highly appreciable. Regards, Kaushal
Re: HT Feature
On Thu, Apr 12, 2012 at 6:38 PM, Johan De Meersman vegiv...@tuxera.bewrote: - Original Message - From: Kaushal Shriyan kaushalshri...@gmail.com Any performance bottleneck if HT (Hyper Threading) is enabled in quad core processors on CentOS 5.8 running MySQL DB Server ? Please help me understand about pros and cons of this feature. That very much depends on your workload. I'd say if you're only running MySQL on that host, chances are that it's going to be beneficial. Best you can do is benchmark with production loads - it varies with exact processor type, architecture, versions and build options of all software, et cetera. Hi Johan, Any benchmarking tool you would suggest ? Regards Kaushal -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: MySQL Plugin
On Sun, Dec 27, 2009 at 10:40 AM, Kaushal Shriyan kaushalshri...@gmail.com wrote: On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan kaushalshri...@gmail.com wrote: Hi I am running collectd (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on Ubuntu Linux 8.04 (Hardy) Server. Plugin mysql Database SMSPAY Host localhost User nagios Password Database smspay Socket /var/run/mysqld/mysqld1.sock # MasterStats true /Database # Database SMSIN Host localhost User nagios Password Database smsin Socket /var/run/mysql/mysqld2.sock # SlaveStats true # SlaveNotifications true /Database /Plugin # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 50 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSPAY | | mysql | ++ 3 rows in set (0.00 sec) mysql quit Bye # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSIN | | mysql | ++ 3 rows in set (0.00 sec) mysql I get the below issue in the collectd.log [2009-12-21 03:12:22] mysql_real_connect failed: Access denied for user 'root'@'localhost' (using password: NO) [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will suspend it for 10 seconds. I am not able to figure out why i get r...@localhost and not nag...@localhost in the collectd.log file even after specifying it in the collectd.conf file. Please suggest/guide. Thanks, Kaushal Hi Again, Any updates to my earlier post to this Mailing List ? Thanks, Kaushal Hi Again, I have not got any reply for my query. Checking in again on this Mailing List. Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL Plugin
On Wed, Dec 23, 2009 at 5:38 PM, Kaushal Shriyan kaushalshri...@gmail.com wrote: Hi I am running collectd (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on Ubuntu Linux 8.04 (Hardy) Server. Plugin mysql Database SMSPAY Host localhost User nagios Password Database smspay Socket /var/run/mysqld/mysqld1.sock # MasterStats true /Database # Database SMSIN Host localhost User nagios Password Database smsin Socket /var/run/mysql/mysqld2.sock # SlaveStats true # SlaveNotifications true /Database /Plugin # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 50 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSPAY | | mysql | ++ 3 rows in set (0.00 sec) mysql quit Bye # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSIN | | mysql | ++ 3 rows in set (0.00 sec) mysql I get the below issue in the collectd.log [2009-12-21 03:12:22] mysql_real_connect failed: Access denied for user 'root'@'localhost' (using password: NO) [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will suspend it for 10 seconds. I am not able to figure out why i get r...@localhost and not nag...@localhost in the collectd.log file even after specifying it in the collectd.conf file. Please suggest/guide. Thanks, Kaushal Hi Again, Any updates to my earlier post to this Mailing List ? Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL Plugin
Hi I am running collectd (http://www.collectd.org/wiki/index.php/Plugin:MySQL) version 4.9.0 on Ubuntu Linux 8.04 (Hardy) Server. Plugin mysql Database SMSPAY Host localhost User nagios Password Database smspay Socket /var/run/mysqld/mysqld1.sock # MasterStats true /Database # Database SMSIN Host localhost User nagios Password Database smsin Socket /var/run/mysql/mysqld2.sock # SlaveStats true # SlaveNotifications true /Database /Plugin # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld1.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 50 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSPAY | | mysql | ++ 3 rows in set (0.00 sec) mysql quit Bye # mysql -u nagios -h localhost -S /var/run/mysqld/mysqld2.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 23 Server version: 5.0.51a-3ubuntu5.4-log (Ubuntu) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; ++ | Database | ++ | information_schema | | SMSIN | | mysql | ++ 3 rows in set (0.00 sec) mysql I get the below issue in the collectd.log [2009-12-21 03:12:22] mysql_real_connect failed: Access denied for user 'root'@'localhost' (using password: NO) [2009-12-21 03:12:22] read-function of plugin `mysql' failed. Will suspend it for 10 seconds. I am not able to figure out why i get r...@localhost and not nag...@localhost in the collectd.log file even after specifying it in the collectd.conf file. Please suggest/guide. Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mytop
Hi, I have issue with the mytop application. I have installed mytop-1.6.tar.gz from http://jeremy.zawodny.com/mysql/mytop/ MySQL on localhost (5.0.54) up 60+00:11:46 [21:52:35] Queries: 6.3G qps: 1301 Slow: 0.0 Se/In/Up/De(%):00/00/00/00 qps now: 1730 Slow qps: 0.0 Threads: 19 ( 13/ 0) 00/00/00/00 Key Efficiency: 99.8% Bps in/out: 0.0/ 0.1 Now in/out: 8.2/ 1.5k I always see Se/In/Up/De(%):00/00/00/00 is there a config issue ? Please suggest/guide Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MySQL DB Server - 5.1
Hi, I have enabled ubuntu backports in Ubuntu 8.04 to install mysql-5.1 server, but i dont find it after apt-get update ? Please suggest/guide Thanks, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com wrote: I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com DOJ ? does it mean Department of Justice ? Kaushal
Error code 121
Hi what does error 121 means in mysql. is there a way to find out the description of error code 121. Thanks and Regards Kaushal
Re: Error code 121
On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: prajap...@debian:~$ perror 121 OS error code 121: Remote I/O error On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan kaushalshri...@gmail.com wrote: Hi what does error 121 means in mysql. is there a way to find out the description of error code 121. Thanks and Regards Kaushal -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Hi I have searched google for the error code 121, which says below OS error code 121: Remote I/O error MySQL error code 121: Duplicate key on write or update The issue is when i run $perror 121 OS error code 121: Remote I/O error and not the second line MySQL error code 121: Duplicate key on write or update Am i missing something ? Thanks and Regards Kaushal
Re: Error code 121
On Mon, Apr 13, 2009 at 4:21 PM, Martin Gainty mgai...@hotmail.com wrote: dupe key.. http://planet.mysql.com/entry/?id=18404 Martin __ Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de déni et de confidentialité This message is confidential. If you should not be the intended receiver, then we ask politely to report. Each unauthorized forwarding or manufacturing of a copy is inadmissible. This message serves only for the exchange of information and has no legal binding effect. Due to the easy manipulation of emails we cannot take responsibility over the the contents. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. Date: Mon, 13 Apr 2009 16:10:02 +0530 Subject: Re: Error code 121 From: prajapat...@gmail.com To: kaushalshri...@gmail.com CC: mysql@lists.mysql.com Give the details what you are doing which gives the below issue. On Mon, Apr 13, 2009 at 4:03 PM, Kaushal Shriyan kaushalshri...@gmail.comwrote: On Mon, Apr 13, 2009 at 3:21 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: prajap...@debian:~$ perror 121 OS error code 121: Remote I/O error On Mon, Apr 13, 2009 at 3:16 PM, Kaushal Shriyan kaushalshri...@gmail.com wrote: Hi what does error 121 means in mysql. is there a way to find out the description of error code 121. Thanks and Regards Kaushal -- Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Hi I have searched google for the error code 121, which says below OS error code 121: Remote I/O error MySQL error code 121: Duplicate key on write or update The issue is when i run $perror 121 OS error code 121: Remote I/O error and not the second line MySQL error code 121: Duplicate key on write or update Am i missing something ? Thanks and Regards Kaushal -- Krishna Chandra Prajapati -- Quick access to your favorite MSN content and Windows Live with Internet Explorer 8. Download FREE now!http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A Hi Martin is there a way to know it from the systems side. when i run perror 121 i get OS error code 121: Remote I/O error. Thanks and Regards Kaushal
Error number 5 means 'Input/output error'.
Hi when i start mysql db server on a particular host. 080718 3:29:09 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. InnoDB: Log scan progressed past the checkpoint lsn 3 3016882171 080718 3:29:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 080718 3:29:10 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 080718 3:29:21 InnoDB: Error: the OS said file flush did not succeed 080718 3:29:21 InnoDB: Operating system error number 5 in a file operation. InnoDB: Error number 5 means 'Input/output error'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: File operation call: 'flush'. InnoDB: Cannot continue operation. Thanks and Regards Kaushal
MySQL purge logs
Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html whats the exact syntax to purge this MySQL Binary Logs -rw-rw 1 mysql 701 1.1G May 5 07:39 host1-bin.000681 -rw-rw 1 mysql 701 1.1G May 5 09:09 host1-bin.000682 -rw-rw 1 mysql 701 1.1G May 5 10:49 host1-bin.000683 -rw-rw 1 mysql 701 1.1G May 5 20:24 host1-bin.000684 -rw-rw 1 mysql 701 1.1G May 5 21:47 host1-bin.000685 -rw-rw 1 mysql 701 1.1G May 5 23:31 host1-bin.000686 -rw-rw 1 mysql 701 1.1G May 6 01:40 host1-bin.000687 -rw-rw 1 mysql 701 1.1G May 6 04:26 host1-bin.000688 -rw-rw 1 mysql 701 1.1G May 6 07:00 host1-bin.000689 -rw-rw 1 mysql 701 1.1G May 6 08:58 host1-bin.000690 -rw-rw 1 mysql 701 1.1G May 6 17:54 host1-bin.000691 -rw-rw 1 mysql 701 1.1G May 6 21:01 host1-bin.000692 -rw-rw 1 mysql 701 1.1G May 6 22:46 host1-bin.000693 -rw-rw 1 mysql 701 1.1G May 7 00:56 host1-bin.000694 -rw-rw 1 mysql 701 1.1G May 7 02:52 host1-bin.000695 -rw-rw 1 mysql 701 1.1G May 7 05:44 host1-bin.000696 -rw-rw 1 mysql 701 1.1G May 7 07:28 host1-bin.000697 -rw-rw 1 mysql 701 1.1G May 7 09:09 host1-bin.000698 -rw-rw 1 mysql 701 1.1G May 7 18:40 host1-bin.000699 -rw-rw 1 mysql 701 1.1G May 7 21:00 host1-bin.000700 -rw-rw 1 mysql 701 1.1G May 7 22:35 host1-bin.000701 -rw-rw 1 mysql 701 1.1G May 8 00:40 host1-bin.000702 -rw-rw 1 mysql 701 1.1G May 8 03:20 host1-bin.000703 -rw-rw 1 mysql 701 1.1G May 8 05:53 host1-bin.000704 -rw-rw 1 mysql 701 1.1G May 8 07:59 host1-bin.000705 -rw-rw 1 mysql 701 1.1G May 8 09:24 host1-bin.000706 -rw-rw 1 mysql 701 1.1G May 8 18:36 host1-bin.000707 -rw-rw 1 mysql 701 1.1G May 8 21:21 host1-bin.000708 -rw-rw 1 mysql 701 1.1G May 8 22:57 host1-bin.000709 -rw-rw 1 mysql 701 1.1G May 9 01:25 host1-bin.000710 -rw-rw 1 mysql 701 1.1G May 9 03:41 host1-bin.000711 -rw-rw 1 mysql 701 1.1G May 9 06:05 host1-bin.000712 -rw-rw 1 mysql 701 1.1G May 9 07:50 host1-bin.000713 -rw-rw 1 mysql 701 1.1G May 9 09:29 host1-bin.000714 -rw-rw 1 mysql 701 1.1G May 9 19:20 host1-bin.000715 -rw-rw 1 mysql 701 1.1G May 9 21:46 host1-bin.000716 Thanks and Regards Kaushal
MySQL (mysql-5.0.54)
Hi I am not able to restart MySQL Database Server (mysql-5.0.54) on Gentoo, I see the below information in the mysqld.err file ## 06 6:30:13 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem. 080506 6:30:13 - mysqld got signal 4; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=0 read_buffer_size=262144 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 76800 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=(nil) Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... frame pointer is NULL, did you compile with -fomit-frame-pointer? Aborting backtrace! The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. ## Any ideas Thanks and Regards Kaushal
mysqldump
Hi I get # mysqldump -u root -p dashboard /home/mysql_backup/dashboard.sql Enter password: mysqldump: Got error: 1033: Incorrect information in file: './dashboard/Actions.frm' when using LOCK TABLES what am i missing Thanks and Regards Kaushal
MySQL Slave
Hi Is there a way to find out when the MySQL Slave has been restarted. Thanks and Regards Kaushal
Re: MySQL Slave
On Fri, Apr 18, 2008 at 7:06 PM, Ben Clewett [EMAIL PROTECTED] wrote: Check the error.log on both server and client, should show where connected and disconnected. Or write a small program to execute SHOW SLAVE STATUS every minute and log the results. Which I belive is done for you in the MySql dashboard program suit. Ben Kaushal Shriyan wrote: Hi Is there a way to find out when the MySQL Slave has been restarted. Thanks and Regards Kaushal Hi I could see the restart in tail -f /var/log/mysql/mysqld.err file while doing slave stop and slave start, but when i use mk-slave-restart -u root -p test -h localhost --verbose. it gets hung. Any clue Thanks and Regards Kaushal
mytop
Hi How can i monitor multiple MySQL Database using mytop or are there any other tools to monitor it. Thanks and Regards Kaushal
MySQL Master and Slave Database Setup
Hi, I need to run a longer running insert and test it in the Master Slave Replication Database Server. And interrupt the Insert query on the Master and check on slave to ensure that the data is in sync. How can i do it, are there benchmark tools to do that. Thanks and Regards Kaushal
MySQL Master and Slave Database Server
Hi, what are the different test cases to test MySQL Master and Slave Replication Database Server. Thanks and Regards Kaushal
Re: MySQL Master Slave Replication
On Mon, Apr 7, 2008 at 11:58 AM, Kaushal Shriyan [EMAIL PROTECTED] wrote: On Mon, Apr 7, 2008 at 11:32 AM, Néstor [EMAIL PROTECTED] wrote: Kaushal, I will try it tomorrow to see if it works. It is similar to something I tried a couple of weeks ago and it work but when I changed the ip address it stop working. I will try this tomorrow and let you know. Néstor :-) On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: hi is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] Hi Nestor Thanks for the quick reply My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role. is this possible. Thanks and Regards Kaushal Hi Nestor Thanks for the quick reply My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role. is this possible. Also how can i test this setup from the MySQL client. Any test cases available would be of great help to test out this MySQL Database Master and Slave Server Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Master Slave Replication
On Tue, Apr 8, 2008 at 12:02 AM, Néstor [EMAIL PROTECTED] wrote: Kaushal, That worked. I found out that my problem was that my firewall was not allowing my to computers to talk to each other on port 3306. I use the link you sent but this are th eoriginal links I used: 1) Master/Slave replication http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ 2) Master/Master replication http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ Thanks, Néstor :-) On Sun, Apr 6, 2008 at 11:28 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: On Mon, Apr 7, 2008 at 11:32 AM, Néstor [EMAIL PROTECTED] wrote: Kaushal, I will try it tomorrow to see if it works. It is similar to something I tried a couple of weeks ago and it work but when I changed the ip address it stop working. I will try this tomorrow and let you know. Néstor :-) On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: hi is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Hi Nestor Thanks for the quick reply My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role. is this possible. Thanks and Regards Kaushal Hi Nestor My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role.isit possible Also what are the test cases which you followed while doing the Master Slave Replication setup. Thanks and Regards Kaushal
Re: MySQL Master Slave Replication
On Tue, Apr 8, 2008 at 12:14 AM, Kaushal Shriyan [EMAIL PROTECTED] wrote: On Tue, Apr 8, 2008 at 12:02 AM, Néstor [EMAIL PROTECTED] wrote: Kaushal, That worked. I found out that my problem was that my firewall was not allowing my to computers to talk to each other on port 3306. I use the link you sent but this are th eoriginal links I used: 1) Master/Slave replication http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ 2) Master/Master replication http://crazytoon.com/2008/02/29/mysql-how-do-you-set-up-mastermaster-replication-in-mysql-centos-rhel-fedora/ Thanks, Néstor :-) On Sun, Apr 6, 2008 at 11:28 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: On Mon, Apr 7, 2008 at 11:32 AM, Néstor [EMAIL PROTECTED] wrote: Kaushal, I will try it tomorrow to see if it works. It is similar to something I tried a couple of weeks ago and it work but when I changed the ip address it stop working. I will try this tomorrow and let you know. Néstor :-) On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: hi is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Hi Nestor Thanks for the quick reply My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role. is this possible. Thanks and Regards Kaushal Hi Nestor My requirement was if the Master goes down, the slave should take care and act as Master. the Master should acts as slave and reversing of this role.is it possible Also what are the test cases which you followed while doing the Master Slave Replication setup. Thanks and Regards Kaushal Hi Nestor My requirement was if the Master goes down, the slave should take care and act as Master. when the Master comes up it should act as slave and reversing of this role. is it possible Also what are the test cases which you followed while doing the Master Slave Replication setup. Thanks and Regards Kaushal
MySQL Master Slave Replication
hi is this a correct documentation http://howtoforge.com/mysql_master_master_replication for Master Slave Replication Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Master - Slave MySQL Database Server
hi, Is there a step by step guide to set up Master - Slave MySQL Database Server Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Master - Slave MySQL Database Server
On Wed, Apr 2, 2008 at 1:09 PM, Kaushal Shriyan [EMAIL PROTECTED] wrote: hi, Is there a step by step guide to set up Master - Slave MySQL Database Server Thanks and Regards Kaushal Hi, what are the different test cases used for this set up Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Two instances of MySQL
Hi I am referring to http://dev.mysql.com/doc/refman/5.0/en/multiple-unix-servers.html to create multiple instances of MySQL Database Server. I wanted it for Gentoo Linux is there a HowTo for configuring multiple instance of MySQL Database Server on Gentoo Linux Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication
Hi Is there a documentation on replication of MySQL Database on Gentoo Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rsync errors
Hi I am running the command on Gentoo OS /usr/bin/rsync -avO /var/lib/mysql [EMAIL PROTECTED]:/var/lib/ /tmp/rsync-${TIMESTAMP}.log 21 I am getting the below error in the log file mysql/ rsync: failed to set permissions on /var/lib/mysql: Operation not permitted (1) rsync: failed to open /var/lib/mysql/ib_logfile0, continuing: Permission denied (13) mysql/ib_logfile0 rsync: failed to open /var/lib/mysql/ib_logfile1, continuing: Permission denied (13) mysql/ib_logfile1 rsync: failed to open /var/lib/mysql/ibdata1, continuing: Permission denied (13) mysql/ibdata1 rsync: failed to open /var/lib/mysql/master.info, continuing: Permission denied (13) mysql/master.info rsync: failed to open /var/lib/mysql/SCHEDULER /ScheduleTasks.MYD, continuing: Permission denied (13) Any thing I am missing I did setfacl -R -dm u:sms:rwx /var/lib/mysql on hostaa setfacl -R -dm u:mysql:rwx /var/lib/mysql on hostaa chmod -R g-x,g+X /var/lib/mysql on hostaa but no luck Thanks and Regards Kaushal
mysql script
Hi I have created a script http://pastebin.com/m2c9cc100. is this syntactically correct, just want to make sure before running it Thanks and Regards Kaushal
Backup SQL
Hi I have a query is i have taken backup from druapl due to timeout error in three backup files a-l.sql m-s.sql t-z.sql Now my understanding is if i do mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/a-l.sql and then do mysql -u kaushal -h example.com -p drupal /home/kaushal/drupal/new/m-s.sql will it overwrite a-l.sql command insertion in the database Please Let me know if you need more information on this Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fatal error
On 8/3/06, Martin Jespersen [EMAIL PROTECTED] wrote: Looks like drupal had an error when doing the backup - mysql is complaining over the fact that your backup.sql file contains a html formated fatal error message. Kaushal Shriyan wrote: Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near 'br / bFatal error/b: Maximum execution time of 30 seconds exceeded in b' at line 1 [EMAIL PROTECTED] root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal Hi Martin How do i fix this issue Thanks Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump error
Hi ALL I am getting the below error [EMAIL PROTECTED] drupal]# mysqldump --tab=/usr/local/drupal/drupalbckup/ --opt drupal mysqldump: Got error: 1: Can't create/write to file '/usr/local/drupal/drupalbckup/access.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fatal error
Hi ALL I have taken backup of http://mydomain.com/?q=admin/database through drupal 4.6.3 by selecting all tables and it asked me to save as backup.sql. Now when i run [EMAIL PROTECTED] root]# mysql -u kaushal -h bdc31096e.in.office.aol.com -p drupal /home/kaushal/drupal/backup.sql Enter password: ERROR 1064 at line 55817: You have an error in your SQL syntax near 'br / bFatal error/b: Maximum execution time of 30 seconds exceeded in b' at line 1 [EMAIL PROTECTED] root]# I get the above error Any clue Please let me know if you need more info on this issue Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Cluster
Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: On 7/25/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: Hi ALL I want to implement MySQL Cluster, are there any step by step guide to implement it Thanks and Regards Kaushal Hi Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal Hi ALL Is cluster suite is available only in version of MySQL 5 and above. Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Incremental Backup
Hi ALL Can we have incremental backup of MySQL Database and if its there How do we do it Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Incremental Backup
On 7/18/06, Kaushal Shriyan [EMAIL PROTECTED] wrote: On 7/18/06, Tim Lucia [EMAIL PROTECTED] wrote: -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 2:43 AM To: Dan Trainor Cc: Kaushal Shriyan; mysql@lists.mysql.com Subject: Re: Incremental Backup Dan Trainor wrote: Kaushal Shriyan wrote: Hi ALL I would like to know following 2 things. 1) if i would like to take mysql incremental backup weekly cp /var/lib/mysql/ /backup/mysqlbak/ how can i do it by above command as i would like to run cron weekly for take mysql backup. i would like to take backup using cp command only as we have more then 1000 databases on one server. IS THERE ANY BETTER WAY TO DO THIS Thanks and Regards Kaushal Hi - The following, has been my experience: A) That will not work. B) Depending on the OS, this may never complete, as files may constantly still be written to C) Depending on the OS, cp may not be able to take all of those directories for those 1000's of databases as arguments D) If you were doing that, you'd use 'cp -r' The other thing of course is that to copy the files through the filesystem, you have to stop mysql from running so you don't corrupt anything which means your whole database system can't be used. For MyISAM files, mysqlhotcopy of the slave is a workable solution. It's fast, it locks the tables only while copying, and you end up with the same set of files as a cp-based option. Tim -- 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] Hi Tim How do i do it with mysqlhotcopy, can you give me examples on how to use mysqlhotcopy Thanks Kaushal Hi Can I have a incremental backup instead of Full Backup Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Incremental Backup
Hi ALL I would like to know following 2 things. 1) if i would like to take mysql incremental backup weekly cp /var/lib/mysql/ /backup/mysqlbak/ how can i do it by above command as i would like to run cron weekly for take mysql backup. i would like to take backup using cp command only as we have more then 1000 databases on one server. IS THERE ANY BETTER WAY TO DO THIS Thanks and Regards Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can i decrypt password
Hi I have a situation here how can i decrypt the mysql database userrs password Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access denied
Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit Bye [EMAIL PROTECTED] root]# mysqladmin -u root -p create kaushal Enter password: mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '[EMAIL PROTECTED]' to database 'kaushal'' Any Clue will be really appreciated Thanks Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied
On 6/9/06, Dilipkumar [EMAIL PROTECTED] wrote: Hi, Please check the data directory where u have started your mysql has permission ( mysql:mysql ) U would have started your ur mysql ar root user and when u create a database which has no permission as (mysql) in data directory. This might help you out. Kaushal Shriyan wrote: Hi ALL I am faced with a issue of creating database , The issue is I am able to enter to the MySQL Server with the password, but when i try to create database I get Access Denied Below are the details [EMAIL PROTECTED] root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 17 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql exit Bye [EMAIL PROTECTED] root]# mysqladmin -u root -p create kaushal Enter password: mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '[EMAIL PROTECTED]' to database 'kaushal'' Any Clue will be really appreciated Thanks Kaushal -- Thanks Regards, Dilipkumar DBA Support ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in Hi Dilip Below are the permissions [EMAIL PROTECTED] mysql]# pwd /var/lib/mysql [EMAIL PROTECTED] mysql]# ll total 16 drwx--2 mysqlmysql8192 Jun 8 21:29 drupal drwx--2 mysqlmysql4096 Jun 7 19:51 mysql srwxrwxrwx1 mysqlmysql 0 Jun 9 12:49 mysql.sock drwx--2 mysqlmysql4096 Jun 7 19:51 test [EMAIL PROTECTED] mysql]# I have the same set up in other linux box its working there perfectly Any Clues Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Server
Hi ALL I have RHL 9.0 installed on my box, and I have installed mysql-3.23.54a-11.i386.rpm mysql-server-3.23.54a-11.i386.rpm, due to some reason i deleted the folders from /var/lib/mysql, I mean mysql and test folder located under /var/lib/mysql I have re-installed the package mysql and mysql-server package but i am not able to see the test and mysql database which comes by default while installing mysql and mysql-server package. Any help will be really appreciated Thanks Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL
Hi ALL [EMAIL PROTECTED] mysql]# mysql -u root -h saabworld.com -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 3.23.54 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql; Can't read dir of './mysql/' (Errcode: 13) Database changed mysql show tables; ERROR 12: Can't read dir of './mysql/' (Errcode: 13) mysql Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]