Tag: MySQL

Feed: Planet MySQL; Author: Searce Engineering; MySQL Adventures: GTID Replication In AWS RDSYou all heard about that today AWS announced that RDS is started to support GTID Transactions. I’m a great fan of RDS but not for GTID. Since RDS has better settings and configurations to perform well. Many of you people read about the AWS What’s new page regarding GTID. But here we are going to talk about the actual benefits and drawbacks.RDS supports GTID on MySQL 5.7.23 or later. But AWS released this version on Oct10 (two days before). So, for now, this is the only version which supports ... Read More

Feed: Planet MySQL; Author: Ivan Ma; MySQL InnoDB Cluster Setup and ConfigurationReference : https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.htmlPr-requisite  Assumption :     MySQL Server 8.0.12+ installation : /usr/local/mysql     MySQL Shell installation : /usr/local/shell     MySQL Router Installation : /usr/local/router     Hostname and IP must be resolvable.            Make sure the /etc/hosts valid to have the IP and Hostname entries correctly with ALL MySQL Server machines.The Video [ https://youtu.be/_jR_bJGTf-o ] provides the full steps showing the Demonstration of 1. Setting up of 3 x MySQL Servers on 1 VM     a.  Configuration my1.cnf, my2.cnf and my3.cnf    b.  MySQL  Server (mysqld) initialization          # mysqld --defaults-file= ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX, Dubai, United Arab Emirates, October 14-18, 2018 Same as last year Oracle & MySQL are part of GITEX converence. There is an Oracle booth (Stand A5-01, Hall 5) as well as MySQL one (POD2, Hall 5) where you can find us.  ZendCon, Las Vegas, US, October 15-17, 2018 We are Exhibitor sponsor same as last year, however newly ... Read More

Feed: Planet PostgreSQL. After a recent chat with a DBA, making his first steps towards migrating a big database away from Oracle to Postgres, I thought there must be just too few articles on PostgreSQL features and “hacks”, aiding in achieving scalability to squeeze the last out of the hardware to safely accomodate some decent multi-terabyte size databases. Especially as there are quite a few options out there, I was very surprised that there was so much fear that Postgres is somehow very limited in the scaling matters. Well maybe it was indeed once so (I started with Postgres in ... Read More

Feed: Planet MySQL; Author: rathishDBA; Error Message: ERROR 1396 (HY000): Operation CREATE USER failed for 'admin'@'%' Generic Error Message: Operation %s failed for %s Error Scenario: Operation CREATE USER failedOperation DROP USER failed The reason for this error is, you are trying to do some user operation but the user does not exist on the MySQL system. Also, for drop user, the user details are stored somewhere in the system, even though, you have already dropped the user from MySQL server. Resolution: Revoke all access granted to the user, drop the user, and run FLUSH PRIVILEGE command to remove the ... Read More

Feed: Planet MySQL; Author: Jaime Crespo; Jaime Crespo  | October 15, 2018 |  Posted In: Events, MariaDB, MySQL, Open Source Databases PREVIOUS POSTFor Percona Live Europe this year, I got accepted a workshop on query optimization and a 50-minute talk covering TLS for MySQL at Large Scale, talking about our experiences at the Wikimedia Foundation.WorkshopThe 3-hour workshop on Monday, titled Query Optimization with MySQL 8.0 and MariaDB 10.3: The Basics is a beginners’ tutorial–though dense in content. It’s for people who are more familiar with database storage systems other than InnoDB for MySQL, MariaDB or Percona Server. Or who, already familiar with ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST pt-query-digest is one of the most commonly used tool when it comes to query auditing in MySQL®. By default, pt-query-digest reports the top ten queries consuming the most amount of time inside MySQL. A query that takes more time than the set threshold for completion is considered slow but it’s not always true that tuning such queries makes them faster. Sometimes, when resources on server are busy, it will impact every other operation on the server, and so will impact queries too. In such cases, you will see the proportion of slow ... Read More

Feed: Planet MySQL; Author: Codership; We will have a kiosk at Moscone Center, south exhibition hall, Oracle’s Data Management area number 123, close to high availability area and exits 16 and 18. Our kiosk number is DBA-P1. Our CEO and Co-Founder Seppo Jaakola will host a presentation highlighting the main features of our upcoming Galera Cluster 4.0. The presentation will take place Monday, Oct 22, 1:00 p.m. – 1:20 p.m at the Exchange @ Moscone South – Theater 2. Seats are limited! Come and meet us! Let’s discuss your MySQL high availability plan or your Galera Cluster deployment. If you ... Read More

Feed: AWS Government, Education, & Nonprofits Blog. Author: publicsector. The Canberra Grammar School Code Cadets are a group of students with a passion for technology and applying their knowledge towards interesting projects beyond the classroom. The Code Cadets have been working with AWS technology for many years, being long-time participants in GovHack, which AWS has supported in the past – and are planning to use AWS Educate in their Year 9 and 10 elective software development courses next year.Recently, the Code Cadets applied a combination of their knowledge and skill using AWS technology to “rebooting” the School’s Athletics Carnival. With ... Read More

Feed: Planet MySQL; Author: Dave Stokes; The 2018 MySQL Community Reception is October 23rd in a new venue at Samovar Tea, 730 Howard Street in San Francisco at 7:00 PM.   Right in the heart of the Moscone Center activities for Oracle OpenWorld and Oracle Code one activities.The MySQL Community Reception is not part of Oracle OpenWorld or Oracle Code One (you do not need a badge for either event) but you do need to RSVP.  Food, drinks, and a really amazing group of attendees!   And there will be more than tea to drink.Plus we have a few new surprises this ... Read More