… can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about… MySQL on top of something like that? I can’t imagine the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL‘s internal understanding of what’s happening on…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…, talk to your network guys). I’m using 239.192.0.11, so we’ll add this to our my.cnf: wsrep_provider… 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…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… the tmpdir was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor… InnoDB concurrency. Bug fixed #1155183 (Seppo Jaakola). Handling of the network issues in Galera has been improved. Bug fixed #1153727 (Teemu…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket… of a private network for replication if needed. Next is the mysql primitive resource declaration. This primitive defines the mysql resource on each…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… for MySQL, in a space not much bigger than your mouse, with the power consumption of only a smartphone charger, fully networked… build into your laptop or PC already) Network setup A network lead and spare network port on your router A DHCP server (your… edit the configuration file, you can find it in /etc/mysql/my.cnf If you setup Percona Server to startup at boot time…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…much difference if you get some sporadic network errors both can give problems. I …sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring to amounts of memory we have in the phones these days, I made in my Optimizing MySQL…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… sure that the script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). Now you…, which is why the collect tool also gathers information about network connections, and so on. If you assume a particular type…. There are many things that can cause a stall in MySQL, and they usually begin microscopically and get worse over time…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… than this article can cover, and might wander into Apache, networking config, caching layers, etc. Wherever the problem is, we’ll…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way… OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
….bootstrap=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post or…slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I…lead to inconsistency in case of a network split. If a network split happens and a node decides…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… 192.168.70.2 -j REJECT This rule simulates a network outage that makes the connections between the two nodes impossible… not work properly currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc.ignore_quorum…” in my.cnf Then we can insert in both nodes without any problem when the connection between the nodes is gone: percona1 mysql…
