Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 16461 10 Older Entries

Displaying posts with tag: mysql (reset)

Benchmarking Joomla
+0 Vote Up -0Vote Down
This post recently caught my attention on Planet MySQL. If you haven’t read it yet, I suggest that you go and do so, and also read the comments. I think Matthew’s request for the queries so that others can run comparative benchmarks is very interesting, and while I don’t have access to the queries used to produce […] Related posts:
  • Updated mysql-proxy benchmarking script (for proxy 0.7) My previous post contained a lua script for MySQL proxy...
  • Using MySQL Proxy to benchmark query performance By transparently sitting between client and server on each request,...
  •   [Read more...]
    The Perfect Server - Ubuntu 14.10 with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig
    +0 Vote Up -1Vote Down

    The Perfect Server - Ubuntu 14.10 with Apache, PHP, MySQL, PureFTPD, BIND, Postfix, Dovecot and ISPConfig

    This tutorial shows how to install an Ubuntu 14.10 (Utopic  Unicorn) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers the installation of Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

    Benchmark of Load Balancers for MySQL/MariaDB Galera Cluster
    +1 Vote Up -0Vote Down
    October 31, 2014 By Severalnines

    When running a MariaDB Cluster or Percona XtraDB Cluster, it is common to use a load balancer to distribute client requests across multiple database nodes. Load balancing SQL requests aims to optimize the usage of the database nodes, maximize throughput, minimize response times and avoid overload of the Galera nodes. 

    In this blog post, we’ll take a look at four different open source load balancers, and do a quick benchmark to compare performance:

    • HAproxy by HAproxy Technologies
    • IPVS by Linux Virtual Server Project
    • Galera Load Balancer by Codership
      [Read more...]
    Get a handle on your HA at Percona Live London 2014
    +1 Vote Up -1Vote Down

    From left: Liz van Dijk, Frédéric Descamps and Kenny Gryp

    If you’re following this blog, it’s quite likely you’re already aware of the Percona Live London 2014 conference coming up in just a few days. Just in case, though (you know, if you’re still looking for an excuse to sign up), I wanted to put a spotlight on the tutorial to be delivered by my esteemed colleagues Frédéric Descamps (@lefred) and Kenny Gryp (

      [Read more...]
    The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3)
    +0 Vote Up -0Vote Down

    The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3)

    This tutorial shows how to prepare a CentOS 7 x86_64 server for the installation of ISPConfig 3 and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.

    Geohash Functions
    Employee_Team +1 Vote Up -0Vote Down

    In MySQL 5.7.5, we introduced new functions for encoding and decoding Geohash data. Geohash is a system for encoding and decoding longitude and latitude coordinates in the WGS 84 coordinate system, into a text string. In this blog post we will take a brief look at a simple example to explain just how geohash works.

    Where on earth is “u5r2vty0″?

    Imagine you get a email from your friend, telling you that there is free food at “u5r2vty0″. But where on earth is “u5r2vty0″?

    The first step in converting from “u5r2vty0″ to latitude and longitude data, is decoding the text string into its binary representation. Geohash uses base32 characters, and you can find the character

      [Read more...]
    How to deal with MySQL deadlocks
    +0 Vote Up -0Vote Down

    A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transaction immediately and returns an error. It uses a metric to pick the easiest transaction to rollback. Though an occasional deadlock is not something to worry about, frequent occurrences call for attention.

    Before MySQL 5.6, only the latest deadlock can be reviewed using SHOW ENGINE INNODB STATUS command. But with Percona Toolkit’s pt-deadlock-logger you can have deadlock information retrieved from SHOW ENGINE INNODB STATUS at a given interval and saved to a file or table for late

      [Read more...]
    Data Warehouse in the Cloud - How to Upload MySQL data into Amazon Redshift for reporting and analytics
    +0 Vote Up -0Vote Down
    October 27, 2014 By Severalnines

    The term data warehousing often brings to mind things like large complex projects, big businesses, proprietary hardware and expensive software licenses. With Hadoop came open source data analysis software that ran on commodity hardware, this helped address at least some of the cost aspects. We had previously blogged about MongoDB and MySQL to Hadoop. But setting up and maintaining a Hadoop infrastructure might still be out of reach for small

      [Read more...]
    Refactoring replication topologies with Pseudo GTID: a visual tour
    +0 Vote Up -0Vote Down

    Orchestrator 1.2.1-beta supports Pseudo GTID (read announcement): a means to refactor the replication topology and connect slaves even without direct relationship; even across failed servers. This post illustrates two such scenarios and shows the visual way of mathcing/re-synching slaves.

    Of course, orchestrator is not just a GUI tool; anything done with drag-and-drop is also done via web API (in fact, the drag-and-drop invoke the web API) as well as via command line. I'm mentioning this as this is the grounds for failover automation planned for the future.

    Scenario 1: the master unexpectedly dies

    The

      [Read more...]
    Orchestrator 1.2.1 BETA: Pseudo GTID support, reconnect slaves even after master failure
    +0 Vote Up -0Vote Down

    orchestrator 1.2.1 BETA is released. This version supports Pseudo GTID, and provides one with powerful refactoring of one's replication topologies, even across failed instances.

    Depicted: moving a slave up the topology even though its local master is inaccessible

    Enabling Pseudo-GTID

    You will need to:

  • Inject a periodic
  •   [Read more...]
    Showing entries 1 to 10 of 16461 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.