0
votes
1answer
13 views

Create t2 instance and connect via Wokrbench

I've created an t2 RDS instance inside a VPC. The instance is set to Publicly avaiable: No. I wasn't able to connect to the instance using MySQL Workbench. Is there an option to connect to the ...
0
votes
2answers
38 views

Replicated timestamp column in different timezone

I have the master running Mysql 5.5.38 on Ubuntu 14.04 LTS. The timezone in the master is UTC+5:30. The slave is in AWS RDS which runs in UTC. The slave is primarily used for running for SQL queries ...
0
votes
4answers
168 views

Amazon: How to change database name in Amazon RDS MySQL?

I want to change MYSQL database name of the DB instance of Amazon RDS. How it can be possible?
1
vote
2answers
25 views

Is it safe to delete the innodb schema on a new Amazon RDS instance?

As per the title, I'm struggling to find out if it's safe to delete the innodb schema that's created on a fresh Amazon RDS instance. mysql> SHOW DATABASES; +--------------------+ | Database ...
3
votes
1answer
135 views

MySQL RDS Instance eating up memory and swapping

I have an issue with memory on a RDS instance which is of db.m2.4xlarge class. Below are the specifications of the RDS instance Instance Class: db.m2.4xlarge ( 68.4 GB of RAM ) Engine: ...
1
vote
1answer
102 views

Finding reason behind high write IOPS on MySQL (RDS) server

I am having performance issues with an AWS RDS instance (running MySQL 5.6). This is the backend db to an XMPP server called Tigase. According to Tigase Inc. this type of db instance should be able ...
0
votes
1answer
104 views

Amazon RDS CPU Usage keep increasing without any long running process in Show Processlist

We are using Amazon RDS(db.m2.2xlarge), CPU usage is suddenly increasing gradually even after we reboot the DB Server. This is happening just past 2 days and we didn't give any new build recently. I ...
0
votes
0answers
36 views

Why does Amazon RDS memory utilization drop and disk space utilization rises?

I encountered a problem with my Amazon RDS(db.m2.2xlarge) where DB connections spiked up and my website started responding slowly. On looking up the metrics I was not sure why my freeable memory shot ...
0
votes
0answers
35 views

MySQLDump and Amazon RDS

I need to dump the contents of an RDS database into a SQL file, and restore that file to another RDS or MySQL instance. On the RDS instance there are a number of databases and users, and I would like ...
0
votes
2answers
90 views

What is the best choice for MySQL high availability (zero downtime)? [closed]

As I know there are many solutions for MySQL HA, but most of them are congenitally not zero downtime solution, like MHA, AWS RDS... That said, if zero downtime is "must have", the only choice is ...
0
votes
2answers
83 views

MySQL Community Edition Capacity

I am using MySQL Community Edition on Amazon RDS service. It is a very large database, 2/3 tables has about 10 millions records and 4-5 tables has 7-8 millions records. Questions How much capacity ...
0
votes
1answer
119 views

What is default MySQL binlog retention in AWS RDS?

I tried to retrieve my MySQL RDS binlogs in order to run manual "rollback" for some SQLs. Unfortunately, I noticed that only 2 binlogs for the last 30 minutes are available. "call ...
0
votes
1answer
102 views

Unable to migrate local database to RDS instance

I recently created an MySQL instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance from the MySQL command line. I will brief you the details. 1) I want to move/migrate my ...
1
vote
1answer
1k views

Aborted connection (Got an error reading communication packets) MySQL on Amazon RDS

I'm getting the following warning in MySQL: Aborted connection (Got an error reading communication packets) I'm using Amazon RDS for MySQL hosting. Both MyISAM and InnoDB storage engines are ...
0
votes
0answers
150 views

How to improve performance of large table in AWS MySQL RDS instance?

I am unfortunate enough to have a somewhat large, unoptimized table: +-------+--------+-------+------------+---------+ | rows | data | idx | total_size | idxfrac | ...
0
votes
0answers
78 views

Connection occasionally fails connecting to MySQL on Amazon RDS from PHP

We're moving MySQL databases from our own EC2 instance, to a multi-zone RDS instance. These are accessed from a load balanced lighttpd + PHP cluster. We've noticed that quite often, in the morning, ...
1
vote
1answer
538 views

