Re: --log-slave-update
In case of master is down. Slave 1 has to be made as master and --log_slave_updates has to be removed. Slave2 will act as slave. There will be no duplicate key On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: But, it also says, that if slave1 is made master and if log-slave-update is set on it, then slave2 might receive data that it might have arleady got from the old master, which might cause errors like duplicate keys etc. On 4/3/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, There is nothing that, you can not enable log_slave_updates on slave. Basically, it is useful in a situation when you have 1 master and 2 or more slave in chain series. In this model 1st slave server should work as master as well as slave. So, log_slave_update and binlog can be enabled to log all the queries to binlog. In this way 2nd slave get the updates from 1st slave. Krishna Chandra Prajapati On Thu, Apr 3, 2008 at 12:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I have Master - Slave setup, with just one slave. Can i set --log-slave-update on slave. I have mysql running on debain with 8 cpu and 8 GB RAM. Also in this link http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html Its says not to set --log-slave-update on slave, so does this apply only if there are more than one slave connecting to the same master, or does it apply also on setup with one master and one slave. regards anandkl -- Krishna Chandra Prajapati MySQL DBA, Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: --log-slave-update
so, we should not have --log-slave-update on slaves on setup with one master and multiple slaves...right. regards anandkl On 4/4/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: In case of master is down. Slave 1 has to be made as master and --log_slave_updates has to be removed. Slave2 will act as slave. There will be no duplicate key On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: But, it also says, that if slave1 is made master and if log-slave-update is set on it, then slave2 might receive data that it might have arleady got from the old master, which might cause errors like duplicate keys etc. On 4/3/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, There is nothing that, you can not enable log_slave_updates on slave. Basically, it is useful in a situation when you have 1 master and 2 or more slave in chain series. In this model 1st slave server should work as master as well as slave. So, log_slave_update and binlog can be enabled to log all the queries to binlog. In this way 2nd slave get the updates from 1st slave. Krishna Chandra Prajapati On Thu, Apr 3, 2008 at 12:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I have Master - Slave setup, with just one slave. Can i set --log-slave-update on slave. I have mysql running on debain with 8 cpu and 8 GB RAM. Also in this link http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html Its says not to set --log-slave-update on slave, so does this apply only if there are more than one slave connecting to the same master, or does it apply also on setup with one master and one slave. regards anandkl -- Krishna Chandra Prajapati MySQL DBA, Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: --log-slave-update
Master--Slave1/MasterSlave2 (Chain 1 to 1) Slave1 should have --log_slave_updates Master-Slave1/Slave2/Slave3. (Parallel 1 to many) --log_slave_updates is not required If all the slaves are in a single chain model then --log_slave_updates is required. Other in 1 to many model --log_slave_updates is not required Thanks, Krishna Chandra Prajapati On Fri, Apr 4, 2008 at 2:28 PM, Ananda Kumar [EMAIL PROTECTED] wrote: so, we should not have --log-slave-update on slaves on setup with one master and multiple slaves...right. regards anandkl On 4/4/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: In case of master is down. Slave 1 has to be made as master and --log_slave_updates has to be removed. Slave2 will act as slave. There will be no duplicate key On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: But, it also says, that if slave1 is made master and if log-slave-update is set on it, then slave2 might receive data that it might have arleady got from the old master, which might cause errors like duplicate keys etc. On 4/3/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, There is nothing that, you can not enable log_slave_updates on slave. Basically, it is useful in a situation when you have 1 master and 2 or more slave in chain series. In this model 1st slave server should work as master as well as slave. So, log_slave_update and binlog can be enabled to log all the queries to binlog. In this way 2nd slave get the updates from 1st slave. Krishna Chandra Prajapati On Thu, Apr 3, 2008 at 12:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I have Master - Slave setup, with just one slave. Can i set --log-slave-update on slave. I have mysql running on debain with 8 cpu and 8 GB RAM. Also in this link http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html Its says not to set --log-slave-update on slave, so does this apply only if there are more than one slave connecting to the same master, or does it apply also on setup with one master and one slave. regards anandkl -- Krishna Chandra Prajapati MySQL DBA, Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Re: --log-slave-update
thank u very much On 4/4/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Master--Slave1/MasterSlave2 (Chain 1 to 1) Slave1 should have --log_slave_updates Master-Slave1/Slave2/Slave3. (Parallel 1 to many) --log_slave_updates is not required If all the slaves are in a single chain model then --log_slave_updates is required. Other in 1 to many model --log_slave_updates is not required Thanks, Krishna Chandra Prajapati On Fri, Apr 4, 2008 at 2:28 PM, Ananda Kumar [EMAIL PROTECTED] wrote: so, we should not have --log-slave-update on slaves on setup with one master and multiple slaves...right. regards anandkl On 4/4/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: In case of master is down. Slave 1 has to be made as master and --log_slave_updates has to be removed. Slave2 will act as slave. There will be no duplicate key On Thu, Apr 3, 2008 at 1:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: But, it also says, that if slave1 is made master and if log-slave-update is set on it, then slave2 might receive data that it might have arleady got from the old master, which might cause errors like duplicate keys etc. On 4/3/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: Hi, There is nothing that, you can not enable log_slave_updates on slave. Basically, it is useful in a situation when you have 1 master and 2 or more slave in chain series. In this model 1st slave server should work as master as well as slave. So, log_slave_update and binlog can be enabled to log all the queries to binlog. In this way 2nd slave get the updates from 1st slave. Krishna Chandra Prajapati On Thu, Apr 3, 2008 at 12:02 PM, Ananda Kumar [EMAIL PROTECTED] wrote: Hi All, I have Master - Slave setup, with just one slave. Can i set --log-slave-update on slave. I have mysql running on debain with 8 cpu and 8 GB RAM. Also in this link http://dev.mysql.com/doc/refman/5.0/en/replication-solutions-switch.html Its says not to set --log-slave-update on slave, so does this apply only if there are more than one slave connecting to the same master, or does it apply also on setup with one master and one slave. regards anandkl -- Krishna Chandra Prajapati MySQL DBA, Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
Fwd: utf8_general_ci to utf8_polish_ci?
Hello, Excuse my ignorance please but I must not understand something about this post that I sent two weeks ago. It received NO responses and that usually means that I don't understand something about the content of it. Can anyone enlighten me on why? I thought it was a straight forward question? Thanks in advance for a reply. regards, mikesz This is a forwarded message From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Monday, March 24, 2008, 11:30:44 AM Subject: utf8_general_ci to utf8_polish_ci? ===8==Original message text=== Hello mysql, Here is the short version of my story. I have a database that was not correctly defined at creation time and is currently set to utf8_general_ci but needs to be utf8_polish_ci. Some Polish characters are displaying incorrectly and also some of the index references are not correct. I was thinking that exporting the data and recreating the database with the correct collation would solve the problem then I noticed in phpMyAdmin that I could copy the database with a different collation and wondered if that would be another way to get the correct solution. Any thoughts or comments on the right way to convert from utf8_general_ci to utf8_polish_ci? Thank you for your attention. -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 2967 (20080321) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com ===8===End of original message text=== -- Best regards, mikeszmailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replicate-rewrite-db
Hi, Any idea wat replicate-rewrite-db does with example..
Re: insert select
On Thu, 3 Apr 2008, Hiep Nguyen wrote: hi all, i have a question on insert ... select statement. tbl_1(fld1,fld2,fld3, ) fld1 int primary key auto_increment not null tbl_2(fld_a,fld_b,fld_c,...) how do i construct my select statement so that fld1 is auto increment? insert into tbl_1(fld1,fld2,fld3) select xxx, fld_b, NOW() from tbl_2 where fld_a = '5'; what should 'xxx' be??? my goal is to get fld1 = auto increment fld2 = fld_b fld3 = NOW() i saw someone used '1', other used null for xxx. i'm confused. thank you for all the helps that i got. i got this works. now i have more tables to do and wonder if this is possible to do in one statement. let say i have 3rd table (tbl_3) with fld_i, fld_ii, fld_iii, fld_iv and this is what i'm doing now after successfully inserted into tbl_1: select fld_i from tbl_3 where fld_i = fld_b limit 1; if record set != 1 insert into tbl_3 (fld_i) values (fld_b); in other word, insert a record into tbl_3 if and only if fld_d doesn't existing in tbl_3. here is the relationship between 3 tables: fld_2, fld_b, and fld_i are primary key of its respective table fld_2 = fld_b = fld_i this is the reason that i haven't try this with JOIN clause. thank you, t. hiep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lost my defaults on varchar columns?
It appears that since updating from mysql 5.0.44 to 5.0.54 I have also lost my DEFAULT option on all my varchar columns. For colums which are also NOT NULL this is causing a bunch of problems in my existing app (trying to insert NULLS) Anyone can explain what happened and why this has changed? Innodb if this makes a difference.. Thanks Ed W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Some way/tool to do this with database scripts backups
Hello guys if i have for example a simple table call person with 'id' and 'name' how columns i can do a backup and get some file (A.sql) with all the inserts statements here, all fine but how i can do this? for each insert statement generated in A.sql create a new B.sql, with update statements its possible do this? even worst, if a have a table with 20 columns i need the way to generate the same B.sql but with my desired columns to update thanks in advanced -- View this message in context: http://www.nabble.com/Some-way-tool-to-do-this-with-database-scripts-backups-tp16496072p16496072.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replicate-rewrite-db
On Fri, Apr 4, 2008 at 6:30 AM, Shanmugam, Dhandapani [EMAIL PROTECTED] wrote: Hi, Hi, Any idea wat replicate-rewrite-db does with example.. It takes statements for one database, and rewrites them into another. An example of the syntax would be this line in the my.cnf file of your slave: replicate-rewrite-db=master_db-master_db_foo Any statement on master_db would be replicated to the slave, but then executed on master_db_foo. So, for example: You execute 'update table1 set foo=4 where bar=2;' on the master_db on your replication master. The statement would get replicated down to the replication slave. When the slave is evaluating your replication rules, it will see that the statement should be rewritten to apply to the master_db_foo. Then 'update table1 set foo=4 where bar=2;' is executed on master_db_foo. Hope that helps, Dan
MySQL Server Instance Config Wizard
Hi, I just installed MySQL in my Windows 2003 server and I ran the configuration wizard. All seems to work correctly up to the point where it tries to start the service (almost at the end of the configuration) for which it fails and spits out an error message: Error No. 2003 Can't connect to MySQL server on 'LocalHost' (10061) The same error message suggests that I should make sure that my firewall has an exception for the service to run on port 3306 (which it does). I have really no idea why the service cannot be started and I would appreciate some help on figuring this out. Things I have already tried are listed below: *Turning off the Anti-virus *Turning off Windows firewall Thanks in advance! -BeasC -- View this message in context: http://www.nabble.com/MySQL-Server-Instance-Config-Wizard-tp16497722p16497722.html Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lenin Lakshminarayanan wants to chat
--- Lenin Lakshminarayanan wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-d0236098dc-db751a3970-a39b8136ed758afc You'll need to click this link to be able to chat with Lenin Lakshminarayanan. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Lenin Lakshminarayanan, visit: http://mail.google.com/mail/a-d0236098dc-db751a3970-b57925 Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client Gmail and Google Talk are still in beta. We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]