Author: Praveen GR

Feed: Planet MySQL; Author: MyDBOPS; In the previous blog, we have gone through about network-level security in RDS. In this blog, we will see about the Database level security in RDS. After network-level restriction to host, we can’t allow a user to connect to the database from anywhere over the internet. We need to restrict user access at the Database level as well. Need to create a user with a restricted host along with a strong password to avoid cracking of password. In RDS we have a special feature named Identity and Access Management (IAM). We need to monitor the ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Nowadays everything is getting digitalized and migration toward the cloud is at its peak. There is a high chance of data leaks if we don’t tighten the security of the Database servers. It is mandatory to secure the database by restricting access to Database. Although we have restricted the access. We need to monitor the activity of the user to prevent the unwanted usage of data. Security will be split into three layers Network-level security.OS level security.Database level security. OS level security will be handled by the AWS team. Since It is managed by the ... Read More

Feed: Planet MySQL; Author: MyDBOPS; We have planned for archiving the data to improve the DB performance and to reclaim the space. We were evaluating Compression in InnoDB and TokuDB. To find out the best compression method. We started benchmarking the compression ratio between InnoDB and TokuDB. Everything goes well for some time, but after a few hours got an error message that can’t able to insert the data into the TokuDB table due to storage being full. It is so strange and the host has enough free space. Table structure:- mysql> show create table mydbops.tokudbG *************************** 1. row *************************** ... Read More

Feed: Planet MySQL; Author: MyDBOPS; To copy the data of the particular column of the table to another table/server, We have an option to export the data as CSV and import the data back to a different table. But when the table size is large and we need to copy the data only for the required data to the target table will cause the load in the server since the table scanning is huge. To overcome this, we have the pt-archiver copy the data from the source table to the destination as a whole or only for required columns. And ... Read More

Feed: Planet MySQL; Author: MyDBOPS; We all tried various alternative methods for modifying the table structure, but pt-online-schema-change (pt-osc) is the most convenient and preferred method for performing the alter online. It has more granular control too. But it may lead to data loss if proper precautionary steps are not taken care of. In this blog, we are going to modify a column to a unique key using pt-osc, below I have shared the table structure. mysql> show create table testG * 1. row * Table: test Create Table: CREATE TABLE test ( Personid int(11) NOT NULL AUTO_INCREMENT, LastName varchar(255) ... Read More

Feed: Planet MySQL; Author: MyDBOPS; We all tried various alternative methods for modifying the table structure, but pt-online-schema-change (pt-osc) is the most convenient and preferred method for performing the alter online. It has more granular control too. But it may lead to data loss if proper precautionary steps are not taken care of. In this blog, we are going to modify a column to a unique key using pt-osc, below I have shared the table structure. mysql> show create table testG * 1. row * Table: test Create Table: CREATE TABLE test ( Personid int(11) NOT NULL AUTO_INCREMENT, LastName varchar(255) ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Aurora has a salient feature “Parallel query“, Which will be more beneficial for analytical workload environments. Before going to deep dive on this particular feature, let us understand the basis of Aurora. Aurora Archiecture Key feature The key feature of Aurora is simple data synchronisation among the nodes. The sync latency will be too low when compared to RDS because the synchronisation is happening on storage volumes among the nodes. Also all the server will available in different zone, even when a zone goes down we can able to maintain will other server present in ... Read More

Feed: Planet MySQL; Author: MyDBOPS; I was about to benchmark the various compression methods in MySQL ( Via Engines ). But i liked to simulate my own data set similar to a production work load. Well searched for a tool which should be flexible to enough make customised table structure and more. Mysql_random_data_load is a tool from Percona labs used to manipulate random data based on flexible table structure. This seems like a right fit for our benchmarking needs. Let’s explore this tool to work efficiently on it. MySQL Random Data Load : Mysql_random_data_load will load (insert) ‘n’ number of ... Read More