Re: slave to master

2016-04-29 Thread Reindl Harald
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

Re: slave to master

2016-04-29 Thread Reindl Harald
Am 29.04.2016 um 22:22 schrieb Mahmoud Alshinhab: I was think of it from the cloud prospective, as for example you can guarantee that Amazon's Elastic Load Balancer won't be a single point of failure, so I was thinking how can I use MariaDB MaxScale and in the same time guarantee that it won't

Re: slave to master

2016-04-29 Thread Mahmoud Alshinhab
I was think of it from the cloud prospective, as for example you can guarantee that Amazon's Elastic Load Balancer won't be a single point of failure, so I was thinking how can I use MariaDB MaxScale and in the same time guarantee that it won't be a single point of failure. -- Eng. Mahmoud Alshinh

Re: slave to master

2016-04-29 Thread 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 the programms on the slave by hand and then they ar

Re: slave to master

2016-04-29 Thread Reindl Harald
Am 29.04.2016 um 17:27 schrieb Mahmoud Alshinhab: I also like the MariaDB Max scale that Reindl Harald Sent -Thanks- However I don't know if it is possible to use 2 servers of the max scale with a load balancer in front of them or not. I always try to avoid the Single Point of Failure get rid

Re: slave to master

2016-04-29 Thread Mahmoud Alshinhab
I also like the MariaDB Max scale that Reindl Harald Sent -Thanks- However I don't know if it is possible to use 2 servers of the max scale with a load balancer in front of them or not. I always try to avoid the Single Point of Failure. "https://mariadb.com/products/mariadb-maxscale/how-maxscale-w

Re: slave to master

2016-04-29 Thread Reindl Harald
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

Re: slave to master

2016-04-29 Thread Mahmoud Alshinhab
I quote this from the page[1]: Load balancing implementation Random picking When initializing a connection or after a failed connection, the connector will attempt to connect to a host with a certain role (slave/master). The connection is selected randomly among the valid hosts. Thereafter, all st

Re: slave to master

2016-04-29 Thread Mahmoud Alshinhab
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 Wiki : https://fedoraproject.org/wiki/User:Tuxawy mahmoud.alshin...@gmail.com tux...@fedoraproject.org On Fri, Apr 29, 2016 at 3:

Re: slave to master

2016-04-29 Thread Reindl Harald
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 fails and the connecto

Re: slave to master

2016-04-29 Thread 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 fails and the connector will open up a connection to > another dat

Re: slave to master

2016-04-29 Thread Mahmoud Alshinhab
Hi, 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 up a connection to another database server. For example, server A has the current connection. Af

Re: slave to master

2016-04-29 Thread Johan De Meersman
- 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 loadbalancing the connections; master-master r