Cloud -Database-Solutions

Connect to the instance using Microsoft SQL Management Studio Double Click SQL Server Agent Right Click on Operators and select New Operator USE [msdb] GO /****** Object:  Operator [ DBA]    Script Date: 6/9/2015 5:50:44 AM ******/ EXEC msdb.dbo.sp_add_operator @name=N' DBA',   @enabled=1,   @weekday_pager_start_time=0,   @weekday_pager_end_time=235959,   @saturday_pager_start_time=0,   @saturday_pager_end_time=235959,   @sunday_pager_start_time=0,   @sunday_pager_end_time=235959,   @pager_days=127,   @email_address=N'xxyy@z.com,   @category_name=N'[Uncategorized]' GO

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 2 32  − 1 Example  my.cnf  file: [mysqld] server-id = 3 --log-slave-updates Property Value Command-Line Format --log-slave-updates[={OFF|ON}] System Variable log_slave_updates Scope Global Dynamic No Type Boolean Default Value OFF

MySQL Storage Engine Architecture Indicates that an engine is available mysql> SHOW ENGINES\G Table 13.1. Storage Engine Features Feature MyISAM Memory InnoDB Archive NDB Storage limits 256TB RAM 64TB None 384EB Transactions No No Yes No Yes Locking granularity Table Table Row Row Row MVCC No No Yes No No Geospatial data type support Yes No Yes Yes Yes Geospatial indexing support Yes No No No No B-tree indexes Yes Yes Yes No Yes Hash indexes No Yes No No Yes Full-text search indexes Yes No No No No Clustered indexes No No Yes No No Data caches No N/A Yes No Yes Index caches Yes N/A Yes No Yes Compressed data Yes [ a ] No Yes [ b ] Yes No Encrypted data [ c ] Yes Yes Yes Yes Yes Cluster database support No No No No Yes Replication support [ d ] Yes Yes Yes Yes Yes Foreign key support No No Yes No No Backup / point-in-time recovery [ e ] Yes Yes Yes Yes Yes Query cache support Yes Yes Yes Yes Yes Update statistics for data dictionary Yes Yes Yes Ye...

MySQL Architecture InnoDB Architecture In-memory and On-disk structures that comprise the  InnoDB  storage engine architecture MySQL Storage Engine Architecture