-


MySQL Services and Utilities:


  • Backup & recovery.
  • Security.
  • Replication.
  • Cluster.
  • Partitioning.
  • Workbench.

MySQL Replication :

Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves)

Replication is asynchronous by default

Startup Options for Replication Slaves
Server ID On the master and each slave a unique replication ID in the range from 1 to 232 − 1
Example my.cnf file:

[mysqld] server-id=3
--log-slave-updates
PropertyValue
Command-Line Format--log-slave-updates[={OFF|ON}]
System Variablelog_slave_updates
ScopeGlobal
DynamicNo
TypeBoolean
Default ValueOFF





Comments

Post a Comment

Popular posts from this blog

Redshift Architecture

-
Image
 An Amazon Redshift data warehouse is an enterprise-class relational database query and management system. Amazon Redshift is a fully managed highly scalable data warehouse service in AWS. Here is the list of features covered list of features components Amazon Redshit top features list : Leader Node Optimizing the Data Warehousing Compute Node Petabyte Scale Node Slices Automated Backups Massively Parallel Processing Restore the data fast Columnar Data Storage Network Isolation Data Compression Query Optimizer RedShift Spectrum Leader Node   Communication with data apps  Distribution of workloads  Caching of query results  Maintenance of catalog tables Compute Node ·        Handle all query processing, in parallel execution (MPP) ·        Dense compute no...
Read more