Is your MySQL running when you restart pc?

|
@BNREDDY 2020-02-13 07:52:12
Any one send my Sql marteri
vksingh5198 2020-02-13 21:03:02
anyone say about best book of mysql
vksingh5198 2020-02-13 21:05:37
please suggest best book of mysql
vksingh5198 2020-02-13 21:05:56
or where to learn mysql query
piterden 2020-02-13 21:06:25
there are a few books right here
piterden 2020-02-13 21:06:34
check them out
vksingh5198 2020-02-13 21:08:11
send link please
piterden 2020-02-13 21:10:06
look to the chat’s files list
sagarwalke295 2020-02-13 22:49:10
smlkw 2020-02-12 14:08:19
Provide more information

mysql_en-1943.jpg

sagarwalke295 2020-02-13 22:49:25
Table in given link as xls file
MasterZiv 2020-02-14 00:41:46
sagarwalke295 2020-02-13 22:49:10

are you serious?

MasterZiv 2020-02-14 00:42:13
sagarwalke295 2020-02-13 22:49:10

good joke !

madno 2020-02-14 01:15:55
Which clustering technology gives better performance and easy maintenance
1. Innodb cluster
2. Galeria cluster
3. Percona xtradb cluster
sagarwalke295 2020-02-14 06:48:22
MasterZiv 2020-02-14 00:42:13
good joke !

What is joke here bro

Balu504 2020-02-14 06:48:50
Hi Good Morning all, I want to learn MySQL for Administration side can anyone please share Videos or links tq.
Mayank Maheshwari 2020-02-14 08:13:23
madno 2020-02-14 01:15:55
Which clustering technology gives better performance and easy maintenance
1. Innodb cluster
2. Galeria cluster
3. Percona xtradb cluster

Galaera cluster we are using …but better z percona ..if any help required n galera let me know

madno 2020-02-14 08:58:32
Mayank Maheshwari 2020-02-14 08:13:23
Galaera cluster we are using …but better z percona ..if any help required n galera let me know

I want my app to connect to a single port …and let the cluster take care of the read and write splitting. HA and DR is the foremost point here

madno 2020-02-14 08:59:12
Mayank Maheshwari 2020-02-14 08:13:23
Galaera cluster we are using …but better z percona ..if any help required n galera let me know

Is that possible bin percona?

Mayank Maheshwari 2020-02-14 09:00:36
madno 2020-02-14 08:58:32
I want my app to connect to a single port …and let the cluster take care of the read and write splitting. HA and DR is the foremost point here

This will be achieved by haproxy here Ur app hit only one single IP or any port

madno 2020-02-14 09:03:18
Mayank Maheshwari 2020-02-14 09:00:36
This will be achieved by haproxy here Ur app hit only one single IP or any port

I did a proxysql with master slave set up for read write but client wants DR also..Do you think clustering will be a good option or any other way we can do??

Mayank Maheshwari 2020-02-14 09:05:45
madno 2020-02-14 09:03:18
I did a proxysql with master slave set up for read write but client wants DR also..Do you think clustering will be a good option or any other way we can do??

Clustering z ok…because we have have DR 2 servers at Delhi and 2 in Mumbai and all 4 server in cluster ……Nd proxy IP given to application team for the operation

2020-02-14 09:06:01
mstar:
DELIMITER $$ DROP PROCEDURE IF EXISTS number$$ CREATE PROCEDURE number() BEGIN DECLARE x INT; DECLARE even VARCHAR(255); DECLARE str longtext; SET x = 1; SET str = ”; loop_label: LOOP IF x > 1000 THEN LEAVE loop_label; END IF; SET x = x + 1; IF (x mod 2) THEN ITERATE loop_label; ELSE SET str = CONCAT(str,x,’,’); END IF; END LOOP; SELECT str; END$$ DELIMITER ;

It’s my procedure but I need change to the number in runtime

madno 2020-02-14 09:08:22
Mayank Maheshwari 2020-02-14 09:05:45
Clustering z ok…because we have have DR 2 servers at Delhi and 2 in Mumbai and all 4 server in cluster ……Nd proxy IP given to application team for the operation

In your setup if u don’t have proxy layer ,client will connect to one ip and port of the cluster master??

