Does anyone have experience in synchronizing 2 MySQL databases?
Which one should be typed here to be referred to the encoder I want?
Is MASTER who send information to SLAVE?
would you like to consider reading official documentation?
Anyone from TCS ?
15 is not taken inyo consideration ?
By using events concept
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?
ok
Which one should be typed here to be referred to the encoder I want?
https://github.com/WWBN/AVideo/issues/6955
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
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
Package -4.5Lpa
Fresher
Backdoor process
Charges-2 months salary
For more details message me personally
Hi!! 2000 members and no chat, no discussion, no suggestions ..? 😔
Weekend effect
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
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?
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
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?
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?
then replication won’t work for you since replica pulls logs
consider to try tungsten replicator or any other tool which can apply binary logs to the remote database
I read official mysql documentation, but unfortunately I can’t solve this question. Now, with your comments I did it. Thank you.
What?
Is there any script or link for MySQL health report
Is there any script or link for MySQL health report
Here is the link http://google.com
Svart : I am not MySQL guy, that’s why I asked link or scripts
Photo from Vinesh Anand
Photo from Vinesh Anand
why 999999,0.15 is not taken inyo consideration ?
why 999999,0.15 is not taken inyo consideration ?
Bill value calculated on the base of usage limit
Bill value calculated on the base of usage limit
Can you give example calculation for PlanB
= 1500 + 2500 + 3000 + 450
= 7450