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
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
-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
[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
- 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
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
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
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,
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
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
10 matches
Mail list logo