HOW DO WE EXCLUDE SQL FROM REPLICATING IN MYSQL
If you’re using MySQL Replication, in few cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…
History of MySQL
Inception MySQL was created by a Swedish company MySQL AB in 1995. The developers of the platform were Michael Widenius (Monty), David Axmark and Allan Larsson. The foremost purpose was to provide efficient and reliable data management options to…
SSH issues with Incomplete SOE Build VMs
Do you have issues with you SSH in your lab/test VMs which has no proper builds and thus it’s effecting SSH Tectia functionality. No issues, below works for me – please have a try. Not sure how far this is…
MySQL : Functions
DELETE WITH LIMIT helps when there are duplicate records in the DB and you want to keep only few records from them and wanted to delete the rest of all. LIMIT with DELETE Query :- mysql>…
MySQL : Replication Error 1062
One of the common error in MySQL Replication is ‘Duplicate Entry’ – Error 1062. This pop-ups only if there are any manual intervention. The SQL Thread stops with this error. Just check the record in the error on both master…
MySQL- SUBSTRING_INDEX – Select Patterns
Consider, a MySQL table having values in a column like below: SELECT location FROM geo LIMIT 3; “location” “India.Karnataka.Shimoga.Gopala” “India.Karnataka.Bengaluru.BTM” “India.Karnataka.Chikmaglore.Koppa” My requirement is to take only 4th value from each of the rows(such as, Gopala,BTM,Koppa). I don’t want to…
MySQL’s INTO OUTFILE for loading file
MySQL: SELECT / LOAD in Batch Here’s are the MySQL commands to extract data from table and to load data into tables. Unlike other DBMS, MySQL offers SELECT..INTO.. and LOAD DATA.. commands are quite faster and convenient. Data would be…
How do we exclude SQL from replicating in MySQL
If you’re using MySQL Replication, in rare cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…
MySQL Installation
While you have a basic idea about MySQL, I would recommend the real-time trial and error than just reading out. For that, download a latest stable community version of MySQL from the official website. Though MySQL is platform independent, its…
MongoDB vs MySQL
Here is a comparison between MongoDB and Relational database, MySQL: Because of distributed key value store, MapReduce calculation capability and document oriented NoSQL features, MongoDB® is The database for Big Data processing.