How to decide whether to enable MySQL query cache using InnoDB

How should the decision to enable / disable the MySQL query cache be made, on a server that uses just InnoDB tables. Say for example, if the cache is enabled, then how should the output of: SHOW ...
2
votes
2answers
289 views

Amazon rds MySql -> concurrent connections deadlocks

I normally hang around in StackOverflow but I think this issue is better suited here. I've built an application in C#.NET that uses MySql as a database. My application inserts and updates data in the ...
2
votes
1answer
345 views

Replication from EC2 Master to RDS Slave - Connecting to master

I am migrating my company's database from an EC2 instance to an RDS instance. I have already migrated a snapshot of data and am now trying to set up replication to get the data that has been added ...
0
votes
1answer
110 views

Is it possible to recover from a LOST_EVENTS incident from an RDS read replica?

I was setting up a read replica of an RDS database for a reporting project, and issued an incorrect GRANT statement when configuring a user. My RDS read replica stopped, with an error message on the ...
3
votes
1answer
912 views

Amazon RDS mysqbinlog “Could not find first log file name in binary log index file”

Preamble: We use RDS at AWS to manage our MySQL database. I know that RDS creates binary logs used for replication.. I want to harvest these binary logs and store them on S3, so that at any time, i ...
2
votes
0answers
175 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
0
votes
0answers
32 views

RDS did not restore to a specific point-of-time on my MySQL instance. Why did that happen?

I'm using a MySQL 5.6.13 instance on RDS and accidentally wiped all the data in it (something like 2.5GB). I used the restore to point-in-time feature to recover all the data and it only recovered the ...
0
votes
0answers
61 views

how to archive old entries from mysql on rds

I have an AWS RDS MySQL DB. I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest. I'm still new at this so I'm not really sure what to do. What ...
0
votes
1answer
31 views

Managing deleted entries in large database table

Currently we are using Mysql 5.6 with Amazon RDS. We have table tracking uploads and we have a deleted flag in this table, we don't delete rows when a user subsequently deletes an upload. We do this ...
2
votes
3answers
407 views

Amazon RDS - and binary log rotation

New to RDS (used to having my own server in my own data center). We are on MySQL 5.6 on RDS. when a slave gets behind in replication lag, the master ceases to rotate out its binary logs. It is, ...
1
vote
1answer
986 views

Amazon RDS - Can't access MySQL DB from local machine

I read many questions/answers here but they are from a different interface from AWS Console. I created a DB Instance but can't create a rule in the security groups that's allows me to connect from my ...
0
votes
1answer
109 views

I have delete database from mysql but storage is not freed

I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage? I have a mysql database that the total ...
0
votes
2answers
478 views

Why is my RDS mysql slow query log full of server restarts?

One of my RDS mysql databases is giving me warnings about the slow query logs taking up significant space. The logs are rotated once an hour, and contain a dozen repetitions of: ...
3
votes
1answer
176 views

AWS RDS showing large growth in Write Ops/sec, despite low # DB connections?

I have a Multi-AZ AWS RDS instance running MYSQL 5.5 I've noticed that my write ops/sec are growing fairly rapidly, despite low (and sometimes zero) DB connections - see charts for Avg write ops/sec ...
4
votes
1answer
2k views

What is the optimal way to upgrade production RDS instance?

I have MySQL small RDS instance as part of my production system and I want to upgrade it to medium instance with provided IOPS. As old-school DBA I'm aware about "add slave; promote to master; ...
0
votes
1answer
217 views

What happens when the index size of my Mysql instance exceeds the innodb_buffer_pool_size?

I am using Amazon's RDS db.m1.small. innodb_buffer_pool_size is set to 1125.00 MB. Current index size is 1110.00 MB and growing slowly but steadily. I do not need more hard drive space. I want ...
0
votes
0answers
106 views

INSERTS in a loop: Better to use NOW() for each row or PHP date() function once?

Consider a PHP application which inserts about 200-800 records in a loop via prepared queries and parametrized values. The PHP application is on Amazon Web Services, and the database server is in ...
1
vote
1answer
614 views

Can I see the status of a “repair by sorting” in mysql?

I am running an alter statement on a very large table. show processlist shows the state as "Repair by sorting". Is there a way to see the status, or get an estimate of how much work has been ...
0
votes
1answer
224 views

What performance should I expect from MySQL (Using Amazon RDS)

I'm trying to understand whether I'm doing something wrong, or expecting too much. I have an InnoDB table on a db.m1.large RDS (MySQL 5.6.13. 7.5 GB RAM) with ~1M rows. The primary key is a ...
0
votes
1answer
2k views

Not able to login on MySQL in AWS RDS using root

I am trying to connect my MySQL RDS from EC2. Under security groups I have made sure permissions are in place. $ mysql -h xxx.xyz.ap-southeast-1.rds.amazonaws.com -P 3306 -p Enter password: I am ...
3
votes
2answers
1k views

Stored procedures, binlog and SUPER privilege

I tried to create this function on Amazon RDS for MySQL: CREATE FUNCTION GetRootZoneId (zoneId INT) RETURNS INT READS SQL DATA BEGIN DECLARE _id, _parentId INT; SELECT zoneId INTO _parentId; ...
1
vote
2answers
2k views

How can I synchronize data between two RDS MySQL databases

I have 2 Amazon RDS MySQL instances, one is MySql v5.5 and the new one is 5.6. I want to upgrade the 5.5 to the 5.6 but you cannot do upgrades at this time, so we are trying to migrate the data. I ...
0
votes
1answer
135 views

Looking for suggestions to Migrate Amazon RDS Large Instance to non-amazon host - Live

We have an Amazon RDS Large instance with a database of about 20GB that needs to be migrated without having to take our website down or minimize downtime to less than a couple of hours. And I am ...
2
votes
1answer
138 views

Is there a way to achieve Workload Management in MySQL?

Is there a way to set up Workload Management in MySQL (in particular v5.5 on AWS RDS)? By Workload Management I mean the functionality implemented in e.g. Teradata, RedShift that allows ...
1
vote
0answers
60 views

MySQL hang during “show collation” on Amazon RDS

MySQL is hanging when I try to do SHOW COLLATION on my Amazon RDS instance. I can use SHOW COLLATION fine with my local database, and other SQL commands work fine on my RDS instance. But Amazon SHOW ...
1
vote
0answers
191 views

MySql Very Slow Writes & Out of memory error

I am having a rds db instance in AWS which is used by Drupal 7 instatllation. I am getting the below error messages in the log: > 130912 11:57:39 [ERROR] /rdsdbbin/mysql/bin/mysqld: Out of memory ...
0
votes
2answers
1k views

MySQL : Extract SQL statements from binlog

I am trying the following command to extract SQL statements from binlog for using it in another database (Amazon RDS) mysqlbinlog /var/lib/mysql/binlog.000027 --start-position=54375264 ...
5
votes
2answers
5k views

How can I determine how many IOPs I need for my AWS RDS database?

I am migrating part of a mysql database into AWS. The data in question is 99% write, and each row has about 1k of varchar fields, a datetime and 4 ints. I estimate that we will need between 20-25k ...
0
votes
3answers
334 views

MySQL Large DELETE with JOINs

I have a large table players with ~20MM rows which joins to a table stats with ~300MM rows, among others (photos, ...). I want to DELETE all records for players that were born_on before 1950. I ...
3
votes
1answer
2k views

Create Table If Not Exists Hanging

I am still new to using databases, but currently I am using a mysql database and attempting to make my bash script unbreakable because it might be used in several different environments (dev, qa, ...
0
votes
1answer
2k views

Too Many database connections on Amazon RDS

We are having problems with users running queries/views in Drupal that occasionally cause our site to freeze. The freeze occurs because the query causes the number of database connections to go up to ...
5
votes
1answer
905 views

Best strategies to have a backup of an RDS MySQL database

I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited. I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup. I know ...
0
votes
1answer
727 views

Large INSERTs performance optimization

I have 15 Amazon AWS EC2 t1.micro instances which simultaneously populate Amazon RDS MySQL d2.m2.xlarge database with data using large INSERTs (40000 rows in query). The queries are send ...
8
votes
1answer
9k views

Should I increase max_connections in AWS RDS t1-micro for MySQL?

I have an AWS RDS t1-micro running MySQL 5.5. It gives me too many connections error. I checked and it allows 34 maximum connections concurrently. What I have read is that i can increase this max ...