… MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2…) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine for… BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… need to have existing table structures in place. Fortunately, this can be done easily using mysqldump –no-data. Now, enough with… –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target… rather than needing to import from a remote server. This can allow for more targeted restores, easier comparison, and allow remote…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… only stable illumos distro designed for server usage, and it can be bought with an optional tech support agreement. OpenIndiana is… that pretty much dead project. The only thing I don’t like about OmniOS is that the illumos base currently lacks… of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…. [Don’t try more than 2; the additional work that the kernel has to do in reordering TCP packets can actually result… specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified… to use MySQL on top of something like that? I can‘t imagine the performance being all that fantastic, and I could…
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
… you define large schemas, and what do you mean by can‘t cope? * Is this a concern regarding crashes of the tool, or certain features don’t work past N number of tables? In my experience, the… than a couple minutes. I haven’t tried pulling this schema into Workbench so I can‘t comment as to how well it…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… KB/s This isn’t much traffic in my puny local VMs, but you get the idea. We can clearly see some…:193 KB/s So, we can see our outbound bandwidth on our master node doesn’t change as we add more nodes when we are using multicast. Other multicast tips We can also also…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can‘t really cope with really large schemas.
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…’t mean you should not use GTIDs, you just need to be aware of the current limitations and see if you can…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
@Kristian: Good point. I haven’t tried GTIDs in combination with multi-threaded slave yet, as enabling GTIDs only has provided a few surprises. So this hadn’t come to my mind. @Shlomi: Fixed, thanks!
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
@Kristian, Well, the (slave) server *knows* whether it is replicating in parallel or not, so it doesn’t have to always manage the general case. When it knows it uses single thread replication the “last executed” assumption is safe.
