How to do a local mysql database replication on an online server?

AWS RDS MySQL vs AWS RDS SQL Server?

• Amazon RDS MySQL vs Amazon RDS SQLServer I have a data size of about 30-50 GB and its all in SQL Server 2008 present in physical servers. I am thinking of moving my data to cloud and I am considering Amazon web services as a solution. Now Amazon provides both MySQL and SQLServer and I am trying to figure out which database is the most seamlessly and efficiently supported. SQLServer in AWS is a very new service. My requirements are following : Scalability (should be provided for both the databases) Replication One important thing is that recently there has been a lot of news about Oracle trying to kill MySQL . link --> http://techcrunch.com/2012/08/18/oracle-makes-more-moves-to-kill-open-source-mysql/ What would the implications of this be on Amazon MySQl service. Also besides this I dont think integration of the current db into Amazon should be a problem but how well are both db supported in Amazon. I am looking for a detailed and clear answer. Thanks! EDIT 1 : I am still looking for a thorough answer. Does anybody have any idea how well is SQLserver supported in AWS ?

• Answer:

  Pros of moving to RDS mysql than RDS Sqlserver. 1)Read-Replicas: You can utilize the mysql built-in replication features For read-heavy database workloads by creating Read Replicas. 2)Availability: To increase database availability you could use the Multi-az http://feature.In the event of DB Instance failure or an Availability Zone failure, Amazon RDS will automatically failover to the standby so that database operations. 3) VPC's: Only Mysql instances can be configured in VPC.With Amazon VPC, you can define a virtual network topology and customize the network configuration to closely resemble a traditional network that you might operate in your own datacenter. 4)High SLA: Amazon RDS recently came out of Beta and also offered a higher SLA(99.95%) for Multi-az instances which is currently available only for MysQl and Oracle http://aws.amazon.com/rds-sla/ That said , there are many features in RDS Sqlserver that makes it stand out from the rest of the SQLserver hosting products. It is new compared to RDS Mysql but is quite stable. 1) Restore :RDS offers backup/restore, while SQL Azure does not. The SQL Azure must be configured manually using existing tools which causes additional bandwidth. 2)Scalability : You can scale your databases up or down. Also, there might be SQLServer features from your current implementation that you might miss in RDS Sqlserver. Features that are yet to be implemented on RDS MS Sqlserver are: Maintenance Plans Database Mail Transparent Data Encryption Database Log Shipping Database Mirroring Windows Authentication Replication The ability to run Reporting, Analysis, Integration, or Master Data Services on the same server as the DB Instance Performance Data Collector Additional T-SQL endpoints Distribution Transaction Coordinator (MSDTC) WCF Data Services FILESTREAM support Policy-Based Management SQL Server Audit In the end , if you are seriously considering using the Replication features, I would recommend moving to RDS MySql.