Conside the chain as
A->B->C->D
where A is master, B is master to C and so on.
If C fails in between then B becomed to master to D. How do I achieve this using script which will check for any instance fails and will do automatically the new master -slave.
amit2781
Last Activity: Dec 28 '09, 08:51 AM
Joined: Jun 12 '09
Location:
-
How to write script for daisy chain replication topology ?
Hi,
Can you please provide me the any script which written for daisy chain replication topology?
Any help on this highly appreciated. -
Hi Atli,
Thanks for the prompt reply.
It is ok that there is no any official solution.
I have made the same setup using the details given in :
http://www.howtoforge.com/mysql_database_replication
Consider x.x.x.x - Slave , y.y.y.y - Master
My case is now my master(y.y.y.y. ) goes down and Slave(x.x.x.x) need to become a master.
I am doing the steps given...Leave a comment:
-
Is Mysql Switchover / Failover mechanisam supported prior to version 4.1?
Hi,
Does "Switching Masters During Failover" supports for prior to version 4.1?
I found this point in 5.0 onward manual and not in "MySQL 3.23/4.0/4.1" manual.
Can you please tell me it is supported in prior to 4.1 versions?
Regards,
Amit -
How to make Two-Way Replication Setup.
Hi,
I need setup like :
Consider, Master - A and Slave - B machine.
We do operations on master will replicate to Slave. But in case if
Case 1:
If master(A) goes down then slave (B) become a master. So changes on slave(B - which is now master) needs to replicate to master (A) when master (A) gets up.
Case 2.
If master(A) down and then up then... -
How to run sql script on MySQL 5.1.34 prompt.
Hi,
Can you please tell me how to run the sql script on mysql prompt?
I tried the command but not succesfull.
C:\MySQl\bin:> mysql --u=root --p=amit < mysql.sql
C:\MySQl\bin:>s ource < MySQL51amit_CL_ Inst_1.txt -
How to manage two MySQL library in one application.
Hi,
I am using two MySQL library in my application MySQL 4.0.13 and MySQl 5.1.34.
Old version library linked statically and New version is dynamically. It is on Solaris-10 platform.
There is no any interaction between these two in application.
While running application when I try to connect to MySQL server 5.1.34 using new version library( 5.1.34) it calls old version library function.
So... -
amit2781 replied to MySQL Build problem on HPUX platform."shared library must be position independent"in MySQLThanks for reply.
Basically I have gone through this PDF. So tried the option -fPIC, +Z already. But still it is giving me error.
My way is to try first everything What I can do and then I will take help of the different number of forum. It helps a lot for mot wasting much time after already had gone through the long investigation. These posts are also mine.Leave a comment:
-
amit2781 started a topic MySQL Build problem on HPUX platform."shared library must be position independent"in MySQLMySQL Build problem on HPUX platform."shared library must be position independent"
I am trying to build the my project on HPUX (HP-UX oscar B.11.11 U 9000/800 741028561 unlimited-user license) which access the Mysql library. But it is giving error as :
Error : MySQL51/lib/hpux/libmysqld.a(cli ent.o) - shared library must be position independent. Use +z or +Z to recompile.
I am using this option in building:
aCC -Wl,+s,-E,+vnocompatwar nings -z -g0 -b -Wl,-Bsymbolic.
I also tried... -
How do we get the Grantor oe Owner of the object for Grantee in MYSQL?
I went through all information_sch ema where I didn't found the Grantor or Owner Column instead everywhere found the only Grantee in user_privileges , table_privilege s?Leave a comment:
-
How to get Role information in MYSQL?
How can we get the role information in MYSQL?
Like we get in ORACLE from USER_ROLE_PRIVS table. -
How to get Role information in MYSQL?
How can we get the role information in MYSQL?
Like we get in ORACLE from USER_ROLE_PRIVS table. -
amit2781 replied to Get Dropped table info : table_schema information from information_schema.tablesin MySQLI am using MySQL 5.1.34.Leave a comment:
-
amit2781 started a topic Get Dropped table info : table_schema information from information_schema.tablesin MySQLGet Dropped table info : table_schema information from information_schema.tables
Hi,
I have created 4 tables in 'amit' database and then I deleted them. Still I able to get information about the table_schema for the table deleted.
After drop table when I fire a query for table_schema from information_sch ema.tables it will give me result as 'amit'. I didn't understand why it is happnes.
See the below steps done.
mysql> use amit;
mysql> show tables;
+----------------+... -
I have uninstalled MySQL 5.1.34 and tried to reinstalled but it is giving me error as :
The security settings could not be applied to the database because the connection has failed with the following error.
Error Nr. 1045
Access denied for user 'root'@'localho st' (using password: YES)
If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise...Leave a comment:
-
Hi,
I have created table -== account(acct_nu m INT, amount INT);
I have created view using
CREATE VIEW v AS SELECT acct_num AS value FROM account;
when I execute following :
mysql> select table_name from information_sch ema.views;
mysql> select table_name from information_sch ema.tables;
+------------+
| table_name |
+------------+
| v |...Leave a comment:
-
Yes it will give for the fields and not for the rows.
like
mysql> select column_name, column_type from information_sch ema.columns where table_name='acc ount' and table_schema='a mit';
---------------------------------------------
| column_name | column_type |
---------------------------------------------|
| acct_num | int(11) |
| amount | decimal(2,0) |
---------------------------------------------...Leave a comment:
-
I think it is right that What I require will get it from -
enum enum_field_type s Ex.
for TINY - 0, SMALLINT - 1 and so on.
As this is enum types so will consider the 0, 1, 2 ... so on.
But need to see in more details.
Thanks.Leave a comment:
-
How do I get the native data type like we get in ORACLE using
OCIAttrGet(colH andle, OCI_DTYPE_PARAM , (dvoid *) &dataType, 0,
OCI_ATTR_DATA_T YPE, m_errorHandle);
It will return &datatype value for:
VARCHAR2 - 1
NUMBER - 2
Date - 12
How do we achieve this in MYSQL 5.1?Leave a comment:
-
Thanks you very much Atli.
I solved my problem.Leave a comment:
No activity results to display
Leave a comment: