Developing a production database requires extensive optimization. With the growing concerns about data privacy and new regulations such as the Global Data Protection Requirement (GDPR), these databases must be created with privacy safeguards in place. You need to use a few different data anonymization techniques to accomplish this with a standard SQL database. SQL data … [Read more...] about Data Masking Pitfalls for SQL Data Generator Applications
sql
Getting Started with PostgreSQL Streaming Replication
In this blog post, we dive into the nuts and bolts of setting up Streaming Replication (SR) in PostgreSQL. Streaming replication is the fundamental building block for achieving high availability in your PostgreSQL hosting, and is produced by running a master-slave configuration. Read the original: Getting Started with PostgreSQL Streaming Replication Master-Slave … [Read more...] about Getting Started with PostgreSQL Streaming Replication
Data Integrity and Performance Considerations in MySQL Semisynchronous Replication
MySQL semisynchronous replication provides improved data integrity because when a commit returns successfully, it's known that the data exists in at least two places “ the master and its slave. In this blog post, we review some of the MySQL configurations that influence the data integrity and performance aspects of semisynchronous replication. We'll be using InnoDB storage … [Read more...] about Data Integrity and Performance Considerations in MySQL Semisynchronous Replication
SQL Performance Anxiety: Why Your Server Might be Running Slow
You're new to the SQL game. Maybe you just got hired for a new a job with corporate. Maybe you're running your own business. Maybe someone is just hitting you up for the customary Hey, you're a tech guy kind of questions. In any case, someone may be asking you to optimize a system you're just now familiarizing yourself with. And if you're reading this, then the problem you're … [Read more...] about SQL Performance Anxiety: Why Your Server Might be Running Slow
Why Perl 6 is Remarkably Robust at Handling Big Data Sets
Perl has undergone a massive overhaul over the last year. Perl 6 was released last December. It's virtually unrecognizable from previous versions of the 15-year-old programming language. There are a number of updates Perl programmers should be aware of. Among the most significant is the emphasis on big data. Brian Kelly, The main developer of FullAuto said these applications … [Read more...] about Why Perl 6 is Remarkably Robust at Handling Big Data Sets
