MySQL 5.6 builds on Oracle's investment in MySQL by adding improvements to Performance, InnoDB, Replication, Instrumentation and flexibility with NoSQL (Not Only SQL) access. In the first session of this 5-part Webinar series, we’ll cover the highlights of those enhancements to help you begin the development and testing efforts around the new features and improvements that are now available in the latest MySQL 5.6 Development Milestone and MySQL Labs releases.

Building upon the fundamental knowledge shared in Part 1 of the 3-part Webinar series, in the second installment we will unveil some of the inner workings in MySQL PHP APIs to help you make the best choices when building your applications. Many settings are designed to be configured for your specific application to achieve better performance, and yet are not discussed very often. This session will cover the following topics to enable you improve the performance of your PHP applications, including:

• Connection options and costs
• Buffered and unbuffered queries
• Handling multi-statement and multi-result

Join this technical session and learn the first-hand knowledge from the PHP experts from MySQL!

Von Samstag, den 20. August 09:00 Uhr (CEST) bis Sonntag, den 21. August 2011 18:00 Uhr (CEST) findet das "Open Database Camp @ FrOSCon 2011" in Fachhochschule Bonn-Rhein-Sieg, Grantham-Allee 20, 53757 Sankt Augustin statt. Die DOAG wird auch vertreten sein.

Mehr:
http://programm.froscon.org/2011/index.html

Replication is a versatile tool to solving many problems in today's highly dynamic modern web architectures, as well as offering many ways to simplify maintenance.

In this session, the MySQL replication developers will present a bag of useful tips and tricks related to the MySQL 5.5 GA and MySQL 5.6 Development Milestone Release, including:

• Ways to set up multi-source replication
• Multi-master setup: do's and don't
• Using logs for auditing
• Ways to handle filtering
• Keeping the system online
• Examining the binary log
• Using relay slaves
• Splitting the replication stream
• Handling fail-over

We will also cover the latest enhancements to replication included in the MySQL 5.6 Development Milestone Release.

Taxonomy upgrade extras:  innodb data dictionary er-diagram german

Mit dem neuen MySQL Release 5.6 sind einige neue InnoDB Data Dictionary Tabellen zum INFORMATION_SCHEMA hinzu gekommen:

Neu in MySQL 5.5 sind:

Neu …

Oracle ermöglicht der Community zu Testzwecken ab sofort einen Vorabzugriff auf die neuen Funktionen von MySQL 5.6 - Resonanz aus der Community erwünscht.

In diesem Webseminar lernen Sie die technischen und wirtschaftlichen Gründe für die Nutzung der MySQL Replikation kennen und Sie erhalten einen Überblick, wie eine Master/Slave-Architektur bereitgestellt wird. Sie erfahren, wie Sie eine replizierende Umgebung einrichten, konfigurieren und verwalten.

Date and Time: Thursday, 29 Sep 2011, 15:00 CET

Join us for a series of live webinars that share the essentials to build high performance and high traffic PHP applications with MySQL. As part of the open source LAMP Stack, PHP is the most popular language for web applications, and the combination of MySQL and PHP has enabled numerous developers to implement ideas and build up websites quickly, and subsequently becomes the foundation of many well-known web properties.

In Part 1 of the 3-part Webinar series, we will walk through the fundamentals of creating dynamic web content using MySQL and PHP. We will also discuss many of the building blocks and key considerations when you architect your PHP applications, including the frameworks, APIs, security features, and asynchronous queries. By attending this Webinar, you can obtain the essential knowledge to get started building PHP applications with MySQL!

Using the memcached API, web services can directly access MySQL Cluster data nodes without transformations to SQL, ensuring low latency and high throughput for read/write queries.

Announced as part of the MySQL Cluster labs release, memcached functionality is extended by adding support for write-intensive workloads, a full relational model with ACID compliance (including persistence), rich query support, transparent partitioning for scale-out, 99.999% availability and geographic replication.

Configuration can be specified on a per-key basis using memcache key prefixes, and several memcached servers can connect to multiple MySQL Clusters and serve different roles.

The MySQL Cluster engineering team will present:

• The design features of the memcached API for MySQL Cluster
…

MySQL wurde konzipiert, um anspruchsvollste Transaktionsdienste in der Web- und Telekommunikationswelt unterstützen zu können. In diesem Webseminar lernen Sie optimale Verfahrensweisen für die bedarfsgerechte Skalierung hoher Lese- und Schreibzugriffe kennen. Sie erhalten außerdem einen Überblick über die Möglichkeiten von NoSQL- und SQL-Zugriffsmethoden.