Tag: replication

Feed: Planet MySQL; Author: Lalit; Recently, Oracle added new certification for MySQL, MySQL Cloud Service 2018 Implementation Essentials This exam is all about MySQL Enterprise Edition 5.6. with MySQL Cloud Service. Best study resource for this exam is “MySQL official documentation”. Along with MySQL Enterprise topic, this exam also includes one major part of MySQL Cloud Service. Exam Topics:  Oracle MySQL Enterprise Product Suite Installation and Architecture Database Design MySQL Security Leverage MySQL Enterprise Monitor Leverage MySQL Backup MySQL Overview of High Availability and Replication MySQL Cloud Service Will write more about these exam topics in our next blog post. Feel free ... Read More

Feed: Percona Database Performance Blog. Author: Yves Trudeau. Yves Trudeau  | September 15, 2017 |  Posted In: High-availability, Maxscale, MySQL, ProxySQL PREVIOUS POST This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and mature technologies. In this post, we will look at the emerging MySQL high availability solutions. The “baby” MySQL high availability solutions I chose for the blog are group replication, proxies and distributed storage ... Read More

Feed: Planet MySQL; Author: René Cannaò; In the two previous blog posts about ProxySQL Cluster we described how to setup a Cluster, how to add users/rules and propagate them across the Cluster, how to provision new nodes, how to re-sync nodes after they have been out of the Cluster, and some features in the roadmap, especially around the concept of core nodes vs satellite nodes.We also mention that there are 4 modules/tables that currently ProxySQL Cluster is able to sync: mysql_query_rules mysql_servers mysql_users proxysql_servers We covered 3 of these, and the last one missing is how to sync mysql_servers, related ... Read More

Feed: What's New. StorReduce is a specialized cloud deduplication solution for companies that use object storage like Amazon Simple Storage Service (Amazon S3) for large volumes of data. StorReduce sits between your applications and the object store, transparently performing inline data deduplication at ratios equaling those of industry-best purpose-built appliances while exposing the Amazon S3 API. Storage and bandwidth requirements are reduced by as much as 30 times, and data transfer times and backup windows can be reduced by the same amount.  The AWS Cloud provides a suite of infrastructure services that enable you to deploy StorReduce in a highly ... Read More

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: Percona Database Performance Blog. Author: Dave Avery. Dave Avery  | September 14, 2017 |  Posted In: Database Monitoring, MongoDB, MySQL, Percona Live PREVIOUS POST Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post is with Bernd Erk, CEO of Icinga. His talk is titled Monitoring Open Source Databases with Icinga. Icinga is a popular open source successor of Nagios that ... Read More

Feed: Microsoft Azure Blog. Author: Hector Linares. Azure provides global scale cloud computing running in Microsoft Datacenters in over 40 regions. Azure Stack extends the value of Azure to a wider range of customers and scenarios by making a core set of services available to run on integrated systems running in customer’s or service provider datacenters. Many companies and service providers are evaluating Azure Stack Development Kit (ASDK) to learn more. Many of these companies are going beyond evaluation and thinking through strategy, design, and implementation of a hybrid cloud for modern apps and on-premises cloud services. Business continuity and ... Read More

Feed: Percona Database Performance Blog. Author: Vadim Tkachenko. Vadim Tkachenko  | September 13, 2017 |  Posted In: Database Monitoring, Insight for DBAs, MySQL, Yandex ClickHouse PREVIOUS POST In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data sets, and a very popular task is crunching log files. Below I’ll show how ClickHouse can be used to efficiently perform this task. ClickHouse is attractive because it has multi-core parallel ... Read More

Feed: Percona Database Performance Blog. Author: Emily Ikuta. Emily Ikuta  | September 12, 2017 |  Posted In: Database Monitoring, Insight for DBAs, Insight for Developers, MySQL, Technical Webinars, Yandex ClickHouse PREVIOUS POST Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). ClickHouse is a real-time analytical database system. Even though they’re only celebrating one year as open source software, it has already proved itself ready for serious workloads. We will talk about ClickHouse in general, some of its internals and why ... Read More