discuss

discuss@lists.mariadb.org

July 2013

18 participants
22 discussions

[Maria-discuss] Mysql resource limits.
by Rafał Radecki 02 Jul '13

02 Jul '13

Hi All. I would like to limit resources available to a given user in mysql. I know that there is https://dev.mysql.com/doc/refman/5.5/en/user-resources.html, I also know that cgroups can be used at operating system level. What are your experiences in limiting resources in mysql? I've used percona statistics and had information provided by it. Are there any better solutions? Best regards, Rafal Radecki.

1 0

[Maria-discuss] New Question: Local state seqno out of sync with group
by AskMonty KB 02 Jul '13

02 Jul '13

Hello, A new question has been asked in "Galera" by uxbod: -------------------------------- We have MariaDB and Galera working in our lab on a three node cluster. When setting them up the wsrep options for each node were as follows: {{{ node1: wsrep_cluster_address="gcomm://" node2: wsrep_cluster_address="gcomm://172.30.1.3" node3: wsrep_cluster_address="gcomm://172.30.1.1" }}} Once all the nodes were in sync I shutdown node1 and set its wsrep_cluster_address to be 172.30.1.2. This I thought would allow the three nodes to keep in sync. What happened though was when I started MariaDB backup I received the error: {{{ 130702 8:35:51 [ERROR] WSREP: Local state seqno (16053) is greater than group seqno (15898): states diverged. Aborting to avoid potential data loss. Remove '/var/lib/mysql//grastate.dat' file and restart if you wish to continue. (FATAL) at galera/src/replicator_str.cpp:state_transfer_required():34 }}} Why has this happened ? Is it safe to proceed with the recommendation of removing grastate.dat ? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/local-state-seqno-out-of-sync-with-group/

1 0