Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot performance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation. RAC is a complex and powerful technology. It demands expertise in its deployment. You can't just "wing it" in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. Rigorous and technically accurate content Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting Up-to-date with the very latest RAC features

High Availability MySQL Cookbook is a practical guide to achieving superior reliability and redundancy in your MySQL databases. Through over 60 specific, hands-on recipes, this book skillfully navigates topics from configuring MySQL Clusters to mastering high availability using replication and storage technologies. What this Book will help me do Master the configuration of MySQL Clusters for scalability and reliability. Gain proficiency in backup and recovery techniques for MySQL. Learn the setup and maintenance of MySQL Replication for high availability. Understand the use of shared storage solutions with MySQL. Optimize MySQL performance effectively with tuning strategies. Author(s) Alexander Davies is a seasoned MySQL practitioner with extensive experience designing and implementing high availability database solutions. His hands-on expertise allows him to convey complex topics in an accessible and engaging manner. Davies brings his deep knowledge to this book, ensuring readers can confidently apply concepts to their own systems. Who is it for? This book is ideal for system administrators and database professionals familiar with Linux and basic MySQL usage. If you are looking to strengthen your database's reliability and explore high availability solutions, this book provides practical, actionable recipes. Perfect for those managing business-critical data and aiming to minimize downtime while ensuring system integrity.

Here's what Web designers need to know to create dynamic, database-driven Web sites To be on the cutting edge, Web sites need to serve up HTML, CSS, and products specific to the needs of different customers using different browsers. An effective e-commerce site gathers information about users and provides information they need to get the desired result. PHP scripting language with a MySQL back-end database offers an effective way to design sites that meet these requirements. This full updated 4th Edition of PHP & MySQL For Dummies gets you quickly up to speed, even if your experience is limited. Explains the easy way to install and set up PHP and MySQL using XAMPP, so it works the same on Linux, Mac, and Windows Shows you how to secure files on a Web host and how to write secure code Packed with useful and understandable code examples for Web site creators who are not professional programmers Fully updated to ensure your code will be compliant based on PHP 5.3 and MySQL 5.1.31 Provides clear, accurate code examples PHP & MySQL For Dummies, 4th Edition provides what you need to know to create sites that get results.

DB2 pureXML Cookbook Master the Power of the IBM Hybrid Data Server Hands-On Solutions and Best Practices for Developing and Managing XML Database Applications with DB2 More and more database developers and DBAs are being asked to develop applications and manage databases that involve XML data. Many are utilizing the highly praised DB2 pureXML technology from IBM. In the DB2 pureXML Cookbook, two leading experts from IBM offer the practical solutions and proven code samples that database professionals need to build better XML solutions faster. Organized by task, this book is packed with more than 700 easy-to-adapt “recipe-style” examples covering the entire application lifecycle–from planning and design through coding, optimization, and troubleshooting. This extraordinary library of recipes includes more than 250 XQuery and SQL/XML queries. With the authors’ hands-on guidance, you’ll learn how to combine pureXML “ingredients” to efficiently perform virtually any XML data management task, from the simplest to the most advanced. Coverage includes pureXML in DB2 9 for z/OS and DB2 9.1, 9.5, and 9.7 for Linux, UNIX, and Windows Best practices for designing XML data, applications, and storage objects Importing, exporting, loading, replicating, and federating XML data Querying XML data, from start to finish: XPath and XQuery data model and languages, SQL/XML, stored procedures, UDFs, and much more Avoiding common errors and inefficient XML queries Converting relational data to XML and vice versa Updating and transforming XML documents Defining and working with XML indexes Monitoring and optimizing the performance of XML queries and other operations Using XML Schemas to constrain and validate XML documents XML application development–including code samples for Java, .NET, C, COBOL,PL/1, PHP, and Perl

If you need to parse or process text data in Linux or Unix, this useful book explains how to use flex and bison to solve your problems quickly. flex & bison is the long-awaited sequel to the classic O'Reilly book, lex & yacc. In the nearly two decades since the original book was published, the flex and bison utilities have proven to be more reliable and more powerful than the original Unix tools. flex & bison covers the same core functionality vital to Linux and Unix program development, along with several important new topics. You'll find revised tutorials for novices and references for advanced users, as well as an explanation of each utility's basic usage and simple, standalone applications you can create with them. With flex & bison, you'll discover the wide range of uses these flexible tools offer. Address syntax crunching that regular expressions tools can't handle Build compilers and interpreters, and handle a wide range of text processing functions Interpret code, configuration files, or any other structured format Learn key programming techniques, including abstract syntax trees and symbol tables Implement a full SQL grammar-with complete sample code Use new features such as pure (reentrant) lexers and parsers, powerful GLR parsers, and interfaces to C++

Gnuplot in Action is the first comprehensive introduction to gnuplot—from the basics to the power features and beyond. Besides providing a tutorial on gnuplot itself, it demonstrates how to apply and use gnuplot to extract intelligence from data. Particular attention is paid to tricky or poorly-explained areas. You will learn how to apply gnuplot to actual data analysis problems. This book looks at different types of graphs that can be generated with gnuplot and will discuss when and how to use them to extract actual information from data. About the Technology Statistical data is only as valuable as your ability to analyze, interpret, and present it in a meaningful way. Gnuplot is the most widely used program to plot and visualize data for Unix/Linux systems and it is also popular for Windows and the Mac. It's open-source (as in free!), actively maintained, stable, and mature. It can deal with arbitrarily large data sets and is capable of producing high-quality, publication-ready graphics. So far, the only comprehensive documentation available about gnuplot is the online reference documentation, which makes it both hard to get started and almost impossible to get a complete overview over all of its features. If you've never tried gnuplot—or have found it tough to get your arms around—read on. About the Book One of gnuplot's main advantages is that it requires no programming skills nor knowledge of advanced mathematical or statistical concepts. Gnuplot in Action assumes you have no previous knowledge of either gnuplot or statistics and data analysis. The books starts out with basic gnuplot concepts, then describes in depth how to get a graph ready for final presentation and to make it look "just right" by including arrows, labels, and other decorations. Next the book looks at advanced concepts, such as multi-dimensional graphs and false-color plots—powerful features for special purposes. The author also describes advanced applications of gnuplot, such as how to script gnuplot so that it can run unattended as a batch job, and how to call gnuplot from within a CGI script to generate graphics for dynamic websites on demand. What's Inside Creating graphs with gnuplot Data transformations and filters Preparing/polishing graphs for final presentation Publishing graphs in print or on the Web Using gnuplot's power features Gnuplot scripting and programming Types of graphs and when to use them Techniques of graphical analysis How to build, install, and develop for gnuplot Command and Option reference organized by concept About the Reader Gnuplot in Action makes gnuplot easy for anyone who needs to do data analysis, but doesn't have an education in analytical tools and methods. It's perfect for DBAs, programmers, and performance engineers; business analysts and MBAs; and Six-Sigma Black Belts and process engineers. About the Author Philipp K. Janert is Chief Consultant at Principal Value, LLC. He has been a gnuplot user for more than 15 years and regards it as one of the indispensable tools in his toolbox. He has worked for small start-ups and in large corporate environments, both in the US and overseas, including several years at Amazon.com, where he initiated and led several projects to improve Amazon's order fulfillment processes. Philipp K. Janert has written about software and software development for the O'Reilly Network, IBM developerWorks, IEEE Software, and Linux Magazine. He holds a Ph.D. in Theoretical Physics from the University of Washington. Visit his website at www.principal-value.com. Quotes Knee-deep in data? This is your guidebook to exploring it with gnuplot. - Austin King, Mozilla Sparkles with insight about visualization, image perception, and data exploration. - Richard B. Kreckel, GiNaC.de Incredibly useful for beginners - indispensable for advanced users. - Mark Pruett, Systems Architect Dominion Bridges the gap between gnupolt's reference manual and real-world problems. - Mitchell Johnson, Border Stylo A Swiss Army knife for plotting data. - Nishanth Sastry, Computer Laboratory, University of Cambridge/IBM

