Zero database downtime using the Federated storage engine and Replication

3 April 5:30PM - 8:20PM @ Community Networking Welcome Reception

Experience level: 
Lightning talks
A familiar issue for Database Administrators is how to migrate their 24/7 mission critical application databases to new servers without any database downtime. By using the Federated storage engine and MySQL Replication techniques, it is possible to migrate large databases from one server instance to other server instance without any downtime. The method is particularly useful when the target instance is configured in a master-master active/passive pair where normal replication Mysql Master-Slave replication is not an option. The presentation shows how this can be achieved by: • Creating a new instance alongside the old instance with minimal configuration • Creating the databases & tables in the new instance –tables should be created using the FEDERATED STORAGE ENGINE • Configuring a Federated link (federated server) between the new instance and the target instance. • Configuring master-slave replication between the OLD and the new instance • Repointing the application to the target instance All the database activities do not require any downtime to configure and setup.


DBA Consultant, BBC
I am having 10 years of experience in multiple RDBMS technologies on various versions (Oracle 8i/9i,10g/11g, Mysql 3.x/4.x/5.x,Postgres 7.x/8.x, SQL server 7/2000/2005/2008). Having extensive experience in managing very large databases in Banking , Retail , Publishing and ISP domains. As a lead DBA provided Database Administration services to clients around the globe including ones in India,UK,USA and Singapore.Having vast experience in transitions, technical proposals, Disaster Recovery & HA solutions and creating COE. Created and designed curriculum for MySQL database administration for senior DBAs. Conducted several database administrations sessions for junior and senior DBAs. I am having Engineering Degree from Madras University and certified Oracle 9i/10g DBA. Received several awards on innovation, customer delight , best team and team player category. Currently providing Database consultation service.