Can a same virtual ip be created for two servers?

|
ysf_cms 2022-04-18 16:57:21
I am using opencart. When I search for products in opencart, my site is slow, ttfb is very high. Does anyone know about this?
smlkw 2022-04-18 17:02:32
ysf_cms 2022-04-18 16:57:21
I am using opencart. When I search for products in opencart, my site is slow, ttfb is very high. Does anyone know about this?

Maybe your server is not powerful or your product list is long

ysf_cms 2022-04-18 17:57:50
smlkw 2022-04-18 17:02:32
Maybe your server is not powerful or your product list is long

200.000 products

svart 2022-04-18 17:59:05
ysf_cms 2022-04-18 16:57:21
I am using opencart. When I search for products in opencart, my site is slow, ttfb is very high. Does anyone know about this?

Optimise your database

ysf_cms 2022-04-18 19:22:15
svart 2022-04-18 17:59:05
Optimise your database

Convert innodb and add index it was good , ttfb 25 sn. Down 7.8 sn but it enough yet

ysf_cms 2022-04-18 19:22:52
svart 2022-04-18 17:59:05
Optimise your database

Is there any document on this subject that I can read?

Abhayofficia 2022-04-19 11:51:16
I have mysql master and one slave 5.7 version
Sometime slave unable to resolve the query

I want to kill the long running query
Can anyone help with the script

King Nagendra 2022-04-19 15:40:24
Hi
I am using frontend backend MySQL db
Frontend is not communicating with backend and backend also not communicating with MySQL.

I am getting this error
Connection exception connection refused

Can you any give me tips

Paynalton 2022-04-19 17:11:45
Hi, i have a strange problem with a function.
Paynalton 2022-04-19 17:11:47
CREATE DEFINER=admin@% FUNCTION chocomilk.getCodigo() RETURNS char(8) CHARSET utf8mb4
DETERMINISTIC
BEGIN
SET @codigo= ”;
SET @chars = ‘ABCEFGHJKLMNOPRSTUVWXYZ23456789’;
SET @clen= LENGTH(@chars);
SET @ind = 0;
SET @R = 0;
SET @ex = 0;
b: LOOP
a: LOOP
IF @ind >= 8 THEN
LEAVE a;
END IF;
SET @ind=@ind + 1;
SET @R = FLOOR(RAND()*(@clen-1)+1);
SET @codigo = CONCAT(@codigo,SUBSTRING(@chars,@R,1));
END LOOP a;
select count(*) into @ex from participaciones p where p.code = @codigo COLLATE utf8mb4_general_ci;
IF @ex = 0 THEN
leave b;
END IF;
END LOOP b;
return @codigo COLLATE utf8mb4_general_ci ;
END
Paynalton 2022-04-19 17:12:31
when i create this function from a migration program on PHP
Paynalton 2022-04-19 17:12:44
it returns latin_1 collation
Paynalton 2022-04-19 17:13:13
but when i create this from dbveaber client
Paynalton 2022-04-19 17:13:38
it returns utf8mb4 collation
Paynalton 2022-04-19 17:14:05
same function, diferent database client, diferen result when execute it
Jitendra bansal 2022-04-19 20:34:08
Any one pls share subquery exercises
Chenna Reddy 2022-04-20 04:58:18
Any buddy give support to msql dba
Chenna Reddy 2022-04-20 04:58:39
Give me number
Karthik 2022-04-20 12:10:29
does anyone know how to limit number of rows coming inside group concat alone, pls tell
smlkw 2022-04-20 13:02:38
Karthik 2022-04-20 12:10:29
does anyone know how to limit number of rows coming inside group concat alone, pls tell

show your query

2022-04-20 19:30:50
Hi guys, I am looking for website that has a lot of examples of data model
Can anyone help me ?
smlkw 2022-04-20 20:03:30
2022-04-20 19:30:50
Hi guys, I am looking for website that has a lot of examples of data model
Can anyone help me ?

what do you mean?

2022-04-20 20:35:01
smlkw 2022-04-20 20:03:30
what do you mean?

I need free database models

smlkw 2022-04-20 20:35:24
2022-04-20 20:35:01
I need free database models

which models, can you give an example?

2022-04-20 20:37:03
smlkw 2022-04-20 20:35:24
which models, can you give an example?

mysql_en-19946.jpg
like this

smlkw 2022-04-20 20:55:24
2022-04-20 20:37:03
like this

Ah, I see

I never seen such a website, hope someone here will help you

ChildProcessError 2022-04-20 22:57:13
I have 2 tables
Users and Connections
Users have information about each user with their id as primary-key
and Connections have their id as Foreign-key
imagine i add multiple user id into Connections
and after a few moments i want to select a row where the user have specific information in their Users table row
what should i do?

link to the question in stackover flow

sea1011 2022-04-21 04:04:59
Biggest scam
Abhayofficia 2022-04-21 05:34:59
Admin block them
Vikash Raj 2022-04-21 05:44:37
2022-04-20 20:37:03
like this

But This is a just a ER diagram

Janoory @ 2022-04-21 06:09:56
Hlo team if anybody can send mysql based resumes for freshers
Dude 2022-04-21 08:48:33
Hi Everyone ,
Trying to implement keepalived for MySQL routers.

I have doubts on Virtual IP.

Can a same virtual ip be created for two servers? How does keepalived uses the virtual ip to switchover.

Ganesh 2022-04-21 09:01:26
U need to sear free IP on u r network
During proxysql setup u need to provide vip
svart 2022-04-21 10:41:32
Dude 2022-04-21 08:48:33
Hi Everyone ,
Trying to implement keepalived for MySQL routers.

I have doubts on Virtual IP.

Can a same virtual ip be created for two servers? How does keepalived uses the virtual ip to switchover.

VIP is a free IP address. keepalived daemon will monitor if VIP is assigned currently. if not it will try to assign it locally. assignment done based on the state, wait and so on. rtfm

smlkw 2022-04-21 12:06:14
Abhayofficia 2022-04-21 05:34:59
Admin block them

Done

|