Does anyone have experience in synchronizing 2 MySQL databases?

|
Suriya P 2022-09-09 21:22:18
SANATH 2022-09-09 20:39:52
I need to dump the query given by developer from one server database to the other server database every 15 mins….. please try to help me to solve this…. Thanks in advance

By using events concept

jordifnz 2022-09-10 00:44:51
jordifnz 2022-09-08 16:37:22
Hi all!
I’m trying to define a synced environment between 2 MySQL 8.0.29 servers, but I’m not sure how can I do it:
1) There’re 2 methods: classic and transaction?
2) Classic method is master -> slave way or slave asks to master?
3) By your experience, what’s the best method?
4) Do you have any manual to follow? I’m only finding documents that explain an overview, not in dept (step by step)

Hi! Does anyone have experience in synchronizing 2 MySQL databases?

sara sara 2022-09-10 07:55:51
mysql_en-24820.jpg
ok
Which one should be typed here to be referred to the encoder I want?

https://github.com/WWBN/AVideo/issues/6955

Megha 2022-09-10 08:01:28
Training and Placement on informatica
100% job Guarantee Program

Our office
pune : Kharadi, City vista
hyderabad : Kukatpally
Bengalore : Forum mall

Contact no:
Swapana 93981 62283
(Hyderabad Branch)

Megha 88301 74326
(Pune Branch)

ramana 63097 60407
(Bengalore Branch)
[Head of All Branches]

Training link
Daily 9am
Zoom meeting id 9712818534

Mahesh 2022-09-11 09:51:21
MySQL Tutorial for Beginners FULL COURSE – Part 2

MySQL Tutorial For Beginners Part 2: Database Manipulation Language (DML) CommandsYouTube
This video explains about the topics mentioned below:
1) Different types of SQL commands
2) Create/Drop Database
3) Create table
4) Insert data into table
5) Selecting rows from a table
6) SQL Datatypes
7) WHERE clause
8) Logical operators(AND, OR , NOT)
9) BETWEEN and IN operators
10) Pattern Matching operators

Checkout the Playlists:
👉 Java Tutorial For Beginners:

👉 Design Patterns in Java

👉 Tricky Java Interview Questions

👉 Important Java Programs for Interview:
https://www.youtube.com/watch?v=Dhcy6mcNbx8&list=PLzte2IQYFUVG0Q3rEFQzGa_eFKIUGwZIZ

👉 How to Avoid Common Mistakes as a Java Beginner

👉 Interview Coding Challenges

👉 MySQL Tutorial For Beginners:

👉 What is Agile | Understanding Agile Software Development Process:

👉 Selenium with Java Tutorial For Beginners:
https://www.youtube.com/watch?v=FtbszUgPxUY&list=PLzte2IQYFUVEvMsjxPSSTQ5CcLMcQhw9M

LIKE | SHARE | SUBSCRIBE 😊

👇👇👇
Follow me on
LinkedIn: https://www.linkedin.com/in/mahesh-babu-mande-65920724/
Telegram: https://t.me/techstack9
Twitter: https://twitter.com/mahesh1049

RR 2022-09-11 12:40:36
accenture
Package -4.5Lpa
Fresher
Backdoor process
Charges-2 months salary
For more details message me personally
jordifnz 2022-09-11 12:45:31
jordifnz 2022-09-10 00:44:51
Hi! Does anyone have experience in synchronizing 2 MySQL databases?

Hi!! 2000 members and no chat, no discussion, no suggestions ..? 😔

Swapnil 2022-09-11 13:39:35
jordifnz 2022-09-11 12:45:31
Hi!! 2000 members and no chat, no discussion, no suggestions ..? 😔

Weekend effect

jordifnz 2022-09-11 13:43:28
That must be…! I will wait until tomorrow to see if someones gives me their opinion on what is the best method for sync 2 MySQL databases 😆
svart 2022-09-11 14:02:28
jordifnz 2022-09-08 16:37:22
Hi all!
I’m trying to define a synced environment between 2 MySQL 8.0.29 servers, but I’m not sure how can I do it:
1) There’re 2 methods: classic and transaction?
2) Classic method is master -> slave way or slave asks to master?
3) By your experience, what’s the best method?
4) Do you have any manual to follow? I’m only finding documents that explain an overview, not in dept (step by step)

Replication Vs galera. Choose wisely based on your requirements since these approaches are different

jordifnz 2022-09-11 17:20:00
svart 2022-09-11 14:02:28
Replication Vs galera. Choose wisely based on your requirements since these approaches are different

