want that when master fails the slave will be the new master and do
everythink that the master has before done. So I have more time to repair the
master.
I have to change the slave to master because I need write access to the mySQL
databases.
Sure that when mySQL data on the master are damaged I will
u
> are ready to restart the master and replication.
Hi thanks for all the answers,
I only want that when master fails the slave will be the new master and do
everythink that the master has before done. So I have more time to repair the
master.
I have to change the slave to master because
Am 29.04.2016 um 20:49 schrieb william drescher:
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up
ge.net <mailto:h.rei...@thelounge.net>>>
wrote:
Am 29.04.2016 um 15:07 schrieb Johan De Meersman:
From: "Mahmoud Alshinhab"
mailto:mahmoud.alshin...@gmail.com>
<m
>>
>> It was actually built for Amazon's Aurora, but it should work
>> with any mysql-compatible protoco.
>>
>> --
>> Eng. Mahmoud Alshinhab
>> AWS Cloud Support Engineer
>> Fedora Ambassador
>> Wik
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they ar
From: "Mahmoud Alshinhab"
mailto:mahmoud.alshin...@gmail.com>>
Subject: Re: slave to master
I think you should have a look at MariaDB Connector[1].
It provides Load balancing and failover as Fail
pport Engineer
>> Fedora Ambassador
>> Wiki : https://fedoraproject.org/wiki/User:Tuxawy
>> mahmoud.alshin...@gmail.com
>> tux...@fedoraproject.org
>>
>> On Fri, Apr 29, 2016 at 3:13 PM, Reindl Harald
>> wrote:
>>
>>>
>>> Am 29.04.20
Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab:
Master/slave connection selection
It’s the application that has to decide to use master or slave
connection (the master connection is set by default).
Switching the type of connection is done by using JDBC
connection.setReadOnly(boolean readOnl
>> Am 29.04.2016 um 15:07 schrieb Johan De Meersman:
>>
>>> From: "Mahmoud Alshinhab"
>>>> Subject: Re: slave to master
>>>>
>>>
>>> I think you should have a look at MariaDB Connector[1].
>>>>
>>>
>>
at 3:13 PM, Reindl Harald
wrote:
>
> Am 29.04.2016 um 15:07 schrieb Johan De Meersman:
>
>> From: "Mahmoud Alshinhab"
>>> Subject: Re: slave to master
>>>
>>
>> I think you should have a look at MariaDB Connector[1].
>>>
&g
Am 29.04.2016 um 15:07 schrieb Johan De Meersman:
From: "Mahmoud Alshinhab"
Subject: Re: slave to master
I think you should have a look at MariaDB Connector[1].
It provides Load balancing and failover as Failover occurs when a connection to
a primary database server fai
> From: "Mahmoud Alshinhab"
> Subject: Re: slave to master
> I think you should have a look at MariaDB Connector[1].
> It provides Load balancing and failover as Failover occurs when a connection
> to
> a primary database server fails and the connector will open
> From: "Jason Mallory"
> > Subject: RE: slave to master
> >
> > Master-master with load balancer would be best
>
> That's a bit brief, isn't it? :-)
>
> It's more than worth pointing out that your loadbalancer should not
> actually be loadb
- Original Message -
> From: "Jason Mallory"
> Subject: RE: slave to master
>
> Master-master with load balancer would be best
That's a bit brief, isn't it? :-)
It's more than worth pointing out that your loadbalancer should not actually be
loadbal
@lists.mysql.com
Subject: slave to master
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they are
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they are
accessing the mySQL slave. Can the
- Mensaje original -
De: Manuel Arostegui
Para: Miguel Gonzalez
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
>
>
>
> Can you elaborate about this? I thought that once y
>[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
>http://www.mysql.com/why-mysql/white-papers/my
> -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
2013/3/21 Miguel Gonzalez
>
>
>
> 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 replication to avoid t
2013/3/21 Miguel González Castaños
> 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 promote a MySQL 5.5 sla
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 promote a MySQL 5.5 slave server when the
master (also 5.5) has cra
[EMAIL PROTECTED] wrote on 18/06/2004 15:09:58:
> I would need log-bin and log-slave-updates enabled on the slave,
correct?
>
> So to automate the process it would be better to start both servers
> without the Master-host info in the conf file, letting Heartbeat issue
the
> commands on star
necessary to have log-bin enabled in the event that you will be
promoting this server to master one day.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 6/18/04 9:09 AM
Subject: RE: Replication - promoting slave to master
I would need log-bin and log-slave-updates
L PROTECTED] '" <[EMAIL PROTECTED]>,
"'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
cc:
Subject:RE: Replication - promoting slave to master
Initially you should have set the slave up with log-bin in its my.cnf file
so that it is writing t
process statements where the server-id matches its own server-id.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 6/17/04 12:25 PM
Subject: Replication - promoting slave to master
Hello,
I've been lurking about the lists for a few months now, hoping to gain
Hello,
I've been lurking about the lists for a few months now, hoping to gain
some knowledge on MySQL's replication features for HA setup. I have a
fairly good understanding of the setup process, but I'm a little confused
on one points. We are running a 2 node - master-slave setup, and we are
How much difficulty is there in turning a MySQL replication server into a master?
On Mon, Apr 09, 2001 at 10:37:36AM +0530, MCA Department PESIT wrote:
> the error that i specifically get when the slave tries to connect to
> the master is
>
> 010409 10:44:58 Slave thread: error connecting to master:Can't connect to
> MySQL
> server on '192.168.1.2' (111)(107), retry
Hi there,
the error that i specifically get when the slave tries to connect to
the master is
010409 10:44:58 Slave thread: error connecting to master:Can't connect to
MySQL
server on '192.168.1.2' (111)(107), retry in 60 sec
even if i try to run mysql -h master the same error happens.
31 matches
Mail list logo