Tag: MySQL

Feed: Planet MySQL; Author: RoseHosting; In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS. A LAMP (Linux, Apache, MySQL, PHP) stack is a combination of open-source software, typically installed on a server used for hosting dynamic websites and web applications. It includes the Linux operating system, the Apache web server, MySQL or MariaDB for data storage and management, and PHP for handling any dynamic content. Installing LAMP on Debian 9 is a straightforward task and should not take more than 10 minutes. Let’s start with the installation. Table of Contents Prerequisites: A ... Read More

Feed: Recent Announcements. Once you create tags for your RDS DB instances, you can separate RDS backup charges in AWS Cost Explorer according to the tags of the corresponding DB instances. When you view your Cost and Usage Report (CUR), you’ll find that the ResourceId for each RDS ChargedBackup line contains the name of the corresponding DB instance, and tags associated with the DB instance are marked in additional columns. Note that detailed backup charges have been activated as of October 8, 2019. Your RDS backup charges prior to this date will continue to show up as a single line ... Read More

Feed: Neo4j Graph Database Platform. Author: Mark Needham. Our team was in Ängelholm, Sweden this week, to spend some time working together which is rare as a distributed group. But especially also to run the very first Neo4j Online Developer Conference (NODES), with more than 50 sessions by speakers from 15 countries in 5 tracks. Thanks a lot to everyone who presented, contributed and helped. So we’re excited to make the first content available, Emils Keynote and announcements. In the Keynote he covered the impressive Neo4j community, Jim Webber showed a preview of 4.0 features, Michael spoke about Neo4j Labs ... Read More

Feed: Planet MySQL; Author: Continuent; Business-Critical MySQL using open source is free, right?Managed MySQL cloud services do not need database administrators, correct? Well… Think again – and watch the replay of this webinar with our partner Datavail hosted by Database Trends & Applications on whether free is good enough for business-critical MySQL database environments. Listen in as Srinivasa Krishna, MySQL Practice Leader at Datavail, and Eero Teerikorpi, CEO & Founder at Continuent discuss the pros and cons of the DIY approach vs getting professional help in. This webinar discusses the limitations and hidden costs of DIY solutions for business-critical MySQL; ... Read More

Feed: Planet MySQL; Author: Øystein Grøvlen; As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to POLARDB for MySQL. As discussed in the presentation, we observe that parallel range scans on secondary indexes does not scale very well in MySQL. This is old news. Mark Callaghan reported this several years ago, and this does not seem to have changed. In this blog post, I will investigate what effects using a multi-processor machine have on the scalability of parallel index range scans. I will run a variant ... Read More

Feed: Planet MySQL; Author: Ivan Ma; MySQL InnoDB Cluster is easy to configure and deploy.  This article is written to provide 3 group replication parameter settings which may contribute to the stability and reliability of the Network in MySQL InnoDB Cluster.With MySQL 8.0, there are at least 3 most important parameters in Network Reliability Settings.1. group_replication_member_expel_timeout 2. group_replication_autorejoin_tries 3. group_replication_unreachable_majority_timeout "group_replication_member_expel_timeout"- default = 0When a node is considered to be disconnected, the majority group will wait for a time period in order to reform this majority group.   By default, there is a 5 seconds + "group_replication_member_expel_timeout" as time period to ... Read More

Feed: Planet MySQL; Author: Severalnines; In the previous blog in the series we discussed the pros and cons of using Galera Cluster to create geo-distributed cluster. In this post we will design a Galera-based geo-distributed cluster and we will show how you can deploy all the required pieces using ClusterControl. Designing a Geo-Distributed Galera Cluster We will start with explaining the environment we want to build. We will use three remote data centers, connected via Wide Area Network (WAN). Each datacenter will receive writes from local application servers. Reads will also be only local. This is intended to avoid unnecessary ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Good news ! Once agin, the MySQL, MariaDB & Friends Devroom has been accepted for FOSDEM’20‘s edition !! This event is a real success story for the MySQL ecosystem; the content, the speakers and the attendees are growing every year. FOSDEM 2020’s edition will take place 1st & 2nd February in Brussels and our MySQL, MariaDB & Friends devroom will run on Saturday 1st (may change). FOSDEM & MySQL/MariaDB is a love story started 20 years ago ! The committee selecting the content for our devroom is not yet created and if you want ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Since three years of our entity’s progression, Mydbops IT Solutions, Bangalore, have been an active participant of Open Source India (OSI) conference, conducted by Open Source For You Magazine which is part of EFY Group, New Delhi. This annual event is an attempt by the team at Open Source For You magazine in partnership with India’s Open Source community and industry—to bring various stake-holders under one roof. The mission of OSI is simple—to accelerate development and deployment of Open Source in India, and beyond. This year our floor presence has been shifted to the Entry Bay itself, ... Read More

Feed: Microsoft Azure Blog. Author: John Montgomery. As customers have moved their workloads to the cloud, we’ve seen a growth in the use of cloud-native architectures, particularly microservices. Microservice-based architectures help improve scalability and velocity but implementing them can pose challenges. For many Java developers, Spring Boot and Spring Cloud have helped address these challenges, providing a robust platform with well-established patterns for developing and operating microservice applications. But creating and maintaining a Spring Cloud environment requires work. Such as setting up the infrastructure for dynamic scaling, installing and managing multiple components, and wiring up the application to your logging ... Read More