Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 1876

MariaDB Galera Cluster is a synchronous multi-master cluster.

1
vote
It depends. While danblack is stating valid stuff, there is another dimension to the Question. Yes, all the writes on the Master must be repeated on each Slave. But not necessarily in the same form …
answered Jan 29 by Rick James
0
votes
You say "and the values get updated"... I assume this means that you are UPDATEing your VIEW? Well, a VIEW can be syntactic sugar around a SELECT or an UPDATE. The net effect of UPDATE myView ... i …
answered Dec 18 '18 by Rick James
3
votes
. AUTO_INCREMENT: The INSERT reserves the id before the operation. In some cases, it will reserve an id but then not use it. Example: INSERT IGNORE when it hits a dup key. Galera (and any other … you may see lots of gaps. Also you may "see" id=124 "before" id=123 shows up. More tips on moving to Galera and InnoDB …
answered Nov 12 '18 by Rick James
0
votes
Tips on the slow queries. This is a wimpy list of suggestions, CREATE TABLE and the table sizes might help. Is the INSERT...SELECT being done repeatedly? Could it be done incrementally? As in, co …
answered Jan 4 by Rick James
2
votes
User error. Since when does an ip look like 41.205.7.198, 176.9.19.101? 444079-41.205.7.198, 1 implies that 41.205.7.198, 1 was what was used as the ip. That's the first 15 characters, so I guess y …
answered Jan 6 '16 by Rick James
0
votes
This handles the "critical read" problem you describe: SET SESSION wsrep_sync_wait = 1; SELECT ... SET SESSION wsrep_sync_wait = 0; More discussion.
answered Oct 6 '18 by Rick James
0
votes
My Mantra: "You can only throw hardware at a performance problem once; it's better to look for a software solution." Deleting lots of rows is costly because it saves the old rows in case of a power …
answered Jan 3 by Rick James
2
votes
, Galera is turned off. Do you have it ON for production? If you are using normal replication, consider sync_binlog = ON. 6 Table scans / second. Half of queries involve a table scan. Let's see some more …
answered Jan 8 by Rick James
0
votes
(This does not answer the question asked, but it may eliminate the problem.) Sounds like you are missing the composite INDEX($col1, $col2) (in either order). And the table is rather large. Between …
answered Jun 6 '17 by Rick James
1
vote
If the Pis are the source of the data, use "multi-source" replication from them to MariaDB. Then have 3 nodes for the cluster (2 is mostly useless), and have all the data for both databases on all th …
answered Sep 11 by Rick James
0
votes
You are writing to the 'one' node? That is, you are treating it as the only Master? Galera does "Row Based Replication", so it probably does not need to open the table definition on the 'Slaves'? Do you have the same values for SHOW VARIABLES LIKE 'table%'; on all nodes? …
answered Jan 5 '16 by Rick James
2
votes
Plan A: Using just the nodes of the cluster: take a node out of the cluster: SET GLOBAL wsrep_desync = ON; SET GLOBAL wsrep_on = OFF; (See wsrep_desync and wsrep_on.) back it up via Xtrabackup (or …
answered Nov 27 '17 by Rick James
1
vote
By "site redundant", do you mean that you have 1 node in each of 3 different datacenters? Is your goal to survive any single point of failure? Including a hard crash of any one server or even one da …
answered Jan 11 '17 by Rick James
2
votes
I don't know how to translate your tables into any of n_active_users; n_users_created_classified; n_user_sent_msg; n_user_read_msg. But here are some clues: A simple query for the immediately preced …
answered Jan 10 '16 by Rick James
0
votes
problem, relative to somehow focusing some sets of queries onto a single node. Do you have "critical reads"? How are you handling them? More Galera tips . …
answered Apr 13 '17 by Rick James

15 30 50 per page