does MySQL support master-master replication?
Can I use Group Replication for this case?
How can I write this query?
what MySQL can provide for this case?
How can I write this query any idea?
Have u seen this tables?
Do you speak Russian?
Is it possible to declare and use cursors with recursive cte?
does MySQL support master-master replication?
you can use an InnoDB cluster
In this article, I have explained the deployment process of the MySQL InnoDB cluster. In the first part, I have covered the process of mapping the Host and IP Address, creating user and grant appropriate rights and configure the group replication
Write a query to find the name (first_name, last_name), job, department ID and name of the employees who works in London.
what are the requirements
there are 3 independent separated stages (each stage will be used by own users)
each stage reads/writes to own database
each stage should be able to read data from other stages
therefore need to replicate databases
stage1 <-> stage2 <-> stage3
the channel between stages may disappear, sometimes for several hours
stages should not influence each other
if stage1 stopped/disappear, other stages should work as if nothing happened
How can I write this query any idea?
Are you student?
you should join the tables
from employees e
inner join jobs j on e.job_id=j.job_id
inner join departments d on e.department_id=d.department_id
inner join locations l on d.location_id=l.location_id
where l.city = ‘LONDON’
Actually there isn’t hardness limitations for questions. The main goal is clearness ))
Do you speak Russian?
Join main ru chat
Got mariadb mysql v8.5+ (cant remember straight) innodb AFAIK
Is it possible to declare and use cursors with recursive cte?
I tried this, but can’t get rid of syntax errors, and no im not banned on google – i couldn’t find whether this is totally impossible or any working examples.
Based on docs – it is possible.
My target is to grab non-existent intervals from binary heap table to later traverse through those intervals
DECLARE levels_looper cursor FOR
WITH RECURSIVE nodes_levels(level, nodemin,nodemax) AS (
SELECT 2, subtree_root_node_id*2, subtree_root_node_id*2+1
UNION ALL
SELECT level + 1, pow(2,level)*subtree_root_node_id, pow(2,level)*subtree_root_node_id+pow(2,level)-1
FROM nodes_levels
WHERE level <= levels_total+1)
SELECT level-1,nodemin,nodemax from nodes_levels;
Got mariadb mysql v8.5+ (cant remember straight) innodb AFAIK
Is it possible to declare and use cursors with recursive cte?
I tried this, but can’t get rid of syntax errors, and no im not banned on google – i couldn’t find whether this is totally impossible or any working examples.
Based on docs – it is possible.
My target is to grab non-existent intervals from binary heap table to later traverse through those intervals
DECLARE levels_looper cursor FOR
WITH RECURSIVE nodes_levels(level, nodemin,nodemax) AS (
SELECT 2, subtree_root_node_id*2, subtree_root_node_id*2+1
UNION ALL
SELECT level + 1, pow(2,level)*subtree_root_node_id, pow(2,level)*subtree_root_node_id+pow(2,level)-1
FROM nodes_levels
WHERE level <= levels_total+1)
SELECT level-1,nodemin,nodemax from nodes_levels;
Yebat’ ne uznal tyebia v maske