Explain MySQL resources Allocation and also explain file system security.
Posts
Describe Replication Architecture
Replication is a set technology for copying and distributing the data and database objects from one database to another database and synchronizing between database to maintain consistency. it is possible to create an identical copy of you primary database or synchronize changes between multiple database and maintain data consistency and integrity. Article: an article is the basic unit of SQL server. these include table, views and stored procedures, and user define function publication: a publication is logical collection of the article that exits on publisher. distributor: a publisher is a SQL server instance that has publication which contain the article to be published to subscribers. distributor: distributor collects the article from the publisher. and delivers them to subscribers. subscriber: a subscriber subscribes to one or more publication, it will receive each article in publication. subscription: a request for copy a publication that ...
