When to consider sharding a MySQL database
Why should you not just design your applications from the start to account for data sharding? Sharding a database, that is horizontally partitioning tables among multiple databases, creates an added level of complexity that is not desirable in an application. However, there are times when sharding is required to maintain acceptable performance. So when is the right time to shard your database?
This entry and my next will be a little different from what I normally write. This info comes from some research I did recently into MySQL.
The Three Major Areas of Difference Between MariaDB and MySQL
An unresponsive web site is as good as asking your customers to leave. According to surveys, almost 50% of web users expect a page to load in less than 2 seconds, and 4
What’s all the fuss about Big Data?
Big Data is the collective term for very large and potentially complex data sets that are deemed to be so large that it’s difficult to handle the data using traditional tools and applications such as Relational Database Management Systems. Scientists in the fields of physics, genetics and meteorology were previous examples of those that encountered Big Data.
My house butts up against a park. It's an animal and bird preserve and there s a spring that feeds the Alifia river.
I was sitting on the back swing with my younger son and something started shaking the bushes on the other side of the fence.We got to joking around and I said it was probably an escaped monkey. My older son came out and we started making jokes and decided it was probably a goblin.
From that I decided to write a short story
A table is the basic storage unit in an oracle database. A table stores the data that you think of when you think of a database.
A heap table is the default table type in Oracle. When we refer to a table, we are usually refering to a heap table. A heap table is just a table that stores the data in no partiuclar order. It just heaps the data on.
A heap table can be a relational table or an object table. A relational table is a t