… it necessary to make the master read-only? Can we use regular replication for some slaves and GTID replication for other slaves at the… regular replication and GTID replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…mysql> change master to master_port=10002; mysql> start slave; Those of you who have already done these operations with file-based replication…position of a specific event. The only part were we should pay attention… can I instruct mysqlbinlog to start reading from there? Unfortunately, there is no …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to set up replication filters on the slave, as described in the MySQL manual. You can configure the slave to only replicate a specific… not that familiar with, I’d suggest reading over the manual’s description of how replication filtering rules are processed. There are…-based replication, it looks like you’ll need to wait for the next release of MHA. Q: How do you monitor MySQL…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…I know the relationships between tables versus observing queries only. An additional benefit is that SchemaSpy is command-…Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/… Feel free to answer via the comments. Thanks for reading…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory …with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… used to hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you…tables in this way, for example when using replication, a temporary table could vanish if the slave…Doesn’t the primary key solution for random selection only work when the IDs for movies are …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext… necessary for MySQL 5.6? Let’s have a look at the code implementing this feature. The warning will only be thrown… index not only for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…Replication Manager (PRM) with RHEL/CentOS prior …the following command on one server only: [root@percona1 ~]# ccs -f /etc/…MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