Mayank Maheshwari 2020-02-14 09:10:05
No issue in cluster all are treat as master so connect any of the node
madno 2020-02-14 09:10:42
If you can provide me the configuration steps for galera and haproxy it would be helpful
piterden 2020-02-14 09:13:21
DELIMITER $$
DROP PROCEDURE IF EXISTS number$$
CREATE PROCEDURE number() BEGIN DECLARE x INT;
DECLARE even VARCHAR(255);
DECLARE str longtext;
SET x = 1;
SET str = ”;
loop_label: LOOP
IF x > 1000 THEN LEAVE loop_label;
END IF;
SET x = x + 1;
IF (x mod 2) THEN ITERATE loop_label;
ELSE SET str = CONCAT(str,x,’,’);
END IF;
END LOOP;
SELECT str;
END$$ DELIMITER;
Mayank Maheshwari 2020-02-14 09:13:34
madno 2020-02-14 09:10:42
If you can provide me the configuration steps for galera and haproxy it would be helpful

No issue….

Mayank Maheshwari 2020-02-14 09:14:57
mysql_en-1965.jpg
Like here any of 3 IP u can hit any of the IP…it replicate on all…
piterden 2020-02-14 09:15:04
Noissue noisy
Mayank Maheshwari 2020-02-14 09:16:30
madno 2020-02-14 09:10:42
If you can provide me the configuration steps for galera and haproxy it would be helpful

It’s hold lock for long time if lots of bulk operation…if need to do bulk operations then do in chunks

madno 2020-02-14 09:17:17
Mayank Maheshwari 2020-02-14 09:16:30
It’s hold lock for long time if lots of bulk operation…if need to do bulk operations then do in chunks

How is the cluster performance in your environment

Mayank Maheshwari 2020-02-14 09:18:03
It’s fine …only we have 10crore data Nd most of the operation z of select
2020-02-14 09:18:41
piterden 2020-02-14 09:13:21
DELIMITER $$
DROP PROCEDURE IF EXISTS number$$
CREATE PROCEDURE number() BEGIN DECLARE x INT;
DECLARE even VARCHAR(255);
DECLARE str longtext;
SET x = 1;
SET str = ”;
loop_label: LOOP
IF x > 1000 THEN LEAVE loop_label;
END IF;
SET x = x + 1;
IF (x mod 2) THEN ITERATE loop_label;
ELSE SET str = CONCAT(str,x,’,’);
END IF;
END LOOP;
SELECT str;
END$$ DELIMITER;

I will change at x value in runtime

Mayank Maheshwari 2020-02-14 09:18:47
Better to implement on staging and give to team testing
2020-02-14 10:20:54
odd numbers between two numbers in my sql stored procedure
Mayank Maheshwari 2020-02-14 11:49:50
Can we use before insert after insert in single trigger
HK 2020-02-15 07:02:17
Hi everyone….I’m looking for a guide for MySQL PT and MySQL with Linux docker…
HK 2020-02-15 07:03:00
Please share…if anyone…have these guides
HK 2020-02-15 07:03:53
And how to configure auto backup…in MySQL…?
2020-02-15 11:48:38
Can anyone help
2020-02-15 11:48:41
mysql_en-1984.jpg
What is the error
madno 2020-02-15 11:49:45
HK 2020-02-15 07:03:53
And how to configure auto backup…in MySQL…?

U want a script to backup MySQL?

HK 2020-02-15 11:53:07
No…I just want to know…how to schedule….auto backup…
Kenn_Adams 2020-02-15 16:10:30
2020-02-15 11:48:41
What is the error

That’s not the right syntax to add dates to table..
And also keep in mind how you created the table and what’s the data type of date column

Kenn_Adams 2020-02-15 16:11:03
2020-02-15 11:48:41
What is the error

If you had done a simple Google search you wouldn’t be having this problem.

Kenn_Adams 2020-02-15 16:11:10
2020-02-15 11:48:41
What is the error

https://stackoverflow.com/questions/34329852/how-to-insert-date-values-into-table

How to insert date values into tableStack Overflow
How can I insert into table with different input using / ,with date datatype?

insert into run(id,name,dob)values(&id,’&name’,[what should I write here?]);
I’m using oracle 10g.

iswathik 2020-02-15 17:12:32
mysql_en-1993.jpg
Hi Guys, I am seeing this error. Every time I restart my pc. I will have to reconfigure MySQL to make it work again… Is there any solution for this?
Master Yoda 2020-02-15 17:51:00
iswathik 2020-02-15 17:12:32
Hi Guys, I am seeing this error. Every time I restart my pc. I will have to reconfigure MySQL to make it work again… Is there any solution for this?

Is your MySQL running when you restart pc? Check this

Master Yoda 2020-02-15 17:51:54
HK 2020-02-15 07:03:53
And how to configure auto backup…in MySQL…?

Cron can help

Mayank Maheshwari 2020-02-15 17:54:08
HK 2020-02-15 11:53:07
No…I just want to know…how to schedule….auto backup…

Hitesh…just schedule the script through cronjob which we take backup and gzip the backup..

|