…Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL …take cares of MySQL and manages the replication. Corosync allows any number of servers to be… between servers within the same cluster. Pacemaker manages the resources and applications on …
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your MySQL replication hierarchy? We have, too. As consultants, a lot of times we need to get a quick overview of the whole replication… an example. Notice how one of the servers has a replication filter on it, the servers don’t all have the same version installed…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… for MySQL talk for Percona Live in Washington,DC I ran into great …on single Server or many and as such you can use less powerful servers if only it is more cost effective. Finally at MySQL… MySQL can be painful, lacking online operations to alter table, defragmentation etc. Yes there are replication…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
…you how to think about replication, not what to think about replication. Data replication is one of the hardest…MySQL — and that’s just for performing this task on a single server, not to mention a cluster of servers. … If you are not signed up for Percona Live yet, I encourage you to get your tickets…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…. Especially if you think about it as $/visitor or $revenue/server the difference for most enterprises vs most of web applications… cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue which complicates application development. All of it… and running fast and Scalability on the scale of Big Table with Map Reduce. Indeed I think MySQL Replication usage will reduce, but…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but …same as with MySQL Replication – the reason it is fast and has low performance overhead on the master …and believe me most of Web applications could live with it. They anyway read stale data …
Post: Upcoming Webinar "Managing Big Data with Percona Server, XtraBackup and Tungsten"
February 2, 2011 By 3 Comments
On February 10, We will be giving a webinar “Managing Big Data with Percona Server, XtraBackup and Tungsten”. This is joint Continuent… webinar, we’ll teach you how to set up Percona Server, XtraBackup, and Tungsten to manage Terabyte+ databases and scale to… how to replicate scalably and safely using Tungsten Replicator with parallel apply. Bring your big data questions to this live webcast as we…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… the single one doesn’t know what data should live in it. And this only gets harder to … It Easy On Replication Building aggregated tables is hard work for the database server. If you do it on the …either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on a slave…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… on the interval you back them up. Recently in MySQL 5…echo “Starting live binlog backup” $MBL –raw –read-from-remote-server –stop-never … MYSQLPORT=3306 MYSQLUSER=replication_user MYSQLPASS=replication_pass BACKUPDIR=/media/binlogs/server2… be checked against the MySQL server‘s version if they are…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… in-person at the Washington DC Percona Live event next week. Use the code PLDC-… plans to create excellent free tools for MySQL administrators. There is one really big thing … deadlocks, high/changing load, replication delay, servers shutting down and restarting, and so on — and it politely waits …
