Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive
As the AI revolution surges forward, promising significant innovations, it also introduced new types of vector databases. A vector database stores data as high-dimensional vectors called embeddings, which are mathematical representations of features or attributes...
10 Considerations for Architecting a Multi-Cloud Database
Thinking about architecting a multi-cloud database? It’s an increasingly common topology nowadays. The adoption rate of a multi-cloud approach has been growing fast for years. It’s a solid option for a disaster recovery plan (DRP)...
Best Practices for Scaling A Multi-Cloud Database Infrastructure
Scaling a multi-cloud database infrastructure can be a complex and challenging task, but it's essential for businesses that require high scalability, availability, and reliability. With multi-cloud becoming increasingly popular, organizations are leveraging the benefits of...
What’s new in SQL Server 2022
SQL Server 2022 is the latest database version released by Microsoft in November 2022. The release builds upon previous versions to add more choice for SQL Server users when it comes to development languages, data...
Need Performance Advice? Turn To ClusterControl!
If you frequently find yourself working with any kind of database, it’s natural that you might need some advice on how to deal with them at least once in a while. At present, you might...
MySQL Security with ClusterControl
If you are an experienced MySQL DBA, you probably already know how important MySQL security is. For you, security comes without any question - you already secured your database instances from the get-go: as soon...
The Common MySQL error: “Got an error reading communication packet”
MySQL is the second famous database in the world according to the DB Engine website behind Oracle. What makes MySQL famous is probably because it is a very fast, reliable and flexible Database Management System....
CCX for Technology Directors: What do You Need to Know?
Database-as-a-service solutions, at least as we know them, are shaking the market right now. However, before implementing one of such solutions into your company, you might wonder: why should I do it? What’s the benefit?...
Database as a Service Options in 2021: What’s Hot?
If you are a frequent reader of this blog, you probably know what database-as-a-service services are and how to best use them to achieve your database performance goals. Database-as-a-service options, as we have previously not...
Benchmarking databases 101 – part 1
Benchmarks are one of the activities that database administrators perform. You run them to see how your hardware behaves, you run them to see how your application and database work together under pressure. You run...
PostgreSQL and TimescaleDB backup restoration using ClusterControl CLI
Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. Backups are the basic way to keep it...
Database-as-a-Service (DBaaS) Solutions for Back-end Developers
Back-end developers usually focus on the “deeper” end of an application: while front-end developers focus on design, layouts, and the like, back-end developers are focused on the functionality that is mostly invisible to the end-user,...
Overview of Your Services: DBaaS vs. Manual Approach
If you are a developer or a database administrator, chances are that you need to take care of your databases at least on-and-off. The things related to your databases that need to be taken care...
Redis vs DynamoDB (a comparison)
What is Redis? Redis (which means Remote Dictionary Serve) is an open-source NoSQL database known to be a fast, in-memory key-value data store, cache, message broker, and queue. The project started by Salvatore 'antirez' Sanfilippo,...
Proactive Galera Monitoring (Developer Studio/Advisors angle)
Monitoring is one of the vital parts for many organizations. In fact, there is a role specifically for monitoring purposes. This proves that with proactive monitoring, a lot of things could be achieved including driving...
What’s new in ProxySQL?
Quite recently ProxySQL has changed the way it names new releases. To avoid confusion we’d like to go over it a bit. In the past, we had two branches: 1.4.x and 2.0.x where new features...