Thank you so much for your answer!
In my case I don’t want a HA environment, I need to replicate all data to an other server in order to provide an “off-line” environment only for reading but with the data refresh in the minimum period of time.
In this case I think I can discard galera…
I read that there are 2 methods to do replication with MySQL: native (binlog) and other (transactional) but I can’t find the benefits of each one or other, and no information about this second method “transactional” and who I should implement if… have you some acknowledge on that?

svart 2022-09-11 18:34:09
jordifnz 2022-09-11 17:20:00
Thank you so much for your answer!
In my case I don’t want a HA environment, I need to replicate all data to an other server in order to provide an “off-line” environment only for reading but with the data refresh in the minimum period of time.
In this case I think I can discard galera…
I read that there are 2 methods to do replication with MySQL: native (binlog) and other (transactional) but I can’t find the benefits of each one or other, and no information about this second method “transactional” and who I should implement if… have you some acknowledge on that?

i have no idea what does “transactional replication” means. never read about it

jordifnz 2022-09-11 18:35:10
And the “binlog” method… do you tried it?
svart 2022-09-11 18:36:02
yes
jordifnz 2022-09-11 18:36:51
I can’t understand the way os the communication between master and slave…
Is MASTER who send information to SLAVE?
Or the master “puts” all the information in binlog file and the SLAVE calls to MASTER in order to ask for the data and insert in own database?
jordifnz 2022-09-11 18:38:17
I have a firewall requerimientos than only allow the traffic from MASTER to SLAVE, and not in the reverse way, and I don’t know if this replica method fits to my environment
svart 2022-09-11 18:38:31
jordifnz 2022-09-11 18:36:51
I can’t understand the way os the communication between master and slave…
Is MASTER who send information to SLAVE?
Or the master “puts” all the information in binlog file and the SLAVE calls to MASTER in order to ask for the data and insert in own database?

would you like to consider reading official documentation?

svart 2022-09-11 18:39:39
jordifnz 2022-09-11 18:38:17
I have a firewall requerimientos than only allow the traffic from MASTER to SLAVE, and not in the reverse way, and I don’t know if this replica method fits to my environment

then replication won’t work for you since replica pulls logs

svart 2022-09-11 18:41:16
jordifnz 2022-09-11 18:38:17
I have a firewall requerimientos than only allow the traffic from MASTER to SLAVE, and not in the reverse way, and I don’t know if this replica method fits to my environment

consider to try tungsten replicator or any other tool which can apply binary logs to the remote database

jordifnz 2022-09-11 18:42:15
svart 2022-09-11 18:38:31
would you like to consider reading official documentation?

I read official mysql documentation, but unfortunately I can’t solve this question. Now, with your comments I did it. Thank you.

jordifnz 2022-09-11 18:43:07
I will check documentation of Tungsten, it looks well!
sk33p34 2022-09-12 10:22:43
anyone doing the actuirial science paper..? today
smlkw 2022-09-12 10:34:14
sk33p34 2022-09-12 10:22:43
anyone doing the actuirial science paper..? today

What?

sk33p34 2022-09-12 10:34:38
the technical acturial exam UK time 9:00 am
N K 2022-09-12 10:44:08
Hi,

Is there any script or link for MySQL health report

N K 2022-09-12 17:23:23
Anyone from TCS ?
svart 2022-09-12 17:31:30
N K 2022-09-12 10:44:08
Hi,

Is there any script or link for MySQL health report

Here is the link http://google.com

N K 2022-09-12 17:39:58
svart 2022-09-12 17:31:30
Here is the link http://google.com

Svart : I am not MySQL guy, that’s why I asked link or scripts

Vinesh Anand 2022-09-12 18:18:28
mysql_en-24878.jpg
Photo from Vinesh Anand
Vinesh Anand 2022-09-12 18:18:41
Guys I need help for this task
Vinesh Anand 2022-09-12 18:20:20
I need a script to find bill value in mysql
Swapnil 2022-09-12 18:23:03
Vinesh Anand 2022-09-12 18:18:28
mysql_en-24878.jpg
Photo from Vinesh Anand

why 999999,0.15 is not taken inyo consideration ?

Vinesh Anand 2022-09-12 18:23:58
Swapnil 2022-09-12 18:23:03
mysql_en-24878.jpg
why 999999,0.15 is not taken inyo consideration ?

Bill value calculated on the base of usage limit

Swapnil 2022-09-12 18:26:41
Vinesh Anand 2022-09-12 18:23:58
mysql_en-24878.jpg
Bill value calculated on the base of usage limit

Can you give example calculation for PlanB

Vinesh Anand 2022-09-12 18:33:52
=>5000*0.30+10000*0.25+15000*0.20+3000*0.15

= 1500 + 2500 + 3000 + 450
= 7450

|