Galera ist die synchrone Multi Master Lösung für MySQL.
Auch wenn wir bei PXC oder MariaDB Galera Cluster immer von Galera sprechen,
ist Galera nur ein Provider.

Provider? Was meinst Du damit?

Bei der Konfiguration von “Galera” gibt
es zwei Optionen
wsrep_provider und wsrep_provider_options
Bei ersterem wird der Provider eben Galera definiert.
Die bei der zweiten Option handelt es sich um die Konfiguration eben diese Providers.

Die restlichen wsrep_ Optionen sind für wsrep.

https://launchpad.net/wsrep

wsrep API defines a set of application callbacks and replication library calls necessary to implement synchronous writeset replication of transactional databases and similar applications. It aims to abstract and isolate replication implementation from application details. Although the main target of this interface is a certification-based …

MySQL Enterprise Backup 3.10 delivers significant improvements in terms of speed, compression, flexibility, efficiency and security. Join us to understand how those improvements can help you better manage your backups. You will learn about:

·        Two new compression options – their benefits, and where & how to use them

·        New Advanced Encryption Standard (AES) Security - and best practices for securing backups using it

·        Further enhancements to our very popular “Zero Space” one step streaming backup and recovery, now available for tables

·        New filtering options for partial backups

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