Live Partition Mobility is the next step in the IBMs Power Systems™ virtualization continuum. It can be combined with other virtualization technologies, such as logical partitions, Live Workload Partitions, and the SAN Volume Controller, to provide a fully virtualized computing platform that offers the degree of system and infrastructure flexibility required by today's production data centers. This IBM® Redbooks® publication discusses how Live Partition Mobility can help technical professionals, enterprise architects, and system administrators: * Migrate entire running AIX® and Linux® partitions and hosted applications from one physical server to another without disrupting services and loads. * Meet stringent service-level agreements. * Rebalance loads across systems quickly, with support for multiple concurrent migrations. * Use a migration wizard for single partition migrations. This book can help you understand, plan, prepare, and perform partition migration on IBM Power Systems POWER6™ technology-based servers that are running AIX.

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Sams Teach Yourself PHP, MySQL® and Apache All in One Fourth Edition Julie C. Meloni Starter Kit CD-ROM includes a complete starter kit for Windows®, Linux®, and Mac® OS X In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up. Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production. Learn how to… Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server Get these technologies to work together to create a dynamic, database-backed website Interact with MySQL using PHP Work with forms and files Create a web-based discussion forum or mailing list Add a storefront and shopping cart to your site Optimize your MySQL databases Fine-tune the Apache server’s performance Restrict access to your applications Set up a secure web server Julie C. Meloni is the technical director for i2i Interactive, a multimedia company located in Los Altos, California. She has been developing web-based applications since the early days of the web, and is the author of several books and articles on web-based programming languages and database topics, including Sams Teach Yourself MySQL in 24 Hours. CD-ROM Includes A complete PHP, MySQL, and Apache starter kit for Windows®, Linux®, or Mac® OS X. Category: Web Development Covers: PHP 5.2, MySQL 5, Apache 2.2 User Level: Beginning

This IBM® Redbooks® publication builds upon the existing Linux for zSeriesLinux on zSeries: Fibre Channel Protocol Implementation Guide, SG24-6344, to produce a System z™ book that includes (among other things):

DB2 ® 9 builds on the world's number one enterprise database to simplify the delivery of information as a service, accelerate development, and dramatically improve operational efficiency, security, and resiliency. Now, this new edition offers complete, start-to-finish coverage of DB2 9 administration and development for Linux ®, UNIX ®, and Windows ® platforms, as well as authoritative preparation for the latest IBM DB2 certification exam. Written for both DBAs and developers, this definitive reference and self-study guide covers all aspects of deploying and managing DB2 9, including DB2 database design and development; day-to-day administration and backup; deployment of networked, Internet-centered, and SOA-based applications; migration; and much more. You'll also find an unparalleled collection of expert tips for optimizing performance, availability, and value. Coverage includes: Important security and resiliency enhancements, including advanced access control; fine-grained, label-based security; and the new security administrator role Breakthrough pureXML ™ features that make it easier to succeed with service-oriented architecture Operational improvements that enhance DBA efficiency--including self-tuning memory allocation, automated storage management, and storage optimization Table-partitioning features that improve scalability and manageability Powerful improvements for more agile and rapid development, including the new Eclipse-based Developer Workbench and simple SQL or XQuery access to all data Whatever your role in working with DB2 or preparing for certification, is the one book you can't afford to be without. DB2 9 for Linux, UNIX, and Windows, Sixth Edition Download Complete DB2 V9 Trial Version Visit ibm.com/db2/9/download.html to download a complete trial version of DB2, which enables you to try out dozens of the most powerful features of DB2 for yourself: everything from pureXML support to automated administration and optimization. Straight from IBM, the ultimate guide to running DB2 9 and preparing for the latest IBM DB2 certification exam! Covers powerful DB2 9 enhancements ranging from automated management to improved compression Covers the full spectrum of DBA responsibilities, including server management, data placement, XML concepts, activity analysis, high availability, and security Presents expert tips and best practices from the DB2 customer support organization

This IBM Redbooks publication will illustrate the installation procedures of InfiniBand on the IBM System p5 with Linux and AIX 5L. InfiniBand adapters, switches, and network management software will be described in this publication. The IBM HPC stack will be tested with InfiniBand (Parallel Environment, LoadLeveler, GPFS, ESSL, and Parallel ESSL). Communication protocols such as MPI and LAPI will be tested and observations will be illustrated in this book. This book is the complete guide on how to implement InfiniBand on the IBM System p5. It is targeted at all IT professionals looking to understand what is behind the InfiniBand technologies, how to deploy it, and what is the IBM solution incorporating this technology.

IBM TotalStorage Productivity Center for Replication Version 3,Release 1 brings support for the advanced copy services capabilities on the DS8000 and DS6000, in addition to the support for ESS model 800 and SVC. This support focuses on automating administration and configuration of these services, operational control (starting, suspending, resuming) copy services tasks and monitoring and managing the copy services sessions. In addition to the support for FlashCopy and Metro Mirror, TotalStorage Productivity Center for Replication V3R1 supports Global Mirror on the ESS800, DS8000, and DS6000 hardware platforms. Advanced disaster recovery functions are also supported with failover/failback (planned and unplanned) from a primary site to a disaster recovery site. TotalStorage Productivity Center for Replication also can monitor the performance of the copy services that provide a measurement of the amount of replication and the amount of time that is required to complete the replication operations. This IBM Redbooks publication provides the information you need to install TotalStorage Productivity Center for Replication and create and manage replication sessions on Linux. Scenarios are provided that document our work in the laboratory setting, using the GUI and CLI.

This book will help you get the best from your Linux NFS clients when used in an environment that includes IBM System Storage N series products. It begins with a general discussion of Linux distributions and kernels, and includes a comparison of some of the features of the 2.4 and 2.6 kernels. A detailed discussion of mount options and network protocols is presented to guide you through configuration tasks. Procedures for tuning your Linux clients and steps to diagnose performance and reliability problems are presented, along with information about additional resources you can consult if necessary. Finally, steps for configuring and using utilities that support advanced NSF features are provided.

This IBM Redbooks publication documents the procedures for implementing IBM OmniFind Enterprise Edition Version 8.4 technology in a single-server Windows environment, two-server Linux environment, and a four-server AIX environment. Supported data sources include DB2, Windows file system, DB2 Content Manager, Lotus Domino, Lotus Quickplace, WebSphere Portal Server, Web Content Management (WCM), and Portal Document Manager (PDM). Tivoli Directory Server (TDS) is the LDAP repository used in the scenarios. It is aimed at IT architects and search administrators who are responsible for managing IBM OmniFind Enterprise Edition on Windows 2003, Red Hat Enterprise Linux, and AIX platforms. The book offers a step-by-step approach to implementing a single-server, two-server, and four-server IBM OmniFind Enterprise Edition environment using typical customer scenarios. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication describes best practice guidelines for running Oracle databases on IBM System Storage N series products with system platforms such as Solaris, HP/UX, AIX, Linux, and Microsoft Windows. It provides tips and recommendations on how to best configure Oracle and the N series products for optimum operation. The book presents an introductory view of the current N series models and features. It also explains basic network setup. For those who are unfamiliar with the N series portfolio of products, this book also provides an introduction to aggregates, volumes, and setup. This document reflects work done by NetApp and Oracle, as well as by NetApp engineers at various joint customer sites. It is intended for storage administrators, database administrators, business partners, IBM personnel, or anyone who intends to use Oracle with the N series portfolio of products. It contains the bare minimum requirements for deployment of Oracle on the N series products. Therefore, you should use this document as a starting point for reference.

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10 g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many other topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

This IBM Redbooks publication describes the steps carried out to configure and install an IBM DB2 database in a N series storage system UNIX environment. It particularly elaborates the configuration steps for the UNIX host as well as the IBM N series storage system. The UNIX host types covered in this book are Linux, IBM AIX, Sun Solaris, and HP-UX.

IBM System i platform offers many points of integration that support Linux applications leveraging IBM i5/OS applications and data, such as IBM eServer iSeries Access for Linux, IBM i5/OS NetServer with Samba support, and IBM Java Virtual Machine and JTOpen support. Please note that the additional material referenced in the text is not available from IBM.

Whether you're running a business, keeping track of members andmeetings for a club, or just trying to organize a large and diversecollection of information, you'll find the MySQL database engineuseful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season? MySQL, the most popular open-source database, offers the power ofa relational database in a package that's easy to set up andadminister, and Learning MySQL provides all the tools you need toget started. This densely packed tutorial includes detailedinstructions to help you set up and design an effective database,create powerful queries using SQL, configure MySQL for improvedsecurity, and squeeze information out of your data. After covering the basics, the book travels far into MySQL'ssubtleties, including complex queries and joins, how to interact withthe database over the Web using PHP or Perl, and importanthouse-keeping such as backups and security. Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using thePHP and Perl programming languages The authors, Saied Tahaghoghi and Hugh E. Williams, have careers inacademia and business, and share a keen interest in research intosearch technologies. Whether you've never touched a database or have already completedsome MySQL projects, you'll find insights in Learning MySQLthat will last a career.