The latest from the MySQL community

Join us for this new webinar on Tuesday, May 24th, where we’ll be discussing and demonstrating the latest version of ClusterControl, the one-stop console for your entire database infrastructure. We’ll be introducing some cool new features for MySQL and MongoDB users in particular as well as walk you through the work we’ve recently done for improved security.

Our colleagues Johan Andersson (CTO), Vinay Joosery (CEO) and Ashraf Sharif (System Support Engineer) will be demonstrating how you can deploy, monitor, manage and scale your databases on the technology stack of your choice with ClusterControl.

Date, Time & Registration Europe/MEA/APAC

Tuesday, May 24th at 09:00 BST / 10:00 CEST (Germany, France, Sweden)
Register Now

North America/LatAm

Tuesday, May 24th at 09:00 Pacific Time (US) / 12:00 …

Lossless RBR TL/DR: There’s been talk of moving the next release of MySQL to minimal RBR: I’d like to suggest an alternative: lossless RBR For MySQL 5.8 there was talk / suggestions about moving to minimal RBR as the default configuration (http://mysqlserverteam.com/planning-the-defaults-for-mysql-5-8/).  I’m not comfortable with this because it means that by default you do not have … Continue reading Lossless RBR for MySQL 8.0?

The post Lossless RBR for MySQL 8.0? first appeared on Simon J Mudd's Blog.

hi Vaisakh.

yes it is possible.

in the file ‘/opt/prometheus/prometheus.yml’ :

Under the Job_Name ‘mysql’ you have a target group which can have multiple targets.

by default the MySQL Exporter process is bound to 9104.

You need to start another MySQL Exporter process running with Another Config file which points to another RDS instance on a different port , say 9105

Command to Run:
————————
./mysqld_exporter
-config.my-cnf=
-log.level=debug
-web.listen-address=localhost:9105

2ND_RDS_CONFIG_FILE
———————————–
[client]
user=prom
password=abc123
host=amazon-rds-2nd-instance.amazonaws.com

Modified Prometheus.yml:
———————————————————

global:
scrape_interval: 5s
evaluation_interval: 5s
…

I’m happy to be back in London in May 2016, to talk at two events:

1. The London MySQL Meetup Group – Monday May 9 – 6.30 PM – 9.00 PM – options for High Availability in the ecosystem that one would consider today. This is a cut down from my Percona Live tutorial, which had about 88 registered attendees and about that amount showed up and asked questions even through the break and after. I had a lot of fun, and I expect I will have similar fun in London talking about this area that has changed a lot in recent times.
2. Data for the Enterprise – MariaDB Roadshow in London – Wednesday, May 11, 2016 from 9:30 AM to 2:00 …

Who are the top individual authors of influential recent posts to planet MySQL?  The planet MySQL page includes a list of the top 20 authors as well as a list of the top 10 vendor blogs.  However, since posts to the vendor blogs make up at least 1/4 of all of the posts, and the authors of vendor blog posts are not included in the top author list, I decided to compute my own top author list.  I include the hidden authors from the vendor blogs when computing my top author list.

The first problem is to identify the hidden authors for posts from each vendor blog.  This requires that the author information be extracted from the individual posts, and this requires a specialized parser for each vendor blog to extract the author name from the document.
The second problem is to rank the authors using some criteria such as the number of posts in a given recent time range.   I could run a page rank algorithm if I …

Sometimes we require to get request method is get post patch delete that way we can take action if need take action on depend on request input method so you can check using request method so lets see bellow examlestrongExamplestrong pre classprettyprint langphpmethod reques

Nice post Vishnu ! But is this solution works well for multiple RDS instances ? We are using tcollector to get the metrics from cloudwatch using boto plugin and tag the metric with the rds instance name. Tcollector->TSD->Grafana.

Since documentation is not very clear to me on the topic of InnoDB flushing in combination with Linux IO (specifically the write system call), I decided to put together this article in hopes of shedding some light on the matter.

How Linux does I/O

By default, the write() system call returns after all data has been copied from the user space file descriptor into the kernel space buffers. There is no guarantee that data has actually reached the physical storage.

The fsync() call is our friend here. This will block and return only after the data and metadata (e.g. file size, last update time) is completely transferred to the actual physical storage.

There is also fdatasync() which only guarantees the data …

I think we should use captcha code on our registration form because captcha code prevent spams bots etc Most of the application we need to use captcha varification because it very important for security reason There are several library to generate captcha image in Laravel In this example i use B

Thu, 2016-05-05 15:33Colin Charles

I'm now in Hanoi, Vietnam, for the launch of OpenCPS. What, might you ask, is OpenCPS? OpenCPS translates to Open Core Public Services, as Vietnam is providing online public services and OpenCPS should sit at its core. Naturally, all of this will be open source, and AGPL licensed. OpenCPS is the first open source project to realize the development of e-government services in Vietnam.

Why does this matter to us? Because at the core of its infrastructure is of course, MariaDB Server as the database of choice, with Red Hat being the Linux provider of choice.

I met the interim project lead, Truong Anh Tuan, quite sometime ago, but the tipping point was a keynote presentation on MariaDB Server at FOSSASIA 2015, in Singapore (so thanks again to the organisers for ensuring I keynoted about MariaDB Server there). So when they approached me at …