Tag: MySQL Replication

Feed: Planet MySQL; Author: Oracle MySQL Group; As continue of the previous blog posted on Aug 17, 2017, please find below a list conferences & events where you can find MySQL Community team or MySQL experts during the period of second half of September till end of December. The ones which are new are marked below. Please be aware that the list does not have to be final and during the time more events could be added or some of them removed.  Madison PHP, Madison, US, Sep 22-23, 2017​ MySQL Community team is supporting this PHP conference as Community partner. Oracle ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Reduce human interaction when using an asynchronous slave to a MySQL InnoDB Cluster – lefred's blog: tribulations of a MySQL Evangelist A MySQL replication topology can be very complex (never underestimate a DBA’s creativity). But it’s very frequent to use an asynchronous slave from your primary database to run reporting or logical backup… or any kind of read workload you need. It can also be used as delay slave for data restore purpose. Once you decided to provide HA to your primary database by migrating to MySQL InnoDB Cluster, you can of course still ... Read More

Feed: Planet MySQL; Author: Severalnines; While many of our customers utilize ClusterControl on-premise to automate and manage their open source databases, several are deploying ClusterControl alongside their applications in the cloud. Utilizing the cloud allows your business and applications to benefit from the cost-savings and flexibility that come with cloud computing. In addition you don’t have to worry about purchasing, maintaining and upgrading equipment. Along the same lines, ClusterControl offers a suite of database automation and management functions to give you full control of your database infrastructure. With it you can deploy, manage, monitor and scale your databases, securely and ... Read More

Feed: Planet MySQL; Author: Shlomi Noach; orchestrator 3.0.2 GA is released and available for download (see also packagecloud repository). 3.0.2 is the first stable release in the 3.0* series, introducing (recap from 3.0 pre-release announcement): orchestrator/raft Raft is a consensus protocol, supporting leader election and consensus across a distributed system.  In an orchestrator/raft setup orchestrator nodes talk to each other via raft protocol, form consensus and elect a leader. Each orchestrator node has its own dedicated backend database. The backend databases do not speak to each other; only the orchestrator nodes speak to each other. No MySQL replication setup needed; the backend DBs act as standalone servers. In fact, the backend ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Team speaking at Percona Live Dublin 2017 – lefred's blog: tribulations of a MySQL Evangelist From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of key developers will present their own work. We have so much talented people in MySQL we want to ... Read More

Feed: Planet MySQL; Author: Roberto V. Zicari; “To be competitive with non-open-source cloud deployment options, open source databases need to invest in “ease-of-use.” There is no tolerance for complexity in many development teams as we move to “ops-less” deployment models.” –Peter Zaitsev I have interviewed Peter Zaitsev, Co-Founder and CEO of Percona. In this interview, Peter talks about the Open Source Databases market; the Cloud; the scalability challenges at Facebook; compares MySQL, MariaDB, and MongoDB; and presents Percona’s contribution to the MySQL and MongoDB ecosystems. RVZ Q1. What are the main technical challenges in obtaining application scaling? Peter Zaitsev: When ... Read More

Feed: Percona Database Performance Blog. Author: Colin Charles. Colin Charles  | September 1, 2017 |  Posted In: MariaDB, MyRocks, MySQL, Percona Live, Percona Server PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe Dublin Have you registered for Percona Live Europe Dublin? We’ve more or less finalized the schedule, and the conference grid looks 100% full. We’re four weeks away, so I suggest you register ASAP! I should also mention that no event can be pulled off without sponsors, so thank you sponsors of Percona Live ... Read More

Feed: Planet MySQL; Author: Severalnines; Building high availability, one step at a time When it comes to database infrastructure, we all want it. We all strive to build a highly available setup. Redundancy is the key. We start to implement redundancy at the lowest level and continue up the stack. It starts with hardware - redundant power supplies, redundant cooling, hot-swap disks. Network layer - multiple NIC’s bonded together and connected to different switches which are using redundant routers. For storage we use disks set in RAID, which gives better performance but also redundancy. Then, on the software level, we ... Read More

Feed: Planet MySQL; Author: Severalnines; Since it was originally published more than 63,000 people (to date) have leveraged the MySQL for Galera Cluster Tutorial to both learn about and get started using MySQL Galera Cluster. Galera Cluster for MySQL is a true Multi-master Cluster which is based on synchronous replication. Galera Cluster is an easy-to-use, high-availability solution, which provides high system uptime, no data loss and scalability to allow for future growth. Severalnines was a very early adopter of the Galera Cluster technology; which was created by Codership and has since expanded to include versions from Percona and MariaDB.   ... Read More

Feed: Planet MySQL; Author: Severalnines; Galera Cluster is a synchronous multi-master replication plugin for InnoDB or XtraDB storage engine. It offers a number of outstanding features that standard MySQL replication doesn’t - read-write to any cluster node, automatic membership control, automatic node joining, parallel replication on row-level, and still keeping the native look and feel of a MySQL server. This plug-in is open-source and developed by Codership as a patch for standard MySQL. Percona and MariaDB leverage the Galera library in Percona XtraDB Cluster (PXC) and MariaDB Server (MariaDB Galera Cluster for pre 10.1) respectively. We often get the question ... Read More