Re: slave to master
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.
Eng. Mahmoud Alshinhab
AWS Cloud Support Engineer
Wiki : https://fedoraproject.org/wiki/User:Tuxawy
On Fri, Apr 29, 2016 at 5:20 PM, Mahmoud Alshinhab <
> I quote this from the page:
> 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
> statements will run on that database server until the connection will be
> closed (or fails).
> The load-balancing will includes a pooling mechanism. Example: when
> creating a pool of 60 connections, each one will use a random host. With 3
> master hosts, the pool will have about 20 connections to each host.
> Master/slave distributed load
> For a cluster composed of masters and slaves on connection initialization,
> there will be 2 underlying connections: one with a master host, another
> with a slave host. Only one connection is used at a time.
> For a cluster composed of master hosts only, each connection has only one
> underlying connection.
> The load will be distributed due to the random distribution of
> 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
> method. Setting read-only to true will use the slave connection, false, the
> master connection.
> So I think it is not implemented yet. as "the application has to decide to
> use master or slave connection (the master connection is set by default)."
> Eng. Mahmoud Alshinhab
> AWS Cloud Support Engineer
> Fedora Ambassador
> Wiki : https://fedoraproject.org/wiki/User:Tuxawy
> On Fri, Apr 29, 2016 at 5:14 PM, Mahmoud Alshinhab <
> mahmoud.alshinhab@xxxxxxxxx> wrote:
>> 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
>> On Fri, Apr 29, 2016 at 3:13 PM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>
>>> Am 29.04.2016 um 15:07 schrieb Johan De Meersman:
>>>> From: "Mahmoud Alshinhab" <mahmoud.alshinhab@xxxxxxxxx>
>>>>> Subject: Re: slave to master
>>>> I think you should have a look at MariaDB Connector.
>>>> 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.
>>>> Hmm, I didn't know that they built that into it, interesting. Does it
>>>> require server features, or would it work with any mysql-compatible
>>>> protocol ?
>>>> Load balancing allows load (read and write) to be distributed over
>>>> Is read-write splitting also built-in, then?
>>> here you go: https://mariadb.com/de/products/mariadb-maxscale and
>>> forget about "MariaDB Connector" whatever that is