Performance is always top of mind for MySQL developers and DBAs. This is precisely why we designed new tools to help you assess and improve MySQL performance, and made them available within MySQL Workbench 6.1. Join us in this webinar to discover and learn how to use:

• The Performance Dashboard, allowing you to view real-time server performance statistics on a graphical dashboard
• The new MySQL “SYS” schema
• Performance Schema Reports based on the new "SYS" schema
• Visual Explain II, with an improved new layout and easier to understand terms and hints

• The expanded SQL Editor Query Statistic results view

Der Call for Proposals für die von Sonntag, den 28. September 2014 bis Donnerstag, den 02. Oktober 2014 in San Francisco stattfindenen ORACLE Open World 2014 ist nun offen.

More:
http://www.oracle.com/openworld/call-for-papers/index.html

Hallo,
anbei ein Überblick über die Vorträge in diesem Halbjahr.

• MySQL@Ceph (Ceph Day Frankfurt ./. 27.02.2014)
  Habt ihr wohl verpasst ;)
• MySQL: PerformanceSchema (DOAG SIG - MySQL ./. 27.03.2014)
• Galera Cluster für MySQL (DOAG SIG - MySQL ./. 27.03.2014)
• Docker++ ./. Containervirtualisierung von Applikationen mit Merhwert (Linuxtag ./. 08.05.2014)
• Docker: Not even a Hypervisor (Containers for OpenStack) (Linuxtag ./. 09.05.2014
• Docker: LXC Applikationskontainer für jedermann (SLAC ./. 13.05.2014)

Zudem gebe ich noch eine öffentliche Schulung im Linuxhotel zu LXC und neuen Linuxfeatures (Anfang Mai)

Viel Spaß :)

Erkan

Expand your knowledge with Jess Balint; he will share his experience as a seasoned Java application developer who both uses and develops MySQL Connector/J. Having previously helped modernize Connector/ODBC, Jess has recently implemented support for MySQL Fabric in Connector/J. In this technical webinar, you'll learn low-level details about optimizing client/server communication, as well as high-level integration with connection pools and application frameworks like Spring. This session will cover:

• Common ways to customize your Connector/J configuration for speed, memory, or network usage
• Tips for improved troubleshooting
• Techniques for optimal usage of application and persistence frameworks
• HA features and other recently added Connector/J capabilities

How does MySQL spread and become business critical in your organization? What are the typical adoption and deployment models, and their implications? How can IT Managers, architects and DBAs proactively “operationalize” MySQL deployments in order to reduce TCO, improve operational efficiently and limit risks? Join MySQL Sales Consultant John Kehoe who will share best practices from the field. He will help you understand with numerous examples how to choose the right MySQL solution according to your needs, and how to strategically operationalize your MySQL deployments with a proven method.

Die Fehlermeldung deutet darauf hin, dass ggf. der Text “wp_” nicht in Textkennzeichen (doppelte oder einfache Anführungszeichen) gesetzt wurde. Dann erkennt mySQL den Bereich wp_ als Spaltennamen und nicht als Text.

Danke erstmal für die Hilfe
Wenn ich folgenden Befahle ausführe
UPDATE neuesPrefix_options SET option_name = REPLACE(option_name, ‘altesPrefix_’, ‘neuesPrefix_’);
kommt die Fehlermeldung:
SQL-Befehl:

UPDATE wpbg_options SET option_name = REPLACE( option_name, ‘wp_’, ‘wpbg_’ )

MySQL meldet: Dokumentation
#1054 – Unknown column ‘‘wp_’’ in ‘field list’

Bei UPDATE neuesPrefix_usermeta SET meta_key = REPLACE(meta_key, ‘altesPrefix_’, ‘neuesPrefix_’); hat alles super geklappt.

Könnt Ihr mir helfen?
Danke Florian

The biggest Web sites in the world rely on MySQL Replication to scale-out and provide High Availability for their data. Extend your knowledge of how MySQL Replication works and what you can achieve with it; join us for this technical webinar to explore some of the more advanced replication architectures as well as some of the latest product developments:

• Replication topologies, including master-slave, circular and multi-master
• Load balancing and query splitting
• Data aggregation with multi-source replication
• Global Transaction IDs and auto-failover with recovery
• Getting the best replication throughput • Heterogeneous replication with the Binlog API

Am Donnerstag, den 27. März 2014 findet in Berlin die DOAG SIG - MySQL statt. Das Thema lautet diesmal "Betriebliche Aspekte von MySQL".

Mehr:
http://www.doag.org/termine/termine.php?tid=477934

If you’re currently using Microsoft SQL Server and would like to reduce your database TCO by up to 90%*, join this technical webinar to learn how to migrate your Windows applications / products from Microsoft SQL Server to MySQL using the MySQL Workbench Migration Tool. Mike Frank, MySQL Product Manager as well as MySQL on Windows and MySQL Workbench expert, will review some of the key similarities and differences between Microsoft SQL Server and MySQL, and show you how to migrate your applications step-by-step with tips and best practice advice. In addition, MySQL Workbench Migration Tool developers Alfredo Kojima and Milosz Bodzek will be on-hand to answer your questions throughout the webinar via live chat.

* Estimated savings for 3 year database TCO with MySQL Enterprise Edition vs. Microsoft SQL Server 2012 Enterprise Edition, with the following hardware configuration: 4 Intel x86_64 Servers, with 4 CPUs per Server and …