June 19, 2013

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

June 5, 2013 By

…t really much different from standard mysql replication.  1 master with 5 async slaves is going to send a … ro add dev eth1 224.0.0.0/4 [all nodes]# ip ro show | grep 224 224.0.0.0/4 dev eth1 scope link …the server. I could not find a way to migrate an existing unicast cluster to multicast with a …

Filed Under: Percona Software, Percona XtraDB Cluster Tagged With: , , ,

Comment: Heikki Tuuri to answer your in depth Innodb questions

October 3, 2007 By 51 Comments

… 4.1->5.0->5.1 However, dump/restore of 1.5TB is very slow. You can try running dump in parallel for many table. For migrating from 4.1 to 5.1 you can also try starting MySQL 5.1/innodb on 4.1 tablespace. I’ve done migration of 1.3TB from 4.0 to 5.0 and we have to do dump/restore (too many changes from 4.0 to 4.1…

Filed Under: Insight for Developers Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… idea of a complete or partial migration was, for one reason or another, …details); Query OK, 0 rows affected, 1 warning (39.73 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; …5.6, and that was to change innodb_ft_min_token_size from the default of 3 to a value of 4…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Comment: Heikki Tuuri to answer your in depth Innodb questions

October 3, 2007 By 51 Comments

… introduced in 5.0 and 5.1: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html http://dev.mysql.com/doc/refman/5.1/en… schema only in ver. 4.1 and restore it to the additional 5.1 server. Do you want to migrate to MySQL 5.1 (it is not… be able to write to the master even during the migration process. 1.5TB dump/restore – this will take a long time…

Filed Under: Insight for Developers Tagged With: ,

Page: Presentations

May 3, 2006 By

…optimizing applications for Innodb Storage Engine. Especially if you’re migrating data from other databases or other Storage Engines to …MySQL application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks about new…

Filed Under:

Post: Concatenating MyISAM files

November 19, 2012 By 5 Comments

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually … OK, 0 rows affected (0.00 sec) mysql> select * from test_concat; +—-+ | id | +—-+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | +—-+ 6 rows in set (0.00 sec… 1 mysql> select * from test_concat; +—-+——-+ | id | data | +—-+——-+ | 1 | one | | 2 | two | | 3 | three | | 4 | four | | 5 | five | | 6 | six | +—-+——-+ 6 rows in set (0…

Filed Under: MySQL

Comment: Heikki Tuuri to answer your in depth Innodb questions

October 2, 2007 By 51 Comments

…, With a 1.5 TB database on 4.1.14 consisting mostly of Innodb tables, I’m looking at upgrading to 5.1.X as soon… to the next release. The manual recommends going from 4.1 to 5.0 and 5.0 to 5.1 but that sounds like several reformatting steps. With… still move to 5.1.X? Can you give me the name of someone who you consider a expert on migration so I…

Filed Under: Insight for Developers Tagged With: ,

Comment: Converting Character Sets

March 19, 2009 By 22 Comments

…’ve just migrated around 300 databases from 4.0 to 5.0. It was not easy, because every database could use different charset… 1) Know the charset of database 2) Export database from mysql 4.0 server 3) Create new empty database on mysql 5.0 with correct default charset 4) Import data into mysql 5.0 server, but…

Filed Under: Insight for Developers Tagged With: , ,

Post: Watch out for Marketing benchmarks

August 23, 2006 By 7 Comments

… my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and… applications (ie when queries and schema could not be changed migrating from Oracle) more than once or twice, and interesting enough…

Filed Under: Benchmarks

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… stream being from the future. The 0.3 – 0.4 second delay seems too much to… cluster over a wan connection with ~ 5 ms latency? A: Yes, it can be…going to production. Q: How would you migrate to XtradbCluster from a traditional Master … writing only to 1, the reason for this is that only 1 node has to…

Filed Under: MySQL, XtraDB Cluster
« Older Posts