Did you try "PhpMyAdmin"?
On Thu, Apr 20, 2017 at 3:12 PM, Zach Lym wrote:
> I convinced my boss to use MariaDB for a new project but it appears
> that the workbench is incompatible with new features of MariaDB. I've
> looked at the alternatives listed on the website, but they are all
> either
Hello,
I have "mydump.sql" with dump of all databases in cluster. I am trying to
selectively restore one database only from the scenario below:
Have created 2 databases: test1 and test2 with table "person":
+---+--+--+-+-+---+
| Field | Type | Null | Key
What can case the following problem?
[Warning] WSREP: Failed to prepare for incremental state transfer: Local
state UUID (----) does not match group
state UUID (2cd97600-0e4e-11e7-997a-0a414b1bb17e): 1 (Operation not
permitted)
at galera/src/replicator_str.cpp:
t; why don't you just use MyISAM if you don't have suiteable ressources
> what is the content of your "my.cnf"
>
> if your container is oom killed you likely don't have enough physical
> ressources for your dataset and should fix that properly instead cripple
> dow
#x27;t come with random solutions instead describe your problem properly
> and show your real config - the subject of this thread is nonsense and the
> options below are *not* your problem in real life
>
> Am 03.01.2017 um 20:13 schrieb l vic:
>
>> How's
How's about max_binlog_cache_size or max_binlog_stmt_cache_size ?
max_binlog_cache_size defaults to 18446744073709547520
Can it be more than available RAM ?
On Fri, Dec 30, 2016 at 9:55 AM, Reindl Harald
wrote:
>
>
> Am 30.12.2016 um 14:20 schrieb l vic:
>
>> and what sh
ndl Harald
wrote:
>
>
> Am 28.12.2016 um 19:47 schrieb l vic:
>
>> Is there some way to set hard limit for use of RAM by mariaDB server?
>>
>
> and what should happen after reach it?
> a hard stop?
>
> why don't you just configure your server to match your
fers but as long as you keep connections low and don't mess around with
> temp tables, you should usually be fine with those.
>
> On Wed, Dec 28, 2016 at 8:16 PM l vic wrote:
>
>> You mean innodb_buffer_pool_size to use 60% of RAM, correct?
>>
>> On Wed, Dec 28, 2016 a
o limit that size.
>
> On Wed, Dec 28, 2016 at 8:04 PM l vic wrote:
>
>> Hi Guillaume,
>> Already do, kind of
>> I run it (mariadb ) in docker, as Mesos task;
>> The problem: if memory use by mysqld exceeds limit allocated to mesos
>> task, we have oom and
> Use linux control groups, or even simpler, run MariaDB with Docker (which
> uses control groups as well):
>
> docker run --name mariadb -d -m 10G mariadb:10.1
>
> On Wed, Dec 28, 2016 at 7:48 PM l vic wrote:
>
>> Is there some way to set hard limit for use of RAM by
Is there some way to set hard limit for use of RAM by mariaDB server?
Thanks,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https:
Seems like it only happens during or after SST. I wonder if this may happen
because of data inconsistency...
On Thu, Dec 22, 2016 at 2:27 PM, Vladislav Vaintroub
wrote:
>
>
> On 22.12.2016 17:38, l vic wrote:
>
>> I run this query every minute and I have this exception after
server closes the socket, and what happened otherwise, I do not
> know. The error log hints at memory shortage.
>
> On 21.12.2016 20:45, l vic wrote:
>
> Have the following error trace from running
> SHOW STATUS LIKE 'wsrep_%'
> Any idea what could cause it?
>
>
Have the following error trace from running
SHOW STATUS LIKE 'wsrep_%'
Any idea what could cause it?
2016-12-21 3:39:24 139668819036928 [Note] InnoDB: Online DDL : End of
applying row log
2016-12-21 3:39:24 139668819036928 [Note] InnoDB: Online DDL : Completed
2016-12-21 3:43:29 139668818733824
t’s a new cluster ?
>
> /svar
>
> Stéphane Varoqui, Senior Consultant
> Phone: +33 695-926-401, skype: svaroqui
> http://www.mariadb.com
>
> Le 19 Dec 2016 à 22:25, l vic a écrit :
>
> i have installed mariadb 1.10.13 cluster with user "root", password "pass&quo
i have installed mariadb 1.10.13 cluster with user "root", password "pass"
I have created test database "galeratest":
CREATE DATABASE galeratest;USE galeratest;CREATE TABLE test_table (
id INT PRIMARY KEY AUTO_INCREMENT,
msg TEXT ) ENGINE=InnoDB;INSERT INTO test_table (msg)
Hello,
I see the problem with one of the secondary nodes successfully joining the
cluster:
the cluster_size=3 and it stays this way but database server in container
is dead, e.g. nothing listening on the port 3306
Is there possible scenario for the node with failed database server to join
the clust
How long can it take for a node to sync during a rejoin? Is there system
variable setting that limit?
Thanks,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~ma
How long can it take for a node to sync during a rejoin? Is there
environmental variable for that?
Thanks,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mari
t;
> if you have only 2 nodes : Quorum requires a majority, meaning that you
> cannot have automatic failover in a two node cluster. This is because the
> failure of one causes the remaining node automatically go into a
> non-primary state.
>
>
> Diego.
>
> On W
i have the following jdbc exception in my jdbc client for the node 1 after
another node (node2) is removed:
om.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: WSREP
has not yet prepared node for application use
at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown So
Is there online docs to describe Galera in detail, such as specs/RFC?
Thanks,
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://h
P: Requesting state
transfer: success, donor: 1
2016-11-08 20:38:24 139911323707136 [Warning] WSREP: 1.0 (): State transfer
to 0.0 () failed: -255 (Unknown error 255)
On Tue, Nov 8, 2016 at 12:54 PM, Nirbhay Choubey
wrote:
>
>
> On Tue, Nov 8, 2016 at 11:32 AM, l vic wrote:
>
>>
Why exactly do you want to increase it?
because i think dns may slow down rsync
On Tue, Nov 8, 2016 at 3:42 PM, Nirbhay Choubey wrote:
> Hi,
>
> On Tue, Nov 8, 2016 at 2:22 PM, l vic wrote:
>
>> Is it possible to increase rsync timeout? I checked
>> http://galerac
PM, Nirbhay Choubey
wrote:
>
>
> On Tue, Nov 8, 2016 at 11:32 AM, l vic wrote:
>
>> How can i determine the donor node? Would that be seed node?
>>
>
> On the joiner you will see the following:
>
> 2016-11-08 12:13:57 140589576218368 [Note] WSREP: Member 1.0 (node2
Is it possible to increase rsync timeout? I checked
http://galeracluster.com/documentation-webpages/galeraparameters.html
but couldn't find corresponding parameters...
Thanks,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-d
I don't see any log entries pertaining to node3 join on the donor nodes
On Tue, Nov 8, 2016 at 11:04 AM, Nirbhay Choubey
wrote:
>
>
> On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote:
>
>> Have the rsync failure (see the trace below):
>>
>> 2016-11-08 15:17:34 13
How can i determine the donor node? Would that be seed node?
Thank you
On Tue, Nov 8, 2016 at 11:04 AM, Nirbhay Choubey
wrote:
>
>
> On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote:
>
>> Have the rsync failure (see the trace below):
>>
>> 2016-11-08 15:17:34 1399598
Have the rsync failure (see the trace below):
2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready
' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos'
--datadir '/var/lib/mysql/' --parent '114' ''
Read: '(null)'
2016-11-08 15:17:34 139959897945856 [ERROR] W
I see intermittent failure for some nodes to join cluster (see below):
2016-11-01 17:24:22 140050125105920 [Warning] WSREP: Failed to prepare for
incremental state transfer: Local state UUID
(----) does not match group state UUID
(fdb9a4a3-a056-11e6-a01d-5a15e8d77e8
Do I need to use "--wsrep-node-name" option with dns names to identify the
node in Galera cluster instead of "wsrep-node-address", or is the
"--wsrep-node-address=" supposed to work?
Thanks,
___
Mailing list: https://launchpad.net/~maria-discuss
Post to
Erik-
>
>
> On 10/18/2016 11:46 PM, Nirbhay Choubey wrote:
>
>
>
> On Tue, Oct 18, 2016 at 4:28 PM, l vic wrote:
>
>> I am trying to use dns hostnames vs. ip addresses in mariadb container
>> configuration:
>> --wsrep-cluster-address=gcomm://node1.clus
I am trying to use dns hostnames vs. ip addresses in mariadb container
configuration:
--wsrep-cluster-address=gcomm://node1.cluster1.mesos,node2.cluster1.mesos..
--wsrep_node_address=node1.cluster1.mesos
--wsrep-new-cluster
..
but i see galera error:
WSREP: Failed to resolve tcp://node1.cluster1.me
n Oct 5, 2016, at 3:47 PM, Markus Mäkelä
> wrote:
>
> MaxScale does have a simple sharding module: https://mariadb.com/kb/en/
> mariadb-maxscale-14/maxscale-routers-schemarouter-router/
>
> Markus
>
> On 05/10/16 22:36, l vic wrote:
>
> Isn't Maxscale a loadbala
Vitess Vs Maxscale. Thank you.
>
> On Wed, Oct 5, 2016 at 11:21 PM, l vic wrote:
>
>> I wonder how to use sharding with symmetric replication... Does that mean
>> I have to partition every database instance? Does it work with third-party
&
I wonder how to use sharding with symmetric replication... Does that mean I
have to partition every database instance? Does it work with third-party
tools, like Vitess (http://vitess.io/)?
Thanks
___
Mailing list: https://launchpad.net/~maria-discuss
Post
M, Daniel Black
wrote:
>
> http://galeracluster.com/documentation-webpages/
> mysqlwsrepoptions.html#wsrep-notify-cmd
>
> This script will be executed on all nodes so you'll definitely detect it.
>
> On 29/09/16 04:04, l vic wrote:
> > How can i detect eviction of nod
How can i detect eviction of node from the cluster from
"information_schema" other than decreasing of WSREP_CLUSTER_SIZE?
Thanks,
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://
Is there is a good way to remove a node from a galera cluster besides just
killing it? / Are there are any implications of killing a node?
Thanks,
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsub
"xtrabackup", would that be sufficient? Any
opensource solutions like that?
Thank you.
-V
On Sun, Sep 18, 2016 at 11:51 AM, Lukas Lehner wrote:
> why you need that?
>
> what platform the GUI should run?
>
> MySQL Enterprise Backup has a GUI, but you need to pay $$$
Is there any open source front end tool for Xtrabackup?
Thanks,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchp
Tue, Aug 23, 2016 at 4:52 PM, Reindl Harald
> wrote:
>
>>
>>
>> Am 23.08.2016 um 13:17 schrieb l vic:
>>
>>> Is replication between different data centers supported in MariaDB and
>>> is it supported in open source version, or in enterprise only?
>&g
Is replication between different data centers supported in MariaDB and is
it supported in open source version, or in enterprise only?
Thank you,
-V
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Un
43 matches
Mail list logo
