About Me

Passionate and flair for new technologies and databases. I enjoy working and learning about Databases and storage technologies. MySQL is my most favorite one  😉

I have 6+ Years of experience with MySQL Database, Along with this, I have knowledge of MongoDB, Oracle, MS-SQL databases.

Oracle-MySQL Certified:

MySQL Cloud Service 2018 Certified Implementation
Specialist

mysql-cloud-service-2018-certified-implementation-specialist_slogo         OCE_ODbSQL_clr

MySQL Architecture Ebook pdf :MySQL_Architecture_Guide

Feel Free to get in touch upon:

MySQL Training and Consulting

Email: lalitvc@gmail.com

Disclaimer: All views expressed on this site are my own and do not represent the opinions of any entity whatsoever with which I have been, am now, or will be affiliated.  

 

Advertisements

10 thoughts on “About Me

  1. Jaswinder June 15, 2015 / 10:56 am

    We want some customized Free Radius Work.

  2. Jagan September 9, 2017 / 3:39 pm

    Hey Lalit, A very good information given .Thanks, and it is useful to me.

    • lalit September 11, 2017 / 5:58 am

      Thank You, Jagan.

  3. Lalit Mohan December 26, 2017 / 5:52 pm

    Hi, Lalit Can you post on mysql cluster in which database A replicate itself and update when any query run on database A then it will also update on another database(clone)

    • lalit December 27, 2017 / 4:38 am

      Hi Lalit Mohan,
      Thank you for the ask.

      If you are talking about cloning database, that we can do using “MySQL Replication” [identical copy of a database/s on different machine]. And the other side, if you want to do horizontal scaling of your database/s by distributing data on different data nodes(machines) that is ” MySQL Clustering”.
      Let me know, which topic you want?

      • Lalit Mohan December 27, 2017 / 4:59 pm

        I need to setup Mysql cluster, actually need to update my second database(slave) automatically whenever update in master database i Know it may be done by replication master-slave but i’m not sure it will update slave database automatically. Actually it may or may not be remote database (slave) but I’m Magento developer need to use magento database replication to use in another application API so No effect on magento performance with high traffic .. Guide me to maintain consistency , ACID ,availability Thanks in advance

  4. lalit December 28, 2017 / 5:00 am

    In this case, you need “MySQL Replication” following could be the replication topology.

    Case 1:
    If you want to Split READ load then use MASTER-SLAVE with ACTIVE-PASSIVE Mode.

    In this, you can setup and configure replication such way that, All write operations will go on MASTER same will replicate on SLAVE and you can use this SLAVE for read operations for another application API.

    Case 2:
    If you want to split WRITE load by writing on both servers then use MASTER-MASTER Replication topology.

    It will allow you to write on both database server and data will sync between these DB servers real-time. [ Different Auto-increment sequence for primary keys needed to avoid conflicts and maintain uniqueness of data on both servers]

    Replication will give you required benefits as you want for your application like ACID, High Availability, and Read-write load balancing to manage high traffic on the database.

    I wrote MySQL High Availability post you can check that, [ It’s quite complicated process if you trying this first time]

    https://lalitvc.wordpress.com/2017/04/30/mysql-high-availability-with-keepalived-and-haproxy/

    Solution:

    Better to have Simple MySQL Replication topology
    MASTER-MASTER[ACTIVE-ACTIVE] or MASTER-SLAVE [ACTIVE-PASSIVE]

    It up to you how you want to split READ -WRITE Operations.

    Will Write Replication Blog in 2-3 days.

    Will your application WRITE on both database servers? or you just want another database replica for read operations?

    NOTE: Replication replicated data real-time on the slave by default.

    • Lalit Mohan February 18, 2018 / 6:38 pm

      Thanks Lalit for your time and reply on mail . Have you write blog on that ?? Please provide link

      • lalit February 19, 2018 / 9:04 am

        Hi Lalit,

        I didn’t get time for blog writing from few days. I will try to write something on it soon.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s