Category: MySQL & MariaDB

Feed: Planet MySQL; Author: Valeriy Kravchuk; My previous post from this series was published more than 1.5 years ago. I had never planned to stop writing about my everyday work on a regular basis, but sometimes it's not easy to pick up something really interesting for wider MySQL audience and when in doubts I always prefer to write about MySQL bugs...In any case, any long way starts from the first step, so I decided to write one post in this series per week and try to summarize in it whatever findings, questions, discussions, bugs and links I've collected over the ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Introduction             We are well aware that ProxySQL is one of the leading SQL aware proxy for MySQL. In this blog I am going to explain the backup & restore strategies of the ProxySQL . I think, still there is not well structured blog about this topic . If you are looking for other articles on our ProxySQL Series : MySQL replication Read-Write Split up Replication Switchover using Proxysql And MHA HA for proxysql with keepalived Mirroring MySQL Queries Handling Resource expensive Queries Percona Cluster/MariaDB cluster(Galera) Read-Write Split. Amazon Aurora (RDS) ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; MySQL Server generates several logs that can help you monitor the activities of the server. However, once these logs are enabled, they can grow in size and start taking up too much disk space. This is why it’s important to have an automated way of archiving and preserving MySQL log files for a certain duration, as well as deleting the old ones. In this blog post, we describe some best practices for setting up and managing MySQL error logs, general logs and slow query logs for your MySQL deployments. Setting Up MySQL Server Logging Let’s ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.6.44-85.0 on May 17, 2019. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on MySQL 5.6.44, and including all the bug fixes in it, Percona Server for MySQL 5.6.44-85.0 is the current GA release in the Percona Server for MySQL 5.6 series. Percona Server for MySQL is open-source and free – this is the latest release of our enhanced, drop-in replacement for MySQL. New Features: Bugs ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; PHP Implode Example | PHP implode() Function Tutorial is today’s topic. The implode function in PHP is used to join the elements of an array with a string. The implode() function returns the string from the elements of the array. The function is binary-safe. The implode() function returns a string containing the string representation of all the array items in the same order, with a glue string between each element. We join the array elements with the string. Just like join() function, implode() function also returns the string formed from the elements of the ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Percona Live provides the open source database community with an opportunity to discover and discuss the latest open source trends, technologies, and innovations. The conference includes the best and brightest innovators and influencers in the open source database industry. This year, Percona Live is being held at the Hyatt Regency in Austin, Texas from May 28-30, 2019. Pythian is proud to be a Silver Sponsor this year, with a full force of our technical experts speaking on a variety of subjects and technologies. These are sessions you won’t want to miss! If you’re ... Read More

Feed: Planet MySQL; Author: Continuent; About Continuous MySQL & MariaDB Database Operations & More at Percona Live Austin This Month! | Continuent LtdThis website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More Top ... Read More

Feed: Planet MySQL; Author: Shahid shaikh; Facebook Login is widely used as an authentication module on websites. Instead of asking user manual details such as email and password and then verify them, it’s better to use already verified user details. In this article, we are going to learn and implement a Facebook Login System using Nodejs and ExpressJS. You can download the code by clicking the button below. DOWNLOAD Creating Facebook App: Very first thing you going to need is AppID and AppSecret from Facebook App. Please go to Facebook Developers and create your app. Choose Website as platform when it ask. Give the ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . Description Account locking permits privileged administrators to lock/unlock user accounts. No new client connections will be permitted if an account is locked (existing connections are not affected). User accounts can be locked at creation, with the CREATE USER statement, or modified after creation with the ALTER USER statement. For example: CREATE USER 'lorin'@'localhost' ACCOUNT LOCK; or ALTER USER 'marijn'@'localhost' ACCOUNT LOCK; The server will return an ER_ACCOUNT_HAS_BEEN_LOCKED error when locked users attempt to connect: mysql -ulorin ERROR 4151 (HY000): Access denied, this account is locked The ALTER USER statement is also used ... Read More

Feed: Planet MySQL; Author: Jan Kneschke; Key features log-rotation via SIGHUP HTTP server plugin flexible support for single/multi-PRIMARY Group Replication Logrotation via SIGHUP Sending a SIGHUP signal to the router process will now close and reopen the logfile. It allows the integration with the logrotate to rotate and compress the Router’s logfiles. HTTP server plugin Support for running a HTTP server inside the mysqlrouter has been added Motivation The HTTP server plugin builds the foundation for features like: Monitoring Management which will appear in the upcoming releases of MySQL Router. In 8.0.16 it already supports: encrypted connections via TLS (up ... Read More