…reasons for wanting a small MySQL database server: You’re a uni student who wants…) Re-connect to see if your password change worked as expected, and install Percona Server … using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
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 table, or tables for changes. Improve ETL performance by identifying the data which has changed…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… select count(*) on mysql.user table, so the user given should at least have select on that table. op monitor: An entry is needed for each role, Master and Slave. Intervals must not be the same. Following the mysql primitive…. The only thing that may change here is clone-max=”3″ which should match the number of database nodes you have. The…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines …Memcached are usually employed. When rows in the database change, the old query results remain available in the… a web access log, metric data from a monitoring system, or the like, which is to …
Post: devops webinar - follow up Q&A
November 6, 2012 By 5 Comments
… cacti? A: Yes we do. They are part of Percona Monitoring Plugins. You can see some examples here. Q: What if… you hear about Liquibase, for syncing application code version and database version? Any opinion? A: First I want to apologize that… probably the best and more mature solution used to perform database change management. However there are many other alternatives like Flyway, c5…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL…j REJECT nothing changes, data stays different: percona1 mysql> select * from percona; +—-+—————+——–+ | id | inserted_… accepting queries to avoid database inconsistency. We can …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… and third node, you need to change wsrep_cluster_address (alternatively, you can…monitoring purposes (the CSV version is good for trending and alerting). Here MySQL is checked via HTTP checks. MySQL…database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… up with the database. The first step is to find out what MySQL instances are on the…and data types and table structures can be changed. Queries can be broken into pieces, combined,…frequently bring the discussion to topics such as monitoring, alerting, backups, caching, reverse proxies, and high …
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… and incremental backups of the cluster’s databases? Well, if you noticed, all the current …that won’t work with your change (i.e., your change will prevent replication from working if …monitored MySQL server in question. It should be easy to use this tool to monitor at least some of the monitoring…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… user perspective nothing has changed after the deletion. By the way, this is a good reason to monitor existence of these files… for ibdconnect, but as long as MySQL isn’t restarted it is possible to recover database fast. Let me illustrate how. Let… Add to your monitoring system checks that InnoDB files ibdata and ib_logfile* do exist Do not restart MySQL until the further…
