Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
2013/3/21 Miguel González Castaños miguel_3_gonza...@yahoo.es Dear all, I have a pretty simple setup. A LAMP server in production and a failover LAMP server in case the main server is down. I have been searching around to find out a clear answer of how to proceed when you need to

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
2013/3/21 Miguel Gonzalez miguel_3_gonza...@yahoo.es Can you elaborate about this? I thought that once you fixed the issues in the master server you needed to set it as slave of the new promoted master server, and do the other way round. That's why you might want to have master-master

RE: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Andrew Morgan
-Original Message- From: Miguel Gonzalez [mailto:miguel_3_gonza...@yahoo.es] Sent: 21 March 2013 08:29 To: Manuel Arostegui Cc: mysql@lists.mysql.com Subject: Re: Promoting MySQL 5.5 slave to master - Mensaje original - De: Manuel Arostegui man...@tuenti.com

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Miguel Gonzalez
[AM] If you've the option to use MySQL 5.6 then managing replication is a lot simpler and more reliable... http://www.clusterdb.com/mysql-replication/mysql-5-6-ga-replication-enhancements/ MySQL 5.6 Failing over is described in section 5 of

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Miguel Gonzalez
- Mensaje original - De: Manuel Arostegui man...@tuenti.com Para: Miguel Gonzalez miguel_3_gonza...@yahoo.es CC: mysql@lists.mysql.com Enviado: Jueves 21 de marzo de 2013 9:17 Asunto: Re: Promoting MySQL 5.5 slave to master 2013/3/21 Miguel Gonzalez miguel_3_gonza...@yahoo.es Can

Re: Foreign key on multiple columns

2013-03-21 Thread Peter Brawley
On 2013-03-21 8:12 AM, Norah Jones wrote: I'm trying to create a foreign key on two columns but getting error... Here's what I tried: CREATE TABLE test2 ( ID INT NOT NULL AUTO_INCREMENT, col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (ID), CONSTRAINT

compiling mysql-5.6.10 on solaris10 64bit sparc

2013-03-21 Thread Felix
Hi, Im trying to compile mysql-5.6.10 for Solaris10 for sparc, I used the following parameters for cmake to get it to work, but at 80% the compilation fails. WITH_INNOBASE_STORAGE_ENGINE=1 DEFAULT_CHARSET=utf8 CMAKE_C_FLAGS=-m64 CMAKE_C_COMPILER=/opt/csw/bin/gcc CMAKE_CXX_FLAGS=-m64

Re: Foreign key on multiple columns

2013-03-21 Thread shawn green
On 3/21/2013 12:43 PM, Abhishek Choudhary wrote: CREATE TABLE test2 ( ID INT NOT NULL AUTO_INCREMENT, col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (ID), CONSTRAINT fk FOREIGN KEY (col1, col2) REFERENCES test1(ID,

Re: Foreign key on multiple columns

2013-03-21 Thread Abhishek Choudhary
      CREATE TABLE test2 (         ID INT NOT NULL AUTO_INCREMENT,         col1 INT NOT NULL,         col2 INT NOT NULL,         PRIMARY KEY (ID),         CONSTRAINT fk FOREIGN KEY (col1, col2)                       REFERENCES test1(ID, ID)         ON UPDATE CASCADE         ON DELETE RESTRICT      

RE: MySQL Error#: 2002

2013-03-21 Thread Stillman, Benjamin
Assuming you copied and pasted the error, it looks like the host made a typo in the config file: '/var/lib/myswl/mysql.sock' Should probably be mysql, not myswl. -Original Message- From: Rick James [mailto:rja...@yahoo-inc.com] Sent: Monday, March 18, 2013 3:32 PM To: Patrice