… for your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0… -t mysql -u msandbox_ro -p msandbox -meta schemaspy.meta.xml -o /var/www/schemaspy/ The -o directive tells SchemaSpy where to…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql… technique would be: Targeted schema migration (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack… to missing libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the RPM packaging…). Bug fixed #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still…? The tuple comparison you’re referring to is this example: WHERE (k1.keyword, k2.keyword, k3.keyword) = (‘espionage’, ‘nuclear-bomb’, ‘ejector… the query where you were trying to determine the last episode of each TV show. Couldn’t you have used a SUBQUERY…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… much differently than traditional hardware, and I’ve seen situations where even under just a moderate load on the host system… initial reaction was, honestly, why would you ever want to use MySQL on top of something like that? I can’t imagine…: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is the second post of a series of articles focused on MySQL 5… from the MySQL Utilities (this will be the topic of a future post). Unfortunately, this will not work for every use case…
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… using GTID-based replication by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql… nice to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
…well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level…the system stack) and then conclude with some typical use cases where a given approach may be well-suited or particularly …
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… MySQL. One question, why with 192GB of memory, did you limit the ARC to 4GB? Also wondering if any one is using ZFS and MySQL to thin clone databases meaning using a snapshot of a source database and… Server and MySQL into one source that the user or application sees. On the other hand following the VMware paradigm where one…
