This document discusses high availability and MySQL high availability solutions. It begins with an overview of high availability concepts like availability, redundancy, and fault tolerance. It then discusses native MySQL high availability options like master-slave replication and MySQL Group Replication. MySQL Group Replication is a new multi-master replication plugin that provides highly available, scalable MySQL clusters with automated failover and data consistency. The document explains how Group Replication works and its advantages over other solutions.
This document discusses MySQL Sandbox, a tool for quickly installing and testing multiple MySQL database servers on a single machine. The tool allows users to install MySQL servers from binaries in seconds, set up replication topologies easily, and customize server configurations. MySQL Sandbox provides an easy way to test MySQL features without having to manually configure each database instance.
Solving the C20K problem: Raising the bar in PHP Performance and ScalabilityZendCon
?
This document summarizes a presentation given by Luxi Chidambaran of Oracle on solving the C20K problem of scaling PHP applications. It discusses how the Oracle 11g Database Resident Connection Pool (DRCP) allows PHP applications to connect to the database in a way that supports tens of thousands of concurrent connections using minimal system resources. It provides an overview of DRCP and how the enhanced OCI8 PHP extension connects to leverage DRCP. Performance benchmarks are presented showing significant increases in throughput and reductions in memory usage compared to non-DRCP connections.
The document discusses PHP and platform independence in the cloud. It describes different definitions of the cloud and benefits like scalability. It notes that applications should be written for the cloud using cloud services. Moving applications between cloud providers is difficult due to API differences. The PHPilosophy is presented as using abstraction to create common interfaces for cloud services like storage, documents, and queues to provide platform independence when using different cloud providers.
MySQL Tech Tour 2015 - 5.7 Connector/J/NetMark Swarbrick
?
This document provides an agenda and overview for a MySQL Tech Tour on MySQL connectors. The agenda includes sections on what is a MySQL connector, Connector/Net and Connector/J, new features of Connector/Net including replication support and security guidelines, feature highlights and security of Connector/Net, new developments for Connector/J, and feature highlights and security of Connector/J.
This document discusses high availability and MySQL high availability solutions. It begins with an overview of high availability concepts like availability, redundancy, and fault tolerance. It then discusses native MySQL high availability options like master-slave replication and MySQL Group Replication. MySQL Group Replication is a new multi-master replication plugin that provides highly available, scalable MySQL clusters with automated failover and data consistency. The document explains how Group Replication works and its advantages over other solutions.
This document discusses MySQL Sandbox, a tool for quickly installing and testing multiple MySQL database servers on a single machine. The tool allows users to install MySQL servers from binaries in seconds, set up replication topologies easily, and customize server configurations. MySQL Sandbox provides an easy way to test MySQL features without having to manually configure each database instance.
Solving the C20K problem: Raising the bar in PHP Performance and ScalabilityZendCon
?
This document summarizes a presentation given by Luxi Chidambaran of Oracle on solving the C20K problem of scaling PHP applications. It discusses how the Oracle 11g Database Resident Connection Pool (DRCP) allows PHP applications to connect to the database in a way that supports tens of thousands of concurrent connections using minimal system resources. It provides an overview of DRCP and how the enhanced OCI8 PHP extension connects to leverage DRCP. Performance benchmarks are presented showing significant increases in throughput and reductions in memory usage compared to non-DRCP connections.
The document discusses PHP and platform independence in the cloud. It describes different definitions of the cloud and benefits like scalability. It notes that applications should be written for the cloud using cloud services. Moving applications between cloud providers is difficult due to API differences. The PHPilosophy is presented as using abstraction to create common interfaces for cloud services like storage, documents, and queues to provide platform independence when using different cloud providers.
MySQL Tech Tour 2015 - 5.7 Connector/J/NetMark Swarbrick
?
This document provides an agenda and overview for a MySQL Tech Tour on MySQL connectors. The agenda includes sections on what is a MySQL connector, Connector/Net and Connector/J, new features of Connector/Net including replication support and security guidelines, feature highlights and security of Connector/Net, new developments for Connector/J, and feature highlights and security of Connector/J.
In this session we will take a look at several different methods for building tiered applications. Some of the tiering methodologies include Soap, XML-RPC, RESTful and multiple language architectures. The purpose of this talk will not be to determine which methodology is best, but instead will try to provide an unbiased view of the pros and cons of each.
The document discusses performance improvements and new features in MySQL 5.7. Key points include:
- MySQL 5.7 shows significant performance gains over previous versions, with benchmarks showing 3x faster query performance and 82% faster connection throughput.
- New features include enhanced replication, a new optimizer cost model, performance schema improvements, and native JSON support.
- The optimizer and parser were refactored for improved maintainability, readability and stability. A new cost-based optimizer model provides better performance and tunability.
Zend Core on IBM i - Security ConsiderationsZendCon
?
The document discusses security considerations for Zend Core for IBM i. It provides two options for securing the system: 1) guarantee system security by unplugging and locking the system in a vault or 2) take a security journey to protect valuable information assets from outsiders like hackers and insiders like corporate criminals. The document then discusses steps to understand and protect various components of Zend Core like directories, files, programs, user profiles, and configurations. It provides recommendations to make the Apache and PHP configurations more secure through access controls, encryption, and logging.
MySQL Manchester TT - Replication FeaturesMark Swarbrick
?
The document is a presentation about replication features in MySQL 5.7 given at Percona Live in Amsterdam. It provides background on replication components like binary logs and replicas. It then discusses new usability and online features for replication in MySQL 5.7 like online reconfiguration of global transaction identifiers to allow configuration changes without downtime. The presentation outlines these new features and previews upcoming lab developments and the future roadmap.
This document discusses best practices for securing MySQL databases. It notes that 43% of companies experienced a data breach in the past year. It then provides statistics on the large number of identities exposed in data breaches in 2013. The document identifies common database vulnerabilities like poor configurations, over privileged accounts, and weak authentication. It also discusses database attacks like SQL injection and how to prevent them. Finally, it covers regulatory compliance requirements for frameworks like PCI-DSS and HIPAA.
This document provides an overview of the MySQL query optimizer. It discusses the main phases of the optimizer including logical transformations, cost-based optimizations, analyzing access methods, join ordering, and plan refinements. Logical transformations prepare the query for cost-based optimization by simplifying conditions. Cost-based optimizations select the optimal join order and access methods to minimize resources used. Access methods analyzed include table scans, index scans, and ref access. The join optimizer searches for the best join order. Plan refinements include sort avoidance and index condition pushdown.
Ralph Schindler gives an overview of extending the Zend Framework tool Zend_Tool. He describes Zend_Tool's purpose for rapid application development of Zend Framework projects. The talk outlines Zend_Tool's architecture including the Zend_Tool_Framework component for dispatching tool requests and the Zend_Tool_Project component for exposing project-specific capabilities. Schindler discusses various extension points for Zend_Tool like implementing providers, metadata, and interactivity. He provides examples of extending Zend_Tool to load profiles, create resources, and regenerate code.
- DreamHost has evolved its storage solutions over time from early SCSI storage to using Ceph, an open source software-defined storage system.
- Ceph provides distributed, replicated storage without single points of failure using components like monitors, OSDs, and its CRUSH algorithm for data distribution.
- DreamHost now uses Ceph to power its DreamObjects cloud storage and DreamCompute OpenStack-based cloud, managing the Ceph clusters through automation with Chef configuration management.
This document summarizes what's new for PHP on Windows, including improved performance and reliability through use of FastCGI for IIS and the WinCache extension. It outlines the history of PHP on Windows and how support has improved over time, with Microsoft now promoting PHP as part of its web platform and providing tools to easily install PHP and applications. Key resources are also listed for additional information on using PHP on Windows.
This document provides an overview of IBM i tutorial events occurring at ZendCon '09, including PHP sessions on Tuesday and an IBM i networking reception. It introduces Mike Pavlak, the Solution Consultant giving the tutorial, and reviews tools for developing PHP applications on IBM i like Zend Core, Studio, and Server. The tutorial agenda includes using toolkit functions, debugging with Zend Platform, and integrating procedural PHP with the Zend Framework.
Application Diagnosis with Zend Server TracingZendCon
?
This document discusses Application Diagnosis with Zend Server Tracing. It provides an overview of debugging applications, introduces Zend Server Tracing as a better way to debug than var_dump, and covers how Zend Server Tracing works including code tracing, monitoring modes, and settings. It provides examples of using code tracing to diagnose uncaught exceptions, destructors, prepared statements, and memory usage. The document encourages using Zend Server Tracing in development, testing, staging, and production environments.
This document provides tips and examples for creating shell scripts to automate database administration tasks. It recommends using shell scripts because shell is available everywhere and shell scripting is powerful and fast to write. It then provides several tips for writing robust shell scripts, such as using configuration files, running commands in parallel, and creating shortcuts. The document includes examples of scripts for installing MySQL replication across multiple servers and testing that replication is working.
MySQL 5.7 includes several new features that improve performance, replication, and high availability. Key features include performance improvements from the performance schema and optimizer enhancements, replication improvements like multi-source replication and transaction-based parallel replication, and InnoDB improvements such as online operations and general tablespaces.
SQL Tuning02-Intorduction to the CBO OptimizerZhaoyang Wang
?
This document provides an introduction to the Cost-Based Oracle Optimizer (CBO). It describes the main components of the CBO including the estimator, plan generator, and OPTIMIZER_MODE. It also discusses important CBO concepts like selectivity, cardinality, cost and how they are estimated. The document provides examples of how to view CBO statistics and use 10053 tracing to analyze plans.
SQL Tuning04-Interpreting Execution PlansZhaoyang Wang
?
This document discusses various methods for interpreting SQL execution plans in Oracle databases, including using the PLAN_TABLE, views like V$SQL_PLAN, and tools like DBMS_XPLAN and AUTOTRACE. It also covers gathering plan statistics and interpretation from sources like the Automatic Workload Repository (AWR).
SQL Tuning01-Introduction to SQL TuningZhaoyang Wang
?
This document provides an introduction to SQL tuning. It discusses common causes of poor SQL performance such as stale statistics, missing indexes, and suboptimal execution plans. It then describes Oracle tools that can be used for SQL tuning such as the Automatic Database Diagnostic Monitor and SQL Tuning Advisor. Various SQL performance metrics are covered like wait time and how it relates to CPU and I/O times. Common SQL performance problems are also listed like parsing issues, full table scans, and redo log configuration errors. Finally, techniques for SQL tuning are discussed such as query rewrites, materialized views, and cursor sharing.
This document provides an overview of MySQL full-text search capabilities. It discusses the three types of full-text searches supported: natural language, boolean, and query expansion searches. It also covers stopwords, relevance ranking calculations, and techniques for fine-tuning full-text search performance such as configuring minimum/maximum word lengths and optimizing indexes. The document concludes with some restrictions and best practices for MySQL full-text search.
The document summarizes the key data structures used to organize data in InnoDB:
- InnoDB stores data in tablespaces which consist of data files. A tablespace header tracks free/used extents within these files.
- Data files contain fixed-size pages which are organized into extents of 1MB each. Page headers identify page types like interior, leaf, etc.
- File segments allocate ranges of pages to index trees. The root node of each index references two segment headers to allocate leaf/non-leaf pages separately.
MYSQLCLONE is a free and simple tool used to clone MySQL databases from one server to another. It can transfer the entire database including data, schemas, stored procedures, functions and events. The tool connects to the source and destination databases using connection parameters and then transfers the database objects and data in either LOAD or INSERT mode. Quick usage examples are provided to demonstrate transferring the full database, schema objects only, and row data in INSERT mode.
Oracle security 08-oracle network securityZhaoyang Wang
?
The document discusses securing Oracle Network services. It provides checklists and procedures for securing clients, the network, and the listener. It recommends configuring clients and browsers with authentication and encryption. It also recommends restricting network access through firewalls and IP address validation. For the listener, it suggests restricting privileges, password protecting administration, and monitoring logs to analyze activity and potential attacks. The goal is to describe how to securely administer the network and listener to restrict access and analyze logs for security.
Oracle security 02-administering user securityZhaoyang Wang
?
This document discusses administering user security in an Oracle database. It covers how to create and manage database user accounts, including authenticating users and assigning privileges. It also covers creating and managing roles to simplify privilege management, and creating profiles to implement password security and control resource usage. Profiles allow enforcing standards for password complexity, aging, locking accounts, and limiting resource consumption. The document stresses applying the principle of least privilege and separating administrative duties for security.