… pair on servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run… is not excessive so a single server can easily handle the write load of all the MySQL instances. The original idea was… put together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
Wow, I pulled all the 300GB drives out of my MySQL servers years ago. I don’t need the space of a… are way faster than the old drives. So fast, that for linear writes, like httpd logs, they are as fast as… as big, and much faster than the 300GB HDDs, on MySQL type loads.
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0…. Running SchemaSpy The syntax below if specific for MySQL, but note that SchemaSpy works for pretty much all the popular RDBMS out there… can then be accessed by a web server. Also note that since I created the mysql.properties file in the same directory…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers…OK ] Starting cman… [ OK ] Waiting for quorum… [ OK ] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ]…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… to take was to extract the offsets for the Percona Server version I was using for the test (5.5.28-29.1… knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables, according to the docs) for which… for me, since I think proper audit trail support has been an important missing feature on the server, which has made using MySQL…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… scenarios: For these tests, all servers are running on 127.0.0.1 with ports ranging from 10000 for s0 to 10004 for s4…=1; s0> start slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of… is the server UUID of s2, and that the other one is from s0 (for s0 which is crashed, the server UUID can…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
… very natural place for our next Percona MySQL University event scheduled for June 17. We run this event in partnership with MySQL Meetup at…. Percona MySQL University is a daylong, free, fast-paced and very technical MySQL educational event for wide range of people interested in MySQL – Developers…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… only one of the servers with GTIDs Let’s stop slave #2, change configuration and restart it: mysql> show slave status\G [...] Slave… replication only (gtid_mode=off for all servers) or GTID-based replication only (gtid_mode=on for all servers). Additional question: how can you…
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 … services or development systems, many people are using a single server with some backups configured, and then simply take the downtime…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… mysql and import them in Percona server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but…
