MySQL Master Master Replication Over SSL (Encrypted Channel)

Подписаться 3,5 тыс.

Просмотров 5 тыс.

50% 1

This video provides a hands on walk through as well as explanation of various configuration parameters used to configure MySQL replication. This video helps you understand MySQL Master/Slave Replication, Master/Master Replication and specially MySQl Master Master Replication over SSL or Encrypted Channel. Databases contain critical data and should be protected. It is also crucial that high availability is maintained by replicating the database into geographically distributed database servers.In order to avoid unauthorized access of the data in transit, it is very important to encrypt the communication between the database servers as well as any client server communications. This Video tutorial will show you how to perform encryption to the MySQL connections for replication or for general client/server usage.
Buy Me Coffee:
www.buymeacoff...

Опубликовано:

18 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 9

@gressplener 2 года назад

Splendid stuff! :)

@balireddyrakesh3648 4 года назад

Sir, I am very much confused about auto-incremental-offset, i have seen your previous video also.. Can give me example if i am 4 servers what will be the configuration ?

@AmitNepal 4 года назад

Auto increment increment has to be the total number of servers and the offset be 1,2,3,4 on each server. See here : www.amitnepal.com/mysql-master-master-replication/

@omidjavedan3477 5 лет назад

Hi How To Configure Nginx with SSL as a Reverse Proxy? Thanks

@AmitNepal 5 лет назад

For MySQL or you mean as a webserver in general ?

@MuhammadBadiuzZaman 5 лет назад

Thanks for this tutorials but i already made this Master Master replication without SSL. i am new with Mysql kinda things. my question is that is this safe for production environment to use Master Master Replication ? and second is that what is the case for Failure / Disaster Recovery .

@AmitNepal 5 лет назад

Well you can configure MySQL master master replication but use only one server for writing. When there is a need to fail over, you just switch the server. Since both are master either side will catch up.

@MuhammadBadiuzZaman 5 лет назад

@@AmitNepal how can i achieve that ? one server writing thing, because currently both can write and read. also one more question my boss ask me what if two users work on same db and same table and they both enter a data into it which users data will replication first and will there any loss of data or overwrite.

@ayyadevararajaram7648 4 года назад

Amit .. Really Great work.. i am new to Mysql.. i am trying replication through SSL at my work place.. .. Do you have any steps documented for this replication through SSL?