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.
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/
