Cross-site databases are the next challenge facing today's MySQL-based businesses. Continuent Tungsten provides multiple options for spreading data across sites, including primary/DR, multi-master, and system-of-record approaches. Learn how Continuent Tungsten enables replication, failover, and routing of transactions between sites.
In this video (recording of our webinar on 10/11/12) we
Cross-site databases are the next challenge facing today's MySQL-based businesses. Continuent Tungsten provides multiple options for spreading data across sites, including primary/DR, multi-master, and system-of-record approaches. Join us to learn how Continuent Tungsten enables replication, failover, and routing of transactions between sites.
We cover the following topics:
Introduction to
Come meet Tungsten replication and clustering experts. Don't miss these 5 talks:
Managing Worldwide Data with MySQL and Continuent Tungsten by Robert Hodges Replicating from MySQL to Oracle Database and Back Again by Robert Hodges MySQL High Availability: Power and Usability by Giuseppe Maxia Lessons from Managing 500+ MySQL Instances in the Cloud by Ronald Bradford Improving Performance with
Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox.
Only works on Unix-like servers. Works with MySQL, Percona & MariaDB servers. MySQL server has the data directory, the port and the socket – you can’t share these.
To use it: make_sandbox foo.tar.gz. Then just do ./use.
$SANDBOX_HOME is ~/sandboxes. You can also create ~/opt/mysql/ and if you have MySQL 5.0.91 binary in that directory, you can just do “sb 5.1.91″.
Sandbox has features to start replication systems as well. You can have varying master/slave setups with varying versions as well (good idea to test from MySQL -> MariaDB master->slave for migration).
You can now also play with tungsten-sandbox, which is a great way to start playing with …
[Read more]MySQL replication is single threaded. Multi-master replication is complex with MySQL. Circular replication works but is very fragile. Once you’ve achieved the feat, how do you avoid conflicts? The lack of global transaction ID today also means you may have slaves that may not be synchronized fully. Finally, some people like to replicate to PostgreSQL, Oracle and MongoDB.
This is where Tungsten Replicator comes into place. Opensource. 100% GPLv2. You can do easy failover (no need to synchronize the slaves manually when a master dies), have multiple masters, multiple sources to a single slave, conflict prevention, parallel replication, and replicate to Oracle/PostgreSQL database (heterogeneous replication – …
[Read more]JCP election results. Funding for Acquia and Continuent. Fedora 14. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# The Java Community Process election results are in.
# Acquia closed an $8.5m series C funding round and announced that it has tripled its customer base in 2010.
# Continuent appointed Robert Hodges CEO and confirmed details of $5m funding from Aura Capital.
# Red Hat …
[Read more]In addition to the Boston edition, there’s an OpenSQL Camp at the same time and place as FrOSCon mid-August in Germany. The call for papers is open until July 11th. As always, the conference is about all kinds of open-source databases: MySQL and PostgreSQL are only two of the obvious ones; MongoDB and Cassandra featured prominently at the last one I attended, and SQLite was well represented at the first one.
Related posts:
[Read more]
To whom it may concern,
in response to a query from André Simões (also known as ITXpander),
I slapped together a MySQL script that outputs mysqldump commands for backing up
individual partitions of the tables in the current schema.
The script is maintained as a
snippet at MySQL Forge. How it worksThe script works by
querying the information_schema.PARTITIONS system
view to …
At the May 2009 Boston MySQL User Group, Giuseppe Maxia of Sun Microsystems gave a presentation about MySQL 5.4 with use cases and benchmarks to show how it outperforms all other current MySQL releases (including the Google patches and the OurDelta/Percona releases).
The slides can be downloaded from http://www.slideshare.net/datacharmer/mysql-54-theory-and-practice
The video can be watched below, or directly on YouTube at
http://www.youtube.com/watch?v=giT4SYXuVqA&hl
Both Giuseppe and Kaj have blogs in languages that I don’t understand. In fact, even Planet MySQL has feeds for German, Spanish and French blogs.
Want to keep up with non-English based blogs? Happen to use Google Reader? Then use their nifty “Translate into my language” feature.
I can now read Giuseppe’s latest …
[Read more]