i have mysql master with 3 replicas in windows with lot of data (10-20 terabyte), we want to move to linux. how should i do that?
Yeah I understand that this might not work but worth the try :) Just to understand - You stop winslave3 —> export structure,tables(1by1) from winslave3 —> import in linslave1 ...
Anyone has experience with percona xtrabackup?
ok ok so the only reason taking winslave3 off (stop slave) is to reduce load and make sure this node is safe?
Because charset might be diff?
i dump data like the following: FIELDS TERMINATED BY '~' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' but when i have string column that has '~' inside it the whole l...
i have table that looks like this ``` CREATE TABLE public.vendor_category ( vendor_category_id serial4 NOT NULL, vendor_id int4 NULL, category_id int4 NULL, vendor_catego...
i have a list of 800k id’s that I need to update a single column for each of them? what’s the best approach doing this? create 800k update statments and run them? update table...
I tried to run dump on my replica (running on GCP) but I got this error - mysqldump: Couldn't execute 'SHOW FIELDS FROM `view_active_opportunities`': SELECT command denied t...
my user is defined like this: GRANT all PRIVILEGES ON *.* TO 'lirany’@‘%’ I am unable to connect to this if my VPN is off - why is that if it’s defined with %??? PLEASE SEND ...
is there a way to make this delete in a procedure but delete in chunks? delete from tb_opportunity__allowed_feed_types where opportunity_id in (select opp_id from delete_m1_op...
Hi maybe someone can help me understand the log file? ***returned rows*** 2021-08-26 12:11:59.283 UCT [11831] LOG: execute S_1: BEGIN 2021-08-26 12:11:59.287 UCT [11831] LOG:...
I have mySQL 5.7 - is it possible to cache VIEW results?
does postgresql has sharding architecture like mongo’s sharding? or it only has postgres_fdw?
how can I check if a query is causing a lock? and how can I kill other process/query to let me query run without locks?
how can I get all the tables that their first column is “id”? i would like to add those PK
How can I know if query results came from cache/buffer pool or the query is being run and retrive data from disk?
I am having troubles partitioning with pg_partman. when creating partition all partition key needs to be part of the primary key, so if i partition by datetime my primary key ...
How can I know when a query was running by reading mysql slow log? Time: 2022-06-25T23:22:12.134584Z User@Host: user[user] @ [1.1.1.1] thread_id: 12631872 server_id: 34534534...
i have issue with one of my users - it has those privs = GRANT USAGE ON *.* TO 'noamc'@'%' + GRANT SELECT, INSERT, UPDATE ON `smallstage_grouponi_groupon`.`tb_orders_items_csa...