rssHome » Database

High Availability MySQL Cookbook

High Availability MySQL Cookbook

Book Description

High Availability is something that all sites hope to achieve, especially those that are linked to big companies.

, an open source relational database system (RDBMS), can be made highly available to protect from corruption, hardware failure, software crashes, and user error. Running a setup is quite simple. Things start getting complex when you start thinking about the best way to provide redundancy. There are a large number of techniques available to add ‘redundancy’ and ‘high availability’ to , but most are both poorly understood and documented.

This book will provide you with recipes showing how to design, implement, and manage a MySQL Cluster and achieve high availability using MySQL replication, block level replication, shared storage, and the open source Global File System (GFS).

This book covers all the major techniques available for increasing availability of your MySQL databases. It demonstrates how to design, implement, troubleshoot and manage a highly available MySQL setup using any one of several techniques, which are shown in different recipes. It is based on MySQL Cluster 7.0, MySQL (for non clustered recipes) 5.0.77, and CentOS / RedHat Enterprise Linux 5.3.

The book starts by introducing MySQL Cluster as a technology and explaining how to set up a simple cluster. It will help you to master the options available for backing up and restoring a file in the MySQL Cluster. By following the practical examples in this book, you will learn how to manage the MySQL Cluster. Further, we will discuss some troubleshooting aspects of the MySQL Cluster. Download Now »

Pro SQL Server 2008 Policy-Based Management

Pro SQL Server 2008 Policy Based Management

Book Description

2008 Policy-Based is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based to creating your own custom policies to enforce consistent rules across your organization.

  • Provides in-depth treatment of policy-based management in a single source
  • Provides practical usage scenarios for policy-based management
  • Provides guidance to help meet growing regulatory compliance needs

What you’ll learn

  • Learn about policy-based management and why you should implement it.
  • Create policies to maintain a consistent, predictable environment throughout your organization.
  • Audit organizational compliance with policies automatically, across any number of servers.
  • Help ensure compliance with PCI rules, HIPAA rules, and other government regulations.
  • Configure and receive alerts for policy violations.
  • View and report on the state of your policies. Download Now »

Processing XML documents with Oracle JDeveloper 11g

Processing XML documents with Oracle JDeveloper 11g

Book Description

is an open standard for creating markup languages and exchanging structured documents and data over the Internet. JDeveloper 11g presents an effective, quick, and easy-to-use means of processing documents.

Inspired by the author’s previous articles for the community, this expanded hands-on tutorial guides newcomers and intermediate users through JDeveloper 11g and document development. It offers up-to-date information on working with the latest version of JDeveloper, and brand new information on JAXB 2.0 support in JDeveloper 11g. Filled with illustrations, explanatory tables, and comprehensive instructions, this book walks the reader through the wide assortment of JDeveloper’s capabilities.

’s JDeveloper 11g is an Integrated Development Environment that provides a visual and declarative approach to application development. Over the course of 14 chapters, readers will get hands-on with JDeveloper as the comprehensive and self-contained tutorials provide clear instruction on the key XML tasks that JDeveloper can accomplish.

Filled with practical information and illustrated examples, this book shows the reader how to create, parse, and store XML documents quickly, as well as providing step-by-step instructions on how to construct an XML schema and use the schema to validate an XML document. Download Now »

Oracle Coherence 3.5

Oracle Coherence 3.5

Book Description

Scalability, performance, and reliability have to be designed into an application from the very beginning, as there may be substantial cost or implementation consequences if they need to be added down the line. This indispensible book will teach you how to achieve these things using , a leading data grid product on the market.

Authored by leading authorities, this essential book will teach you how to use Oracle to build high-performance applications that scale to hundreds of machines and have no single points of failure. You will learn when and how to use features such as distributed caching, parallel processing, and real-time events within your application, and understand how fits into the overall application architecture.

Oracle Coherence provides a solid architectural foundation for scalable, high-performance and highly available enterprise applications, through features such as distributed caching, parallel processing, distributed queries and aggregations, real-time events, and the elimination of single points of failure.

However, in order to take full advantage of these features, you need to design your application for Coherence from the beginning. Based on the authors’ extensive knowledge of Oracle Coherence, and how to use it in the real world, this book will provide you with all the information you need in order to leverage various Coherence features properly. It contains a collection of best practice-based solutions and mini-frameworks that will allow you to be more productive from the very beginning. Download Now »

Professional Oracle WebLogic Server

Professional Oracle WebLogic Server

Book Description

Authoritative guide to WebLogic Server-from insidersIf you’re an experienced developer who wants to expand your skills, Professional WebLogic Server is the perfect guide for you. This book is written by a top-notch author team that that includes one of the lead architects from Oracle’s Fusion Middleware Development Architects team.

Follow their best practices, workarounds, and sound techniques and confidently develop even the most mission-critical applications with WebLogic Server.

This book fully covers WebLogic Server 11g, including the new features of both JEE 5 and WebLogic Server, as well as JEE 5 annotations, Spring, JPA, JAX-WS, JMS Store-And-Forward, SAML support, and the WLST administrative scripting tool.

This book is the authoritative guide to

  • Choosing a application architecture
  • Best practices for development and production environments
  • Designing an EE application
  • Building Enterprise JavaBeans in WebLogic Server
  • Building an application Download Now »

Microsoft SQL Server 2008 Administrator’s Pocket Consultant, 2nd Edition

Microsoft SQL Server 2008 Administrators Pocket Consultant, 2nd Edition

Book Description

From the author and series editor of the immensely popular ADMINISTRATOR’S POCKET CONSULTANT series from Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.

® ® 2008 Administrator’s Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you’ll want with you at all times as you deal with Microsoft® ® 2008 and ® 2008 R2 . Whether you handle for 50 users or 5000, this hands-on, fast answers guide focuses on what you need to do to get the job done quickly. With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to:

  • Plan, deploy, and configure SQL Server® 2008 R2
  • Administer server and surface security, access, and network configuration
  • Import, export, transform, and replicate data
  • Use SQL Server® Studio for core administrative tasks
  • Manipulate schemas, tables, indexes, and views
  • Automate maintenance and implement policy-based
  • Monitor server activity and tune performance
  • Manage log shipping and database mirroring
  • Perform backups and recovery Download Now »
Copyright © 2012 Wow! eBook · All rights reserved · Powered by WordPress