Tag: replication

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog, I want to evaluate Group Replication Scaling capabilities in cases when we increase the number of nodes and increase user connections.For testing, I will deploy multi-node bare metal servers, where each node and client are dedicated to an individual server and connected between themselves by a 10Gb network.Also, I will use 3-nodes and 5-nodes Group Replication setup.Hardware specifications: System | Supermicro; SYS-F619P2-RTN; v0123456789 (Other) Service Tag | S292592X0110239C Platform | Linux Release | Ubuntu 18.04.4 LTS (bionic) Kernel | 5.3.0-42-generic Architecture | CPU = 64-bit, OS = 64-bit Threading | ... Read More

Feed: Liquid Web. Author: Liquid Web; Considering Web Hosting from GoDaddy? GoDaddy has long been the on-ramp for businesses, hobbyists, and entrepreneurs looking to finally get online. And why not? As one of the leading domain registrars in the world, for many people GoDaddy is the first step in what can be a lifelong digital journey. But what makes sense as a starting point isn’t always the best choice over the long term. While GoDaddy offers a wide-range of options for hosting and support, the truth is that most businesses quickly outgrow the technical capability of those options. What’s more, ... Read More

Feed: Blog – Hazelcast. Author: Burak Celebi. In the first blog post, I explained the Blue/Green Deployments feature of Hazelcast IMDG Enterprise in general. Now, it is time to go through the top 5 scenarios where you can benefit this feature from. When using these features, it may be necessary to copy data or synchronize data from one cluster to the other. The following Hazelcast Enterprise features can be employed. WAN Replication: Hazelcast WAN Replication keeps multiple geographically dispersed Hazelcast clusters in sync by replicating their state over wide area networks. Please see WAN Replication sections in the IMDG Reference ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one of this series talked about the first six things you can do, and in part two, we will be discussing numbers seven through twelve.7. Get More MemoryComplexity: LowPotential Impact: HighIf your data does not fit into memory well, your MySQL performance is likely to be severely limited. If your data already fits in well, adding even more memory will not provide any performance improvements.Even when you’re running on very fast storage, ... Read More

Feed: Planet MySQL; Author: The Pythian Group; While testing in an orchestrator lab I saw that none of my Orchestrator on-raft nodes were coming online after a reboot. This is the status report from SystemD. $ sudo systemctl status orchestrator * orchestrator.service - orchestrator: MySQL replication management and visualization Loaded: loaded (/etc/systemd/system/orchestrator.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2020-04-03 09:30:05 UTC; 30s ago Docs: https://github.com/github/orchestrator Main PID: 957 (code=exited, status=1/FAILURE) Apr 03 09:30:05 orchestrator-1 systemd[1]: Started orchestrator: MySQL replication management and visualization. Apr 03 09:30:05 orchestrator-1 orchestrator[957]: 2020-04-03 09:30:05 ERROR dial tcp 127.0.0.1:3306: connect: connection refused ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; My weekdays are still busy even during this lockdown period, but weekend is a perfect time for yet another blog post about MySQL bugs I considered interesting. Very few followers read my posts on other topics anyway, especially if they have the "M....DB" word...So, here is a new list of optimizer, replication, InnoDB and few other bugs in GA versions of MySQL that I've subscribed to since the end of February, 2020:Bug #98675 - "LIMIT clause in derived table garbles EXPLAIN Note". It's not a big deal and in specific case presented by Øystein Grøvlen ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; This is a three-part blog series. Be on the lookout for parts two and three in the coming days.There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with these days. This series focuses on dealing with the unexpected high traffic event as it is happening.There are also a lot of things you can do proactively, which we covered in “Prepare Your Databases for High Traffic on ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: kip-yego; As data proliferates, the need to efficiently undertand, process, and act quickly for competitive advantage continues to increase. Applications must be able to use data swiftly and adapt as needs change by the week or even the day. Developers also require places to store their data that can handle multiple formats and use cases. In order to manage these growing data needs, drive innovation and increase agility via modern application development, enterprises are turning to open-source-based solutions and technologies. The State of Enterprise Open Source report by Red Hat ... Read More

Feed: Planet MySQL; Author: Continuent; For this next ‘multi-master MySQL’ blog in our Continuent MySQL Use Case series, we’re focusing on Financial Services Saas providers.Often referred to as the number one open source database in the cloud, and a leading SaaS database, MySQL enables SaaS vendors to be competitive because it provides cost-effective data security and privacy, performance, and availability amongst other things, which are of particular importance for a SaaS business. As per our previous multi-master MySQL use case blog (for e-commerce sites), multi-master replication for MySQL typically means that a user can write to any master node knowing ... Read More

Feed: Clustrix Blog. Author: Saravana Krishnamurthy. SkySQL is the first database-as-a-service (DBaaS) to unlock the full power of MariaDB Platform in the cloud. Engineered for mission-critical applications and enterprise governance, SkySQL cloud database is focused on features which make life better for the developer, the DBA, and the operator — extending powerful enterprise features with unrivaled ease of use and first-in-class innovation.MariaDB Platform for Transactions Whether you need transactional capabilities for dev/test or production, MariaDB Platform for Transactions delivers the robust modern SQL capabilities of MariaDB Enterprise Server either in single-node Standalone configuration, or in a multi-node replicated Primary/Replica topology ... Read More