http://www.codership.com/wiki/ 2012-05-18T04:11:14+03:00 http://www.codership.com/wiki/ http://www.codership.com/wiki/lib/tpl/vector/images/favicon.ico text/html 2012-04-05T13:24:12+03:00 root http://www.codership.com/wiki/doku.php?id=notification_command&rev=1333621452&do=diff If wsrep_notify_cmd is set, the server will try to invoke this command every time cluster membership or local node status changes. This can be used to (re)configure load balancers, raise alarm and so on. Notification Command Arguments The command will be passed one or more of the following options: text/html 2012-03-29T17:24:44+03:00 root http://www.codership.com/wiki/doku.php?id=compile_galera&rev=1333031084&do=diff Linux Coming later. Nothing special there. Check Solaris section for tips. RHEL/CentOS/Oracle Linux Debian Solaris Currently the latest revision of Galera is known to compile on Solaris 11 x86 in addition to Linux. It may not compile on Solaris 10, and will not work on big-endian machines (as we don't have any, we simply can't fix all the endian-related stuff). text/html 2012-03-29T17:06:52+03:00 root http://www.codership.com/wiki/doku.php?id=howto&rev=1333030012&do=diff * Galera cluster deployment variants * MySQL/Galera cluster upgrade * Use ClusterControl(tm) to deploy Galera cluster in Amazon EC2 in less than 10 minutes * Compile Galera from source External resources * Fromdual: Migrating from MySQL replication to Galera cluster * Fromdual: Rolling upgrade from Galera-1.0/MySQL-5.1 to Galera-1.1/MySQL-5.5 text/html 2012-03-24T02:31:42+03:00 root http://www.codership.com/wiki/doku.php?id=reference&rev=1332549102&do=diff Operation Node Failure Node Provisioning/Recovery Galera Node State Machine Flow Control SSL Support Galera Arbitrator Scriptable State Snapshot Transfer Writeset cache Incremental State Transfer Rolling Schema Upgrade (MySQL >= 5.5.17 only) text/html 2012-03-06T23:36:40+03:00 root http://www.codership.com/wiki/doku.php?id=monitoring&rev=1331069800&do=diff All wsrep-related (in this case - Galera) status variables are prefixed with 'wsrep_' so it is easy to check them with mysql> SHOW VARIABLES LIKE 'wsrep_%'; Status variables described in chapter 3 and below are differential and reset on every SHOW STATUS command. Thus it is recommended that two SHOW STATUS commands be executed on the node with an interval of ~1 minute and then the output of the last invocation will correspond to the current moment. text/html 2012-03-01T00:26:19+03:00 root http://www.codership.com/wiki/doku.php?id=manual&rev=1330554379&do=diff A Little Bit Of Theory We strongly advise you to take time to familiarize yourself with the theory behind Galera operation. It is not that big or complex, however it will help you to understand Galera versatility and take you much farther than a thousand of examples or recipes. Galera takes data replication to a whole new level and to achieve that it does away with many “traditional” concepts and misconceptions. Whether you're a fledging DBA or a seasoned systems integrator with tens of “tradit… text/html 2012-02-16T21:47:38+03:00 root http://www.codership.com/wiki/doku.php?id=faq&rev=1329421658&do=diff Q: What is Galera? Galera is a wsrep service provider in a form of dlopenable library. It provides synchronous replication guarantees and supports multi-master replication. Among other things Galera is capable of unconstrained parallel applying AKA “parallel replication”, multicast replication and automatic node provisioning. Galera primary focus is data consistency: transaction is either applied on every node or not at all. See CaP theorem for consequences. text/html 2012-01-20T21:07:31+03:00 root http://www.codership.com/wiki/doku.php?id=info&rev=1327086451&do=diff What we'll be talking here is a generic pluggable replication architecture of the form: clients | | | V V V ,----------------. | | | application | <-- e.g. MySQL server | | ================== <-- wsrep API | wsrep provider | <-- e.g. Galera `----------------' | V replication to other nodes text/html 2011-12-29T03:36:06+03:00 root http://www.codership.com/wiki/doku.php?id=scriptable_state_snapshot_transfer&rev=1325122566&do=diff 0.8 series MySQL/Galera introduces interface to customize state snapshot transfer via external script (or program). The script is to work under assumption that storage engine initialization on the receiving node happens after state transfer is complete. In short, the idea of this transfer is to copy the contents of source data directory to destination data directory (with possible variations).