Michael - sqlbot
  • Member for 9 years, 4 months
  • Last seen this week
  • Cincinnati, OH
Does requiring SSL matter if using AWS RDS and AWS EC2 in a VPC
4 votes

This question -- and its answer -- are primarily regulatory/compliance matters. If you need to comply with a standard that mandates encryption in transit between systems on the network, then you need ...

View answer
Why was default of innodb_file_per_table changed?
Accepted answer
4 votes

The default value has been ON, since 5.6.6. You're looking at the 5.5 documentation, which only refers to the defaults in 5.5 -- not 5.7. In version 5.5.7, a decision was made to revert the defaults ...

View answer
Remove duplicate terms from column
3 votes

As has been mentioned, the database is perhaps not the best place to accomplish this; however, it can be done, using a stored function. You wouldn't want to rely on this in a live environment, bit it ...

View answer
MySQL -> Loop through a table, running a stored procedure on each entry
Accepted answer
25 votes

Create a second procedure that uses two nested cursors. Cursors in stored procedures allow you to do a very non-SQL-like thing: iterate through a result set one row at a time, putting the selected ...

View answer
Is there any AWS RDS Utility to Manage Master Slave mysql db with read write splitting?
Accepted answer
1 votes

AWS does not have a service that provides this. Transparent, intelligent read/write splitting is a Hard Problem™ because there are so many details that can go wrong, such as queries that use ...

View answer
Denied updating a field that is modified within a BEFORE UPDATE TRIGGER
Accepted answer
1 votes

Your logic is inverted. You are setting synced to 0 if either column is not changed. The correct expression: IF NOT(NEW.FirstName <=> OLD.FirstName) OR NOT(NEW.LastName <=> OLD....

View answer
Mysql master-master: single table out of sync
0 votes

Assuming you set replication up correctly at the start, this kind of error suggests that you are using master/master in an unintended/unsupported way. Master/master does not support concurrent ...

View answer
What's the difference between POINT(X,Y) and GeomFromText("POINT(X Y)")?
Accepted answer
20 votes

There are two different binary formats related to the MySQL spatial extensions, the "well-known binary" (WKB) format from the standards, and the MySQL internal GEOMETRY data type. Prior to MySQL 5.1....

View answer
How to set MySQL binlog retention in hours?
4 votes

Percona Server supports max_binlog_files, which used in conjunction with max_binlog_size can keep the number of files (and their aggregate size) within a target range. Note that max_binlog_size is ...

View answer
Multiple DB restore in sequence
0 votes

My guess is that the MySQL client sends the whole SQL file to the RDS server and starts on the next SQL file, without waiting for the previous one to complete successfully. That is not the problem. ...

View answer
Stress Test to Saturate Memory for MySQL InnoDB
Accepted answer
3 votes

From Windows Platform Limitations in the MySQL 5.5 Reference Manual: On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. ...

View answer
Necessity of having two instances (Reader and Writer) in Amazon Aurora
Accepted answer
3 votes

Yes, you are paying twice for the instances, but only once for the storage, because they share a single Aurora cluster storage volume (there is only one volume per cluster), which is part of why ...

View answer
Is there a tool to check if my database is normalized to the third normal form?
Accepted answer
25 votes

Normalization absolutely is used in the real world... and hopefully you know that 3NF is only the third one of... what is is now, 8? But 3NF should be an easy target. However... I would venture to ...

View answer
Challenge with modelling a basic membership table
Accepted answer
0 votes

Approach 5: is_in_room_now TINYINT DEFAULT NULL, -- always either 1 or NULL UNIQUE KEY (user_name,chatroom_id,is_in_room_now) Nulls are not equal to each other, so you can have infinitely many rows ...

View answer
AWS RDS MyISAM tables from mysql and information_schema and good snapshots
Accepted answer
5 votes

The MyISAM tables in the mysql schema are fully supported in RDS snapshots. It's the MyISAM tables elsewhere that are potentially problematic. Never alter the tables in the mysql schema. That will ...

View answer
Use of GROUP_CONCAT on Mysql
5 votes

Your interests are generally not well-served by learning somewhat vague "rules" like "OR should be avoided" or "group_concat is slow." Neither is actually correct, they only have elements of truth ...

View answer
checking availability of rooms
4 votes

This is a somewhat common logical error. ('$checkin' BETWEEN start_date AND end_date) OR ('$checkout' BETWEEN start_date AND end_date)); The problem is not the way the query is written, it's that ...

View answer
The CPU utilization spikes to 80+ even with just one user on Amazon RDS (MYSQL INNODB)
2 votes

What you describe is the expected behavior. An m3.xlarge has 4 vCPUs (virtual CPUs -- and having 4 of these typically means two cores, each with two hyperthreads). 100% utilization means all 4 ...

View answer
Warning before issuing delete/update command in mysql/oracle , then executes
Accepted answer
3 votes

if i issue some delete/update command wrongly There is no such thing as a "wrong" delete or update command unless it is "wrong" in the sense of being syntactically invalid, referencing nonexistent ...

View answer
Create a New AWS RDS Instance of only one database from a snapshot
Accepted answer
1 votes

RDS Snapshots capture the entire server. There isn't a way to restore only one database.

View answer
How to take advantage of AWS EC2 instance store (SSD) in a database environment?
Accepted answer
0 votes

The ephemeral disk is excellent for exactly the two use cases you mentioned, swap and /tmp. Don't underestimate the performance benefits, here -- the ephemeral disks are not only SSDs, they're also ...

View answer
Index for date part of field?
Accepted answer
4 votes

The problem isn't the index. The problem is that your query as written does not allow an index to be used. Modify your query so that the date range is resolved to a pair of constants and the problem ...

View answer
sum() of column by distinct() id column
1 votes

There are multiple approaches, but one is to use a derived table, to allow two levels of grouping and aggregation. A derived table is a temporary table that is automatically materialized while the ...

View answer
Created RDS db-instance Replica successfully, now how to connect it with server
0 votes

What you are talking about is called Read/Write Splitting. This is not a capability directly provided either by MySQL Server itself, or by RDS for MYSQL. It is an advanced technique for which there ...

View answer
Fetch just inserted data in master/slave model?
Accepted answer
1 votes

This is often handled by the application actively choosing to read from the master based on context. A common example I've seen mentioned is a database of blog posts. *Viewing, a blog post would ...

View answer
ignore mysql schema on replication before moving from mysql 5.6 to mysql 5.7
Accepted answer
1 votes

Should I need to ignore mysql db before upgrading mysql 5.6 to 5.7 on this slave? No, you should not. MySQL should handle everything correctly when the replica is newer than the master by not more ...

View answer
Error while restoring a Database from an SQL dump
20 votes

The reference to --binary-mode (introduced in MySQL 5.6.3) is probably a distraction. It doesn't sound like you're dealing with a mysqldump output file, there. Try the file utility. shell> ...

View answer
ODBC can't connect to internal MySQL without external network
Accepted answer
2 votes

For each new client connection, the server uses the client IP address to check whether the client host name is in the host cache. If not, the server attempts to resolve the host name. First, it ...

View answer
Amazon RDS Promote Db Read Replica to RDS Db Instance
1 votes

When I promote a read replica to a db instance, does it replace the main db instance from which it was a read replica or does it create an entirely new Db Instance? It does neither of those things.&...

View answer
Getting around MASTER_HOST length limit in 'CHANGE MASTER TO...'?
Accepted answer
1 votes

Create a DNS CNAME record in one of your own domains and use the cluster endpoint hostname as the target of the CNAME record. Then set MASTER_HOST to that alternate (shorter) name. MySQL has no ...

View answer
1
2 3 4 5
17