… applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store for portions of application. What technologies for data storage and processing do you use alongside MySQL in your environment? Please…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application verification. This class was designed with the experienced MySQL DBA in mind… course. Percona has a packed summer MySQL training schedule. In June we have: Moving to MySQL 5.6 – Austin, TX Begins Monday…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … take the downtime when a restore is needed. As the application evolves, additional requirements will appear like hot backups, online schema… also gain a lot from write set replication. If the application gets really popular, sooner or later you have to think…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based… to connect, and that may not accurately report what your application servers are seeing. But, if you can connect and run…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate…’t MySQL enforce this kind of constraints? For many reasons: the first one because it would break 99% of all applications out there that use MySQL, for which we at Percona tend to find…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave… mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion Enabling GTID-based replication can be tricky if your application does…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… 4GB? Also wondering if any one is using ZFS and MySQL to thin clone databases meaning using a snapshot of a…. Would be interested if someone wanted to contribute on the MySQL side. Interesting that on Wikipedia Data Virtualization is talked about… for example aggregating Oracle, SQL Server and MySQL into one source that the user or application sees. On the other hand following…
Post: Moving to MySQL 5.6? We can help
April 12, 2013 By Leave a Comment
… to verify your applications, and plan for the migration to MySQL 5.6. The class is called Moving to MySQL 5.6 and… most up to date knowledge on MySQL 5.6, show you how to verify your application, and plan for a successful migration. You may also want to check out our other MySQL training events…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… few hundred rows. When a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements… be able to handle deadlock errors in your application. Raise your hands if your application has that logic (I usually get less…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… read-only. Sometimes you may also want to modify your applications to issue START TRANSACTION READ ONLY appropriately. Which is not always applicable or possible in practice. The “trx descriptors” optimization in Percona…-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization in MySQL 5.6 to achieve…
