… post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… be on the same machine if you use the BLACKHOLE storage engine) in between the actual master and the slaves at the…. Q: What kind of replication issues can you get with storage solutions like GlusterFS? A: I have to admit that this…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE… are not supported inside transaction. 2. Updates involving non-transactional storage engines – It is not possible to mix non-transactional tables (such… same issue can arise if slave host is using different storage engine for the respective table on master databases. Also, if BINLOG…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…the storage engine API diminishing importance of the Innodb storage engine. The Falcon storage engine was announced as a potential Innodb successor. A “MySQL Network”…of Oracle’s MySQL engineering team, along with some technical talks directly from the Oracle MySQL engineers who brought us MySQL 5.6….
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…Ulin, Vice President of MySQL Engineering, Oracle Keynote Topic: “Driving MySQL Innovation” Wednesday Robert Hodges, CEO, Continuent “How MySQL Can Thrive in the …, Monty Program Ab Topic: “Storage Engines and Other Plugins: What’s New?” The Percona Live MySQL Conference includes a Diamond Sponsor …
Post: Percona Server 5.5.30 with TokuDB for MySQL
April 24, 2013 By 26 Comments
… TokuDB[/caption] I was excited to see that TokuDB for MySQL from Tokutek is now open source. I believe this is… and built Percona Server 5.5.30 with TokuDB’s storage engine. This is an experimental build and I am just going… stage, so I want to share it with the entire MySQL community in case you want to try it out for…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … Cluster, however, MyISAM has only basic support, primarily because the storage engine is non-transactional and so PXC cannot guarantee the data…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… modular system where the storage engines themselves owned their own metadata. This was a radical departure from the MySQL philosophy, and one that… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file… of columns you can create. If you try setting the storage engine to InnoDB however, you will get an error message! The…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… PBXT storage engine from PrimeBase – even with an open source engine, the company eventually could not fund further development, and this engine is pretty… that article: “In principle, anyone who has an interest in MySQL and MariaDB surviving should contact the MariaDB foundation and ask…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After … –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration …
