Mysql
Páginas: 24 (5867 palabras)
Publicado: 1 de mayo de 2012
MySQL with Windows Server 2008 R2 Failover Clustering
Delivering High Availability with MySQL on Windows
A MySQL® White Paper
September 2011
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Table of Contents
Summary .........................................................................................................3 Value of MySQL on Windows.......................................................................3 Approaches to High Availability with MySQL .............................................4 MySQL Replication ....................................................................................6 MySQL Cluster ..........................................................................................7 Introduction to Windows Server 2008 R2Failover Clustering ..................7 Setting up MySQL with Windows Server 2008 R2 Failover Clustering ....8 Target Configuration ..................................................................................8 Pre-Requisites ...........................................................................................9 Steps to Configure MySQL for Windows Failover Clustering.................10 Step 1. Configure iSCSI in software (optional) .....................................10 Step 2. Ensure Windows Failover Clustering is enabled .....................12 Step 3. Install MySQL as a service on both servers ............................13 Step 4. Migrate MySQL binaries & data to shared storage ..................13 Step 5. Create Windows Failover Cluster............................................15 Step 6. Create Cluster of MySQL Servers within Windows Cluster .....17 Step 7. (Optional) Add asynchronous replication to an external slave 19 Step 8. Test the cluster .........................................................................19 Step 9. MySQL Upgrades.....................................................................22 Conclusion....................................................................................................23 Additional Resources ..................................................................................23
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Page 2
Summary
Microsoft Windows is consistently ranked as the top development platform for MySQL, and outranks any individualLinux distribution as the leading platform for MySQL deployments, according to surveys of the MySQL user community. For Windows customers, the advantages of using MySQL are clear: low Total Cost of Ownership (TCO); broad platform support and ease-of-use. With the release of MySQL 5.5, Oracle demonstrated the benefits of focused development activity for the Windows platform with significantenhancements in performance and scalability. MySQL delivered over 5x higher throughput than previous MySQL releases on Windows. 1 Following the certification and support of MySQL with Windows Server Failover Clustering (WSFC), organizations can now safely deploy business-critical applications demanding high levels of availability, powered by the MySQL database. This whitepaper discusses how WindowsServer Failover Clustering with MySQL provides a solution to reduce downtime and guard against data loss, and then steps a user through the processes necessary to configure, provision and run MySQL on a Windows Server 2008 R2 cluster. By the end of this paper, developers and administrators will be able to deploy business critical applications with MySQL on Windows Server, with the added reassurance ofknowing that the solution has been certified and is fully supported.
Value of MySQL on Windows
The popularity of MySQL on Microsoft Windows can be attributed to the following factors: • Lower Total Cost of Ownership Up to 90% savings over Microsoft SQL Server (see the TCO chart below). • Broad platform support No lock-in to a single platform. MySQL runs on all leading operating system and...
Delivering High Availability with MySQL on Windows
A MySQL® White Paper
September 2011
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Table of Contents
Summary .........................................................................................................3 Value of MySQL on Windows.......................................................................3 Approaches to High Availability with MySQL .............................................4 MySQL Replication ....................................................................................6 MySQL Cluster ..........................................................................................7 Introduction to Windows Server 2008 R2Failover Clustering ..................7 Setting up MySQL with Windows Server 2008 R2 Failover Clustering ....8 Target Configuration ..................................................................................8 Pre-Requisites ...........................................................................................9 Steps to Configure MySQL for Windows Failover Clustering.................10 Step 1. Configure iSCSI in software (optional) .....................................10 Step 2. Ensure Windows Failover Clustering is enabled .....................12 Step 3. Install MySQL as a service on both servers ............................13 Step 4. Migrate MySQL binaries & data to shared storage ..................13 Step 5. Create Windows Failover Cluster............................................15 Step 6. Create Cluster of MySQL Servers within Windows Cluster .....17 Step 7. (Optional) Add asynchronous replication to an external slave 19 Step 8. Test the cluster .........................................................................19 Step 9. MySQL Upgrades.....................................................................22 Conclusion....................................................................................................23 Additional Resources ..................................................................................23
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Page 2
Summary
Microsoft Windows is consistently ranked as the top development platform for MySQL, and outranks any individualLinux distribution as the leading platform for MySQL deployments, according to surveys of the MySQL user community. For Windows customers, the advantages of using MySQL are clear: low Total Cost of Ownership (TCO); broad platform support and ease-of-use. With the release of MySQL 5.5, Oracle demonstrated the benefits of focused development activity for the Windows platform with significantenhancements in performance and scalability. MySQL delivered over 5x higher throughput than previous MySQL releases on Windows. 1 Following the certification and support of MySQL with Windows Server Failover Clustering (WSFC), organizations can now safely deploy business-critical applications demanding high levels of availability, powered by the MySQL database. This whitepaper discusses how WindowsServer Failover Clustering with MySQL provides a solution to reduce downtime and guard against data loss, and then steps a user through the processes necessary to configure, provision and run MySQL on a Windows Server 2008 R2 cluster. By the end of this paper, developers and administrators will be able to deploy business critical applications with MySQL on Windows Server, with the added reassurance ofknowing that the solution has been certified and is fully supported.
Value of MySQL on Windows
The popularity of MySQL on Microsoft Windows can be attributed to the following factors: • Lower Total Cost of Ownership Up to 90% savings over Microsoft SQL Server (see the TCO chart below). • Broad platform support No lock-in to a single platform. MySQL runs on all leading operating system and...
Leer documento completo
Regístrate para leer el documento completo.