…database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database…MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… standard MySQL database configuration follows this active/passive pattern. There is a virtual IP that points to the active server of a pair… –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… and MaxDB database looked like it had a solid future. MySQL Cluster and MySQL Press were announced during this event; “High Performance MySQL” 1st… with MySQL to put on an amazing conference with O’Reilly’s style of mixing fun with business. The conference name changes to “MySQL Conference…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary index with the same name. Fixed by detecting such cases…). The log tracker thread was unaware of the situation when the oldest… the log parser or bad changed page data. Bug fixed #1108613 (Laurynas…MySQL would re-create the test database when using rpm on server upgrade, even if the database…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… the upgrade was completed regardless of its state before updating. This… secondary index with the same name. Fixed by detecting such cases… the log parser or bad changed page data. Bug fixed #1108613 (…MySQL would re-create the test database when using rpm on server upgrade, even if the database…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…eBay who’s name escapes me. Because eBay wanted to have a supported version of this code, it… you an indication of the numbers of database connections the thread pool supported. I was not part of the original …specifics, and much has changed in a 6 years in code base and MySQL versions, but it was…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…commercial databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database … contents of database rows which change into special tables called changelogs. Each changelog is located in the flexviews database and is named $SCHEMA_$…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… timestamp format change which forced to change a lot of applications. MySQL 5.0 added more issues to the pile with a lot of data… as MySQL changes name to “mysql“. Come On, as I remember MySQL And Redhat should be partners or is this partnership happening in area of marketing… is even more scary to get running MySQL but find the database is gone now. mysql user removed I’m not sure if…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… help of people from the Pacemaker community, namely Florian Haas and Raoul Bhatia, I have been able to modify the existing MySQL Pacemaker… MySQL unix socket file replication_user: The user to use when setting up replication. It is also currently used for the ‘CHANGE… thing that may change here is clone-max=”3″ which should match the number of database nodes you have. The handling of the VIPs…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… been added to the mysqlbinlog utility that allows the changing names of the used databases in both Row-Based and Statement-Based replication. This…, awk and sed but only for SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona…
