…, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona…. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation. Bugs can be reported…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… in innobackupex). He also included this helpful script to generate all of those statements for steps 7 and 10 in two scripts: mysql…_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… for our next Percona MySQL University event scheduled for June 17. We run this event in partnership with MySQL Meetup at Portland organized…. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers…
Comment: How number of columns affects performance ?
May 25, 2013 By 12 Comments
… and minimize the record count in each table or would it be faster to add a column to differentiate between my types… the rest of the columns would be the same. There would be 15 columns of data in the multiple column scenario and 16 if I had to add a data type column. We are…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java… for any significant errors or items requiring review. Columns – a listing of all columns in the schema, really handy to sort by name…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…-11e2-b986-0800272864ba:4 ? A ‘Last_Executed_GTID’ column would have been useful. In our case we can check that 3ec18c45-c3ae…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team, will talk about MHA for MySQL High Availability in the… drinks for event attendees. If you’re in the Portland area and work with MySQL, then this is an event you can… join the Portland MySQL Meetup group for more MySQL-focused events in Portland If you love the ideal of Percona MySQL University and would…
Post: Summertime Percona MySQL training update
June 6, 2013 By 1 Comment
… about in a previous post, we are also running our 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–so it is a fast paced 2-day course. Percona has a packed summer MySQL training schedule. In June…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… nodes in your cluster, the more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql… 17493 mysql 20u IPv4 39685 0t0 TCP *:3306 (LISTEN) Now, let’s re-do our above test: # 2 nodes in the cluster…
