June 20, 2013

Post: What technologies are you running alongside MySQL?

… environments MySQL is not the only technology used to store in-process data. Quite frequently, especially with large-scale or complicated… and processing do you use alongside MySQL in your environment? Please feel free to elaborate in the comments about your use case…

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… to reach a threshold where it’s easier to find folks with PXC in production and such the need for more advanced… some key questions/issues/pain-points for those with PXC in production already.   As such, I’m giving a webinar entitled…

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… initial setup goes into bootstrapping the first node. Note that in the cloud environment other nodes are not known until they… transfer). Node3 subsequently joins the cluster with node1 and node2 in its gcomm:// (since by this time node1, node2 are up… clustercheck with a single serving process (we are adding one in 5.5.31), looking for optimizations with HAProxy to account…

Comment: How to calculate a good InnoDB log file size

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

Comment: Percona Server 5.6.11-60.3 first Release Candidate now available

does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?

Comment: Data mart or data warehouse?

Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.

Post: Call for papers: Percona Live London

… actively using MySQL, Percona Server, MariaDB, Drizzle or (fill in the blank) in production? Are you managing multiple environments? Are you working… perspective about the internals or explain how specific features work in depth. These stories are gold! And you owe it to… look at the benefits of sponsorship. Questions? Let me know in the comments section. I look forward to hearing from you!

Comment: Sphinx search performance optimization: attribute-based filters

Fabian, – please note that, as stated in the article, this technique only works well for highly selective …

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

… 1 row in set (0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in the same….test’. This is deprecated and will be disallowed in a future release. 1 row in set (0.00 sec) As the message points… MySQL, for which we at Percona tend to find redundant indexes. And second, because in some cases, we may need to have…

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

… this bandwidth constraint is to switch to multicast UDP replication in Galera.  This is actually really easy to do. First, we… have wsrep_provider_options set, add it to the semicolon separated list instead of a separate line in your config. If we…_node_address setting on each node if this IP is not the default IP of the server. I could not find a…