June 20, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…switching infrastructure). In essence, you’re looking for two of everything. Q: Is it possible to replicate only some tables from master to…to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to…

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

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

June 10, 2013 By 8 Comments

…to simply switch from regular MySQL replication to using replication using GTIDs 1. …not possible to mix non-transactional tables (such as MYISAM) with innodb tables within…databases. Also, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to…

Filed Under: MySQL Tagged With: , ,

Post: A recovery trivia or how to recover from a lost ibdata1 file

June 3, 2011 By 8 Comments

…Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb…switching to MyISAM” mysql -u root -e “alter table recover.$CURRENT_TABLENAME engine=MyISAM…

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT INTO innodb_ft_list2 SELECT * FROM innodb_myisam…to be present only once in the database, and I used double quotes to…

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

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

… also important to adjust processes as required to work with Innodb. For example binary copy of one of the databases from the Slave to the dev… would not switch table to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning…

Filed Under: Insight for DBAs Tagged With: , ,

Post: Webinar: MyISAM to InnoDB migration

November 8, 2010 By 4 Comments

… free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 …from MyISAM to InnoDB in the upcoming MySQL 5.5 release, we expect that a lot of users will be wanting to learn more about the benefits of switching to InnoDB, as well as topics…

Filed Under: Events and Announcements, MySQL Tagged With:

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

…switch…to mysqldump Consistent backups between myisam and innodb tables. Global read lock only held until myisam…DATABASE DEFAULT CHARACTER SET to the schema file, putting in the current charset mysqldump … -d -R –skip-triggers, out to…

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Comment: MySQL Northern European Customer Conference

October 17, 2007 By 7 Comments

…Long switch time even for Innodb tables – on large system tuned for performance filesystem recovery from journal and Innodb… – Pretty much unusable for MyISAM tables which may take infinity to check and repair – Waste …had time to script it – to use DRBD for binary logs only rather than for database. …

Filed Under: Events and Announcements Tagged With:

Comment: Should you move from MyISAM to Innodb ?

February 1, 2010 By 59 Comments

…using InnoDB? We use an internal process based on mysqldump and innodb file-per table. Our “Database File… are < 0.5M rows. Some applications use MyISAM with partitioned tables. Since every machine …from one of the slaves before switching it back to MASTER. Slaves are simply rebuilt and added back to…

Filed Under: Insight for DBAs Tagged With: , ,

Post: When would you use SAN with MySQL ?

March 9, 2009 By 18 Comments

…Innodb or MyISAM tables are used. There is read-ahead functionality but usually it is not able to…to minimize recovery time significantly by switching to that backup – no data copy will be required which can be significant concern to 1TB+ databases…

Filed Under: Hardware and Storage Tagged With:
« Older